How to enable Javascript

Latest Posts

Re: Auto rotate between mini tabs Hi Michael, Unfortunately this functionality is not currently available. Ian
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 3 days ago
- Q&A
- 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,…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 10 days ago
- 1
- Q&A
- 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…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 13 days ago
- Q&A
- 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],…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 13 days ago
- Q&A
- Reported - view
Re: Discovery Data Catalog Export @Dave Carbery we may have a different approach / solution. Watch yhis dpace.
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 3 wk ago
- Q&A
- Reported - view
Re: Discovery Data Catalog Export Hi Dave, Discover objects are not available as JSON exports. Hope that helps. Ian
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 3 wk ago
- Q&A
- 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
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 3 wk ago
- Q&A
- 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.…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 4 wk ago
- 2
- Q&A
- 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,…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 4 wk ago
- 1
- Q&A
- 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
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- Q&A
- 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…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- Q&A
- 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…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- Q&A
- 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),…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- Q&A
- 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…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- Q&A
- 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.…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- Q&A
- 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…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- 2
- Q&A
- 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.…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- Q&A
- 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…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- Q&A
- 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,…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- 2
- Q&A
- 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…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Q&A
- 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,…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 2 mths ago
- Q&A
- 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.…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 2 mths ago
- Q&A
- 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.…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Q&A
- 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.…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Q&A
- Official response
- Reported - view
Re: Make reports with no longer existing measures editable for a viewer license Hi Dominique, Rather than try to modify the analytic platform to cater for the fact that Measures in use by users are deleted deliberately, let's look at a more intelligent way to create the…
- Ian MacdonaldAdmin
- Team Lead - Product Management
- Ian_Macdonald
- 2 mths ago
- Q&A
- Reported - view

1 2 3 4 5 11 Next

Back to top

Admin

Ian Macdonald

Ian_Macdonald

Team Lead - Product Management

UK

668
177
6

Joined: 14 Oct 2016

Follow

Pyramid Analytics