Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Object Renaming Does Not Work in the Search Panel
Hi @ALN Please raise this as a support ticket so that we can reproduce, track and potentially address it. Thanks. Ian
- VP Product Management
- Ian_Macdonald
- 6 days ago
- Questions & Answers
- Reported - view
Re: Order Dimension Tables
Hi @Kristen Sinkiewicz Unfortunately not. I suggest you raise it as a feature request Regards, Ian
- VP Product Management
- Ian_Macdonald
- 6 days ago
- Questions & Answers
- Reported - view
Re: Time Intelligence - Trading Calendar injection
Hi @Darren Tuffs @Jan Steenkamp We'll take a look at your suggestion, but realistically, the number of possible permutations and definitions of custom calendars makes this a very difficult…
- VP Product Management
- Ian_Macdonald
- 6 days ago
- 1
- Questions & Answers
- Reported - view
Re: Need Help Creating Dynamic Previous Month Sales, Current Month Sales & Growth % in Pivot
Hi @sanjay Create a Model Parameter using all the dates in your Date dimension: Sum all the Dates in the month using the Date Parameter to give the Current Month.…
- VP Product Management
- Ian_Macdonald
- 6 days ago
- Questions & Answers
- Reported - view
Re: Creating a group folder
Hi @Jona Löneke Unfortunately, the feature you are looking for does not currently exist. I suggest that you open a feature request in the Current Product Ideas Forum for future consideration.…
- VP Product Management
- Ian_Macdonald
- 6 days ago
- Questions & Answers
- Reported - view
Pyramid 2025.10 Newton - Another set of customer requests delivered!

The following list enumerates all the new features implemented in Pyramid 2025.10, a minor feature release for Pyramid 2025 Newton. Over 60% of the 50 delivered features are built from feature…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- 1reply
- 239
- 5
- Tech Blogs & Webinars
Re: DateDiff documentation says "dy" for days, but Custom Column only accepts "dd"
Thank you @TKH TKH, we'll fix it.
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Export to Excel
Hi @Josephine This is not supported. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Model Mapping between OLAP Cube and InMemory
Hi @Jona Löneke You need to map the captions, not the unique names. You can tell it is using unique names from the breadcrumb on the first grid in your screenshot.…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Continuous date table
@Patrick Fernandez Yes, ages ago! Hope that helps! Ian
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: YTD Formula in PQL
Hi @Jona Löneke All of the "to date" function blocks need to work on a DATE, not a month name, week number or anything like that. So first off, create a parameter based on a Date hierarchy.…
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Date dimension from SSAS model not seen as a date in Pyramid
Hi @Michael Connelly It may be designated as a date in your underlying data schema, but as a dimension / hierarchy / attribute in the cube semantic model, there is no concept of a date/time datatype,…
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: NLQ with Pyramid Internal Chatbot
Hi @Mad Amruthur The internal Pyramid LLM does not send any data outside the Pyramid environment. Yes, it uses the Semantic Model meta data which can also be enhanced with additional synonyms for…
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Ordering the Months
@Ricky Melamed Use the Sort dialogue, then sort by Member Key in order High to Low (Z-->A). Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Ordering the Months
@Ricky Melamed So in reverse order? Or standard order with just the latest month/year at the top?
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Ordering the Months
@Ricky Melamed Can you give me a bit more context? Thanks. Ian
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Bug Report - Critical Excel Export Failures
Hi @TKH TKH Please open a support ticket with our Help Desk. Thank you, Ian
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Adjust width for text indicator
Hi @Ricky Melamed Can you show more of your working, i.e. drop zones etc.? When I add Text indicator I can change the column width with no problem and if I make it too narrow,…
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Query the Pyramid Database to find Data Interaction Setting Between Report Items
Hi @Bruce Campbell I've sent you a PM on this. Cheers, Ian
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Query the Pyramid Database to find Data Interaction Setting Between Report Items
Hi @Bruce Campbell I don't think this is possible, but I'll check. It will require a specific SQL query to be created by our Dev team if it is. I'll keep you posted. Ian
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Multilevel Sankey
Hi @Michael Connelly Unfortunately, no. You can do multi level Sankey charts by creating multiple Sankey charts where the target of one becomes the source for the next,…
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Median with SQL Server direct query
Hi @Michael Connelly Quick method, right click on the Measure concerned and select Create Measure --> Aggregate --.> Median This will create a new Measure, Median,…
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Alternative to SQL Window Functions in PQL
@Namratha Pesarla BTW, there isn't a context function to generate row numbers directly, but if you create a constant Measure with a value of 1, you can use the Cumulative context function on that to…
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: How to create dynamic range slicers that change min/max values based on another parameter?
Hi @Oren Mkrtchyan Create a parameter based on your Period Column, having the values of Month or Week. Create a dynamic list of the Rank column (note: it is defined as an attribute / dimension,…
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Alternative to SQL Window Functions in PQL
Hi @Namratha Pesarla In Pyramid, these are known as Context Calculations. See this Help page for details. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view

1 2 3 4 5 30

Back to top

Home

View all topics