Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: number formatting: negative numbers in parentheses
Hi Mathias, This feature was introduced in Pyramid 2023.10 in December 2023. You may need to upgrade your installation to see this functionality. Regards, Ian
- Senior Director of Product
- Ian_Macdonald
- 11 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Show an average of the selected members of a filter.
Hi Jair, Yes, you can do this quite easily in fact. The trick is the use of a dynamic list driven by a parameter and a calculated member in the same dimension using the same list to calculate the…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Use one chart to filter (not just highlight) other charts
@Anne Seaman You can edit the font of the breadcrumb trail (the filter values passed across) in the Panel settings. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Use one chart to filter (not just highlight) other charts
Hi Anne, Yes, there is a setting to accomplish this. Where you have created an interaction between analytic objects that share the same dimension, the default is to highlight but other options are…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 4
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
Hi Malavika, Yes, it is planned for the next release, which hopefully will be with you in early December. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Previous Month Value
Hi All, There was an identified issue with using Lead(), Lag() and other relative position calculation functions with Custom Columns prior to Pyramid 2023.01.063.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
Hi Malavika, Currently this is not possible in Pyramid, as it requires a pseudo recursive expression, i.e. the results of the first expression are fed into the next expression etc.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Measure Waterfall chart operational in version 2020
Hi Dave, Any response to Mark's question? We'll mark this query answered in a week if there is no further response. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Connection Oracle Essbase
Hi Gerardo, I'm marking this as "answered" as no one has responded after 3 months. Generally, SQL is a poor way to query Essbase. Essbase is a multidimensional database,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Sorting with Trellis
Hi Katie, Yes there is, but it kind of depends on the order in which you apply the sort vs the trellis. We'll create a bar chart of manufacturers' sales for each year, each year sorted independently.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Paging for long tables
Hi Michael, If you're talking about tables in Discover, there is no 'paging' mechanism available, we fetch and display all the records in one go. The only option would be to define some kind of start…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Live Connection SAP BW - Extrapolation of Budget values to a monthly split (linear)
Hi Tobias, Apologies for the slow response! I don't have a SAP BW cube with appropriate data, so I've used an Analysis Service cube, which uses the same MDX calculation language as SAP BW,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Can I create a custom hierarchy of measures
Hi Christopher, No, we do not support hierarchies in the Measures dimension. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Percentage points change calculation
Npans is right. Don't forget when you are subtracting 12.2% from 12.7% you are in reality subtracting 0.122 from 0.127 which is 0.005.
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Percentage points change calculation
Hi Katie, Your description doesn't match your example, so it's a bit confusing what you are doing. However, if Last Year Week Ending and Current Year Week Ending are also calculated items,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to calculate an average at a lower Time level of detail than a Discovery
Hi Steve, Easiest way to do this is to create a regular hierarchy in your model Month --> Weeks called, say, [Month Weeks], then use the following expression in the Measures dimension:…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Table of Contents UI
Just as an aside, this is exactly the way the ToC works in Microsoft Word. It is based on blocks of text defined as Headings, 1,2,3,4, etc. The font, point size, colour etc.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Using SQL queries to build reports
Hi Laura, Only indirectly through Model as you have observed. However, there is a shortcut here, whereby you can create a quick direct query model based on a custom SQL query when you open Discover.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Preset number of Y ticks in advance
Hi dgf, The actual, absolute size of the rendered content can be defined when it is embedded in a Dashboard or a Publication. Outside of that, setting absolute size has no relevance. Hope that helps.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Inserting a blank column
Hi Amy, Simply create a new Measure that does not contain any values, in my case I'm calling it 'Blank': Then place it in your grid where you need the empty column: Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Rename an element?
Hi Dave, No, not in the same way. The reason is that the names of the members of a hierarchy are, in fact, the data coming from your underlying table. So you would effectively be altering the data in…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
How to add subtotals for % Values to sum up to 100% in the category

Question: How to add subtotals for % to sum up to 100% for the category In a recent internal discussion we came across this question and wanted to share the solution to a broader audience.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1reply
- 167
- 5
- Discover
Re: Data bar indicators in discovery matrix grids 'didappaear' when all metric values are negative
Hi Dave, I've reproduced the issue with similar data to the example above. This appears to be a bug. Can you please open a support ticket by emailing support@pyramidanalytic.com.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Building Custom Filters
Hi Laura, How do you measure "Activity"? Do you have a Measure that contains the hours attended by course or something like that? Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Is there a way to add a discovery to a tabulation without it merging fields?
Hi Robert, Yes. Instead of using a Matrix Grids, use a Tabular Grid. Here's a standard Matrix Grid: Right click on the Grid Icon in the Visualisations Bar and select Tabular Grid:…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view

1 6 7 8 9 10 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: number formatting: negative numbers in parentheses

Re: Show an average of the selected members of a filter.

Re: Use one chart to filter (not just highlight) other charts

Re: Use one chart to filter (not just highlight) other charts

Re: Cumulative Rate Changes

Re: Previous Month Value

Re: Cumulative Rate Changes

Re: Measure Waterfall chart operational in version 2020

Re: Connection Oracle Essbase

Re: Sorting with Trellis

Re: Paging for long tables

Re: Live Connection SAP BW - Extrapolation of Budget values to a monthly split (linear)

Re: Can I create a custom hierarchy of measures

Re: Percentage points change calculation

Re: Percentage points change calculation

Re: How to calculate an average at a lower Time level of detail than a Discovery

Re: Table of Contents UI

Re: Using SQL queries to build reports

Re: Preset number of Y ticks in advance

Re: Inserting a blank column

Re: Rename an element?

How to add subtotals for % Values to sum up to 100% in the category

Re: Data bar indicators in discovery matrix grids 'didappaear' when all metric values are negative

Re: Building Custom Filters

Re: Is there a way to add a discovery to a tabulation without it merging fields?

Home