Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How to enable SSL on Pyramid website and forward all HTTP request to HTTPS
Hi Robin, Check out our Help for instructions on how to configure NGINX for use with Pyramid in a Linux environment. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Security
- Reported - view
Re: Merge separate lines into one single line whilst retaining separated stacked columns
Hi Ben, Unfortunately, using Claim Type in the Color Drop Zone will always split the measures into the different values of Claim Type, so you will always get a line for each claim Type showing the…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Publications- One attachment for multiple selections
Exporting to Excel does not replicate the layout of the page, rather it outputs each analytic view on its own sheet. Thus in the example above, yes, the grids for 2021 and 2022 will appear on…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Sankey Chart - Source and Target Same Dimension
Hi Nick, Any update? If not, I'll close out this question and mark it as Answered. Cheers, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Publications- One attachment for multiple selections
Hi Sophie, Publish is behaving exactly as expected and designed. With two slicers attached to the Publication, it will generate a report for each unique combination of slicer values, i.e.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Equivalent to SUMPRODUCT in Pyramid
Funny you should mention that, we're currently preparing for SOC II certification. Part of the audit is that every employee has to have taken product training through the LMS. So I have go do it..…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Equivalent to SUMPRODUCT in Pyramid
Hi Nick, There are two ways of doing this, depending on your model structure. 1. Using two flat dimensions We need to get the list of shops for each type, for each shop calculate profit*ratio,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 3
- Questions & Answers
- Reported - view
Re: Date Formats in Exported Excel Files
Hi Sophie, When working with dates in calculations in IMDB or other SQL database based model, Pyramid makes use of a SQL Date type field that represents dates as an number (usually the number of…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Multipage Repeater
Hi Nick, You mean like this? https://community.pyramidanalytics.com/t/60h5as0/repeater-selection If so, vote for it and we'll assess the feasibility. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Sankey Chart - Source and Target Same Dimension
Hi Nick, Any update on how you want this chart to look? Or shall I close this item? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic year range on loss triangle
Hi Ben, While you can certainly use multi level Hierarchies as parameters, currently the Hierarchy Tree in the drop down widget visualisation is not supported for Parameters.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic year range on loss triangle
Hi Ben, OK, making some assumptions here: 1. When you say "Cube" data you are referring to SSAS OLAP or Tabular cubes; 2. You want to display the Range to be dynamic based on the first and last year…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic year range on loss triangle
Hi Ben, Have you also tried the "Show Empties" button on the Query Toolbar? This will force rows and/or columns to be displayed even when there is no data within them: Hope that helps,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic year range on loss triangle
Hi Ben Or indeed the ending year if there have been no claims or premiums? Or does it not matter at the start and end, only the inner range? There are numerous ways to approach this,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic year range on loss triangle
Hi Ben, It's not clear from your description what the desired output should be. Do you want the years between the start and end years where there is no data filled in with zeros or do you want the…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Change path of Discovery in Presentation
Hi Angeline, I don't believe there is a way to do this. Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Variable List Measure, of a Variable List Measure
Hi Nicholas, You're nearly there! Create a Global Parameter set as discrete options and add the text and returning value you need: Create a dynamic list,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Parameterised Year To Date
Hi Ben, Ok, great! We could use either the hierarchy or the full year month attribute. I tend to prefer using hierarchies as they give more flexibility in handling and navigating the data in our…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Parameterised Year To Date
Hi Ben, From your code I see you are using SSAS. Can you tell me what attributes / hierarchies you have available in your Dates dimension? I'm guessing you have a Full Month, i.e.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Sankey Chart - Source and Target Same Dimension
Hi Nicholas, You can use the same dimension in the source and target of Sankey Charts, but of course then whatever members you select will appear on both sides of the chart.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Custom Groupings
Hi Ben, OK, so do you need any further help on this? Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: PQL Date Query
Hi Dan, Here you go. I'm assuming you have a dimension of something like [Full Month Name] which contains members such as [Feb 2022] and one of [Year] which contains members such as [2022].…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: PQL Date Query
Thanks Dan, Can you please tell me the data source type, SQL or MDX? Does the Month / Year item make up Date hierarchy? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Custom Groupings
Hi Ben, I'm not sure that I quite understand what you are trying to do. Can you give me a bit more explanation? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Displaying two grids as 1
Hi Satveer, The only way for them to be in the same table (grid) is for the selected items to be in one query. To get the second column, the % for C, you will need to create that calculation in the…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view

1 16 17 18 19 20 26

Back to top

Home

View all topics