Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

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.…
- Senior Director of Product
- Ian_Macdonald
- 2 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…
- Senior Director of Product
- Ian_Macdonald
- 2 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,…
- Senior Director of Product
- Ian_Macdonald
- 2 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,…
- Senior Director of Product
- Ian_Macdonald
- 2 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…
- Senior Director of Product
- Ian_Macdonald
- 2 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
- Senior Director of Product
- Ian_Macdonald
- 2 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,…
- Senior Director of Product
- Ian_Macdonald
- 2 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…
- Senior Director of Product
- Ian_Macdonald
- 2 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.…
- Senior Director of Product
- Ian_Macdonald
- 2 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.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Custom Groupings
Hi Ben, OK, so do you need any further help on this? Ian
- Senior Director of Product
- Ian_Macdonald
- 2 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].…
- Senior Director of Product
- Ian_Macdonald
- 2 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
- Senior Director of Product
- Ian_Macdonald
- 2 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
- Senior Director of Product
- Ian_Macdonald
- 2 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…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Changing Filter Type in Analyze Further
Hi Dan, Analyse further only offers drop down filter types. As far as I know there is no plan currently to provide the ability to place measures on secondary axes in Analyse Further.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: PQL Date Query
Hi Dan, Some clarification please. When you select the parameter, as Apr 2022, do you want the formulation to return the total premium changes for the whole of 2020, Jan through Dec, or 2021,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Grid Size and Scrolling
Note that the "Grab Bar" only appears if there are measures present, so you may have to add a measure, adjust the width of the dimension rows, then remove the measure if you are dealing with reports…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Grid Size and Scrolling
Hi Sophie, Position your cursor on the dividing line between your Dimension Rows and your Measures. You should see a "Grab Bar" appear. Click and drag that to the right to increase the area…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Select Current Year in a Discovery
Hi Sophie, Further to the above, note that there is a subtle difference between "YYYY" and "yyyy" when formatting a date to a year. "yyyy" gives the Calendar Year,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Select Current Year in a Discovery
Hi Sophie, You could create a list that contains the last but one year, by creating a standard list of all the years, then filtering that to get the last two,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Select Current Year in a Discovery
Hi Sophie, Can you confirm the database type you are accessing? Dates are one of those things that behave differently analytically between SQL (IMDB and other relational DBs) and MDX (SSAS and SAP…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Hi Sophie, I used background formatting rather than foreground as I found it easier to override the background then the foreground. I also found that using the Transaction in the Color Drop Zone,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Parameter Format
Hi Dan, Yes. And No. Set the Parameter type to be Continuous and set the lower and upper bounds and the increment. Then on the Default section, set the visualisation to Text Box and then set the…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Hi Sophie, What version of Pyramid are you using? The formatting panel as in my screenshot is available in 2020.20 and onwards. You access it by clicking on the format pointer,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view

1 12 13 14 15 16 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Dynamic year range on loss triangle

Re: Dynamic year range on loss triangle

Re: Dynamic year range on loss triangle

Re: Dynamic year range on loss triangle

Re: Dynamic year range on loss triangle

Re: Change path of Discovery in Presentation

Re: Variable List Measure, of a Variable List Measure

Re: Parameterised Year To Date

Re: Parameterised Year To Date

Re: Sankey Chart - Source and Target Same Dimension

Re: Custom Groupings

Re: PQL Date Query

Re: PQL Date Query

Re: Custom Groupings

Re: Displaying two grids as 1

Re: Changing Filter Type in Analyze Further

Re: PQL Date Query

Re: Grid Size and Scrolling

Re: Grid Size and Scrolling

Re: Select Current Year in a Discovery

Re: Select Current Year in a Discovery

Re: Select Current Year in a Discovery

Re: Group By option for grids

Re: Parameter Format

Re: Group By option for grids

Home