Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: create hierarchy without access to the model
@Ricky Melamed Unfortunately, no.
- VP Product Management
- Ian_Macdonald
- 3 days 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
- 8 days 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
- 10 days 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
- 10 days 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
- 10 days 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
- 10 days 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
- 11 days 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
- 11 days ago
- 1
- Questions & Answers
- Reported - view
Re: Need help with a new list
@Obee1 Fair enough!
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Need help with a new list
@Ricky Melamed Not much difference really. Ian
- VP Product Management
- Ian_Macdonald
- 2 wk 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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 3 wk ago
- Questions & Answers
- Reported - view
Re: How to get a Discovery Bar Graph to Sort by One Specific Group ?
Hi @Alexander Khater What version of Pyramid are you using? Ian
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Hide/Show dimensions with slicers
Hi @Ricky Melamed That's certainly one way to do it and it allows you to be very prescriptive about what dimensions are shown. For full flexibility, users can access the right click context menu to…
- VP Product Management
- Ian_Macdonald
- 4 wk ago
- Questions & Answers
- Reported - view
Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed Use the RANGE function in combination with CurrentPeriod and Lag() to set the start and end of the range. Aggregate the days returned:…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Measure appearing in a separate row using lag date formulate
Hi @Jashanpreet Sandhu It appears in the John Smith row because that is the loan officer it is related to. Jane Doe doesn't have a prior period balance in the same way John Smith doesn't have a…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: create hierarchy without access to the model
Hi @Ricky Melamed This functionality is planned for Pyramid 2025.01, due end of June / beginning July. It will be known as Report Specific Hierarchies. While these will behave like any other regular…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Measure appearing in a separate row using lag date formulate
Hi @Jashanpreet Sandhu I don't understand. It IS showing in the same row as John Smith. Can you explain further? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Previous Month Dimension Value
Hi @Mad Amruthur You have to remember that Pyramid Models are Dimensional in nature. Thus each unique value in a column in the underlying table makes up the Members of Hierarchy based on that column.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view

1 2 3 4 5 25

Back to top

Home

View all topics