Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Netto_workdays
Hi @Stefan La Rooij Both dates? Are you wanting to compare dates from different date dimensions? Also, you mentioned in your post "cube". Is your data in an Analysis Services OLAP cube? Or Tablular?…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Exclude a specific relationship from a Discovery
Hi @itay karkason Further to Moshe's answer, you can use the "Prefix" option on your duplicated date table to change the name of the table and all it's columns.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Netto_workdays
Hi @Stefan La Rooij The example you give is creating arbitrary dates using DateTime() and AddDays(). There isn't a PQL Common DateDiff function that supports excluding weekends, outside of Tabulate.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Is there a way to disable the drop zone pop ups in Discover?
hi @Alexander Khater This is not currently possible. If this is important to you, please submit a feature request in the Product Ideas forum Thanks. Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Cohort Chart Analysis
Hi @Rebeca Figueroa Take a look at this post. About halfway down there is an example which I think closely matches what you are trying to achieve. LMK if this helps. Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Union of custom columns (Static Values)
Hi @Ananth Periyasamy Are you requiring the selection of groups of measures with a single click? For example with one click put all the outgoing Measures ,Expense, cost, Overhead, on the rows,…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Difference between the calculations
Hi @Shuvankar Mondal I thin it is also important to understand the three different levels of calculation in Pyramid. there are Granular Calculations Semantic Calculations Context Calculations…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Data Source with SSL
Hi @Andres Ventura Unfortunately we do not currently support a connection to MariaDB using SSL security certificates. Please submit a feature request in the Product Ideas if this is important to you.…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Hiding of Filters in Discovery
Hi @Jeevitha Create a custom member in the Product Sub Categories which is an aggregate of the items you DO want to be considered in the query. Where you have a large number of elements,…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Is there a way to apply Dynamic Masking (or something similar) to Measures?
Hi @Alexander Khater This is not currently possible. As you observe, Dynamic Masking works only with Dimension data. Blocking access to the underlying Measure through Measure Security also will not…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: The first workday does not appear as set up
Hi @Daniel Jaldin , @Michael Daun The First Workday in the Add Tenant dialogue has nothing to do with your models. If you consult the Help on this topic you will see that the First Workday sets the…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 2
- Questions & Answers
- Reported - view
Re: How to do Window Aggregation calculation?
Hi @Shuvankar Mondal We don't have a context calculation as a simple SUM for which you can adjust the window over which it operates. However, there is no need as this can be easily created using a…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Invitation to take part in beta testing of Pyramid 2025 Newton
@Darren Tuffs We're targeting 31st March 2025, subject to testing. Ian
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Product Announcements
- Reported - view
Re: Column width
Hi @Ricky Melamed You can resize the columns in exactly the same way as you do in excel. Position the cursor over the column dividing line, it changes to a double headed arrow,…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Rename the "Grand Total" name in a grid
Hi @Yolanda Heldsinger I don't think so, but V2020 was a long time ago. I would STRONGLY encourage your organisation to upgrade ASAP, as V2020 is end of life as of 31st March 2025 (in like 3 weeks!).…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: is there a way to calculate an mesure avarage for the last year from yestrday?
Marking as answered as no response from poster.
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Rename the "Grand Total" name in a grid
Hi @Yolanda Heldsinger Yes. Add your totals, then click on the down arrow on the "Totals" button and select Column Totals. Click on "Advanced" and you can add your own Sub total and Grand Totals text.…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: is there a way to calculate an mesure avarage for the last year from yestrday?
Hi @Irad The answer to your question depends on the data source you are using. To give you best answer, we need to know if it is an MDX based source (Microsoft Analysis Services (OLAP or tabular) or…
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Is there a way to calculate a date off of a date parameter?
Hi @Robert Clark To calculate it from the parameter do the following: Add a Member block on your Formulate canvas and select the Parameter (my dates are the start of the month, not the end,…
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Is it possible to connect a slicer to dynamic text within a tooltip in Present ?
Hi @Alexander Khater Yes, it is. Here we have an image and we're setting a tooltip on it in Illustrate. Enter whatever text you need, then add the Placeholder:…
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Pyramid 2024.01 LTS "Fibonacci" has been released

Pyramid 2024.01 LTS "Fibonacci" has been released. This is the first service pack for Pyramid 2024 which only includes fixes for key issues and security updates.…
- VP Product Management
- Ian_Macdonald
- updated 3 mths ago
- 338
- 20
- Product Announcements
Invitation to take part in beta testing of Pyramid 2025 Newton

Hello all who subscribe to this forum! We are continually working to make Pyramid the best platform in the market for solving the most difficult problems through industry leading analytics.…
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- 2replies
- 198
- 5
- Product Announcements
Re: Prioritize the Discover level over the Presentation layer when displaying or hiding specific dimensions using the Runtime Settings
Hi @Shuvankar Mondal This is working as designed. If you want a change or enhancement to this functionality, please submit your request through the Product Ideas forum. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Sorting Order gets disrupted when Swap dimension feature is in use
Hi @Shuvankar Mondal This is working as designed. If you want a change or enhancement to this functionality, please submit your request through the Product Ideas forum. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Ability to show just AI chat bot on Hub page
Hi @Robert Clark This functionality is in development and will be available in the next major release, Pyramid 2025 "Newton", due at the end of Q1 2025. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view

1 2 3 4 5 25

Back to top

Home

View all topics