Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How to create group headers for certain columns in Discover
Hi Divya, In your example above, this would represent Name and Address as two members of a different dimension to the dimension that contains the first, middle, last name and address fields.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Experience on Ipad's
Hi all, Please place any specific enhancements you think our mobile client requires into the Product Ideas forum. Thanks you. Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Excel Publication Name Date Format
Hi Natalie-Anne, Please submit this as a new feature request in the Product Ideas forum. Thank you, Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Time intelligence intervals
Hi, Simply create bins at the minute level to create ranges of minutes. Creating 4 bins against my minute attribute, generates bins for 0 - 14, 15 - 29 etc., i.e.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Difference actual week- week prev year
Hi Janine, Use the dynamic list editor to create a list of the last 6 weeks. Select this list to appear in your Discovery and select your Lag 1 calculation for the previous year.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Importing Smartsheet data into Pyramid
Hi Daniel, It seems CData provide a JDBC driver for SmartSheets. Check this out: https://www.cdata.com/drivers/smartsheet/jdbc/ Pyramid supports CData JDBC drivers as a custom connector.…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Content Master Page | Copyright Year
Hi Natalie-Anne, Yes, you can use Dynamic Text and calculations and grids on a Content Master, and hence yes, you can insert the current year. Here's an example:…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
How to get multiple measures on a Line Chart with 'Analyse Further'?

How to get multiple measures on a Line Chart with Analyse Further? Available in Pyramid 2023 and after When you start diving in to the Data deeper as a Pyramid Viewer or with a Pyramid Analyst…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 79
- 1
- Discover
Tips & Tricks: How to identify duplicated elements

How to identify duplicated elements? A recent Question on the Community asked what would be a good way to identify duplicates. E.g. where an Element has been assigned a Status twice where it only…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- 72
- 2
- Discover
Re: How can we have formulae appear in the text and a graph of the same data set appear in same discover.
Hi Chaitali, I'm not clear on what you mean. Can you show an annotated example? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
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
- VP Product Management
- Ian_Macdonald
- 1 yr 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…
- VP Product Management
- 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
- VP Product Management
- 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…
- VP Product Management
- 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
- VP Product Management
- 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.…
- VP Product Management
- 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.…
- VP Product Management
- 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
- VP Product Management
- 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,…
- VP Product Management
- 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.…
- VP Product Management
- 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…
- VP Product Management
- 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,…
- VP Product Management
- 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
- VP Product Management
- 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.
- VP Product Management
- 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,…
- VP Product Management
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view

1 10 11 12 13 14 26

Back to top

Home

View all topics