Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Filter a second dimension based on the value of a first dimension in Discover
Hi @Malcolm Green Ok, buckle up because this is going to be a wild ride! Let’s take a step back and consider the problem. While the Date dimension has Development Months 1 – 19,…
Attachment
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Hi @Malcolm Green This is quite tricky. The triangle bit is straightforward (BTW a simpler Left Outer join on the Year and Month is all that is necessary),…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Comparing dates in a formula
Hi @Robert Clark You must remember that the Pyramid models are dimensional in nature. Thus, each dimension (hierarchy/attribute) is independent of the others,…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Hi @Malcolm Green Could you post here your excel sheet that contains the data used in your example above? Or more if you have it. I can then replicate your model and see if I can provide an answer.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Help Getting Stacked Bar Plot to Use a Consistent Set of Colors
Hi @Alexander Khater Yes. Go have a read up on Pyramid Member Color Lock. that should give you what you want. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Monthly percentage of annual value
OK, I've created a periods dimension of Quarter number, Month and Day number. Build a % Total Measure that is Sales / Sales for all four quarters. Then add Year as a filter in your Chart to show the…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Monthly percentage of annual value
Hi @Josephine I'm not sure why the context (visual) calcs are not showing up as expected, maybe your profle has then turned off. Anyway, you can chieve what you need by selected the "Ancestor" option…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: create hierarchy without access to the model
@Ricky Melamed Unfortunately, no.
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Configuring FTP Source with Host, User, and .ppk File
hi @Raveena Mariappan It doesn't appear so. There is no option in the Data Source Card for FTPS to add a .ppk file. Sorry. Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Show Data for the most recent full week
@Ray Buechler BTW... Outside of the Pyramid Usage model shipped with the product, any access to the Repository tables are not supported. Thus there is the potential that should the repository schema…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Show Data for the most recent full week
@Ray Buechler In your model, sort the Year Weeks by the Week Start Date column from Time Intelligence;
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Need help with Dynamic Place Holder - Adddays (business days) to date
Hi @Jashanpreet Sandhu OK, so if your Model only contains working days, with no weekends or public holidays, then you can use that to determine the comparative period rather than trying to calculate…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Show Data for the most recent full week
The Week Year sort is defined in he model and gives the correct sequence, so no sorting is required: Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Need help with Dynamic Place Holder - Adddays (business days) to date
Hi @Jashanpreet Sandhu What do you mean by business days? Not including weekends? Or accounting for public holidays? (That gets v complicated as it depends on which country the user is in.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Show Data for the most recent full week
Hi @Ray Buechler Easiest way is to use dynamic lists. Create a list of all the Year Weeks: Then filter for the Last 2: Then filter for the First 1: Then use this list in your Discover: Now,…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Need help with a new list
@Obee1 Fair enough!
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Need help with a new list
@Ricky Melamed Not much difference really. Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Metadata Management for Data Governance
@Mad Amruthur As mentioned above, the integration needs to be FROM the meta data management tools, rather than us building a connector TO them. We're monitoring this scenario and are reviewing…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Metadata Management for Data Governance
Hi @Mad Amruthur No replies in a month so marking this as answered (i.e. no answers forthcoming). Best option would be to approach those meta data management companies and ask them to integrate with…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to get a Discovery Bar Graph to Sort by One Specific Group ?
@Ricky Melamed By using the new Sort Wizard, as above or in the Panel as you would in 2023. Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to get a Discovery Bar Graph to Sort by One Specific Group ?
@Alexander Khater In fact, you can do this in the Sort panel in 2023 without creating the new Measure: My bad! Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Need help with a new list
Hi @Ricky Melamed You'll need to create a Custom Column to do this, essentially building a new "Number" dimension that maps to the letters as you have described them.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: How to get a Discovery Bar Graph to Sort by One Specific Group ?
OK, So in 2023 you have to create a new measure for one of your series and sort by that. Here's Manufacturers sales split by Gender: Create a custom Measure of Sales for Males:…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to get a Discovery Bar Graph to Sort by One Specific Group ?
@Alexander Khater You mean 2023.17.029?
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Need help with a new list
Hi @Ricky Melamed I'm sorry, but I don't understand what it is you are trying to achieve. Can you explain in a different way? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view

1 3 4 5 6 7 30

Back to top

Home

View all topics