Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Dynamic Caption for prior month
Hi Nicholas, You are very close! Your code as it stands will return the Member value for Feb 2023, not it's display caption. You need to add ".caption" at the end, like this:…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Auto rotate between mini tabs
Hi Michael, Unfortunately this functionality is not currently available. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Creating a dynamic parameter for a date range
Thanks for the clarification, very helpful. OK, this is an interesting problem, as you would like a single filter on year to apply to two sets of Ranges, but those Ranges are on different hierarchies,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Creating a dynamic parameter for a date range
Hi IT Support, Your logic is that from the given year, you want all dates before that for the start date and all dates after that for the end date, yet your example screenshot shows the last date for…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Dynamic list that returns latest four months based on current date
Hi Ben, OLAP cubes (SQLServer Analysis Services) unfortunately do not have the concept of a DATE type. The Names of the elements in your [GAAP Accounting Period] are simply strings, like [202303],…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Discovery Data Catalog Export
@Dave Carbery we may have a different approach / solution. Watch yhis dpace.
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Discovery Data Catalog Export
Hi Dave, Discover objects are not available as JSON exports. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: HR Cube - Absenteism hours - Formulate
The Limited Test Program is now running. You can access the resources (software, guides, introductory webinar and slides) here: https://www.dropbox.com/work/Pyramid%202023%20Limited%20Testing
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Group Measures Under Headings for Export
Hi Natalie, This is a creative, out of the box hack, but that's what you asked for! Find a dimension in your model that has few members, in this case I'm using the Channel dimension.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Data Mesh and Pyramid Analytics
Hi Mastaneh, According to Wikipedia, "Data mesh is a sociotechnical approach to build a decentralized data architecture by leveraging a domain-oriented,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Data Mesh and Pyramid Analytics
Hi Mastaneh, I'm not sure what you are referring to by "Pyramid packages", nor "implement a data mesh". Can you please provide a fuller explanation of what you mean? Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Use single measurement as a fixed / set Measurement AND as a Dynamic Measurement at row level or in Calculation
Hi Dolf, Obviously I don't have your OLAP cube to demonstrate, but I do have an OLAP cube that contains a measure of distinct count of customers which I can analyse by dimensions such as country or…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Possible to have an Embed Dashboard dynamically resize based on container dimensions?
Hi Jeremy, The tiled dashboard will fit to width of the container, but a regular fixed layout dashboard will keep its aspect ratio inside it. Please submit your requirements through the "Product…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to un-show header in a table
Hi Yvonne, One way you could accomplish this is to create a calculation that returns a value if the cell is not empty (i.e. the cells that get a background colour),…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How do I close "Analyze Further" after I use it?
Hi Gregory, I'm not sure what you are referring to when you say you want to close the Analyze Further pane and keep the report open. If you mean how do you close it and return to the Dashboard you…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Convert measure to dimension & measure
Hi Dave, You simply need to check the box in the first column of the Table in Model: Then reprocess the Model. You only need to process the Model, you don't need to rerun the Data Flow if it has one.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Comment modéliser mes données correctement
Hi Sonia, You need to use the Date Range source block in model to generate a Calendar table. Drag it onto your Model Flow canvas with your excel source and choose the date range you need in the…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: HR Cube - Absenteism hours - Formulate
Also, there is a new feature coming in Pyramid 2023 that will handle this scenario by setting the calculation to the underlying table rather than the semantic model.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Line Banding, different bandings for different classes. Swap dimensions.
Hi Nick, As NPANS says, Class A and Class B seem to be from the same dimension. If Class A and Class B are sets of members of the dimension Exposure, are you talking about colour coding with the…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to un-show header in a table
Hi Yvonne, The usual reason for wanted a column hidden is have the column affect the table in order to achieve the lower level granularity of the table without showing driving driving dimension,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: HR Cube - Absenteism hours - Formulate
Hi Nosikaa, Is your HR table ingested / loaded into a database using a Pyramid Data Flow? Or is it Direct Query into an existing database of some type? Calculations in formulate are what is known as…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: After focusing on a member in a Discovery, how do you unfocus?
Hi Rob, As you have observed, there is notification of the background filter if the single attribute member concerned is not represented on the grid. If it is on the grid,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: After focusing on a member in a Discovery, how do you unfocus?
Hi Rob, Is Line of Business Code attribute a multi select filter as well as being present in the columns? That's the only way I can reproduce your scenario.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Discover: sort isn't working as expected
Hi Yvonne, Yes, it is working correctly. Your measure, Average Score, is calculated for the scope you have defined. For each company you are showing the average for each area as different colours.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Official response
- Reported - view
Re: How to reset running total by a dimension value
Hi Robert, Here you go: If this is a Pyramid Semantic Model, you could also consider using the (relatively) new semi-additive Cumulative Aggregation option in the Model.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Official response
- Reported - view

1 10 11 12 13 14 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Dynamic Caption for prior month

Re: Auto rotate between mini tabs

Re: Creating a dynamic parameter for a date range

Re: Creating a dynamic parameter for a date range

Re: Dynamic list that returns latest four months based on current date

Re: Discovery Data Catalog Export

Re: Discovery Data Catalog Export

Re: HR Cube - Absenteism hours - Formulate

Re: Group Measures Under Headings for Export

Re: Data Mesh and Pyramid Analytics

Re: Data Mesh and Pyramid Analytics

Re: Use single measurement as a fixed / set Measurement AND as a Dynamic Measurement at row level or in Calculation

Re: Possible to have an Embed Dashboard dynamically resize based on container dimensions?

Re: How to un-show header in a table

Re: How do I close "Analyze Further" after I use it?

Re: Convert measure to dimension & measure

Re: Comment modéliser mes données correctement

Re: HR Cube - Absenteism hours - Formulate

Re: Line Banding, different bandings for different classes. Swap dimensions.

Re: How to un-show header in a table

Re: HR Cube - Absenteism hours - Formulate

Re: After focusing on a member in a Discovery, how do you unfocus?

Re: After focusing on a member in a Discovery, how do you unfocus?

Re: Discover: sort isn't working as expected

Re: How to reset running total by a dimension value

Home