Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Calculating a CLV measure
Hi Kate, Is the above possible? We need a little more information to be able to help you effectively. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Truncating decimal numbers in dimensions
Hi Sophie, In your data flow in the model, add a calculated field into the table that contains the Rate field, Format it using the Format() function. This will format the decimal to the required…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, Create a new member in your [Core Reference] Dimension, like [My Calc] such that it equals: ([Core Reference].[Singular Core Ref - Latest YOA],[Measures].[Amount CAD])/ ([Core Reference].…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, The expression I provided returns a string. Use ConvertToNumber() to change it into a numeric and it will then work. BTW, I would be interested in what your final calculation is.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, Here's what I've come up with. Consider this grid: As per your example, I want to find the number of the column that contains the last non null value for a specific row moving form left to…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, Just so I am sure, you want the column number that contains the last occurrence across the row of a value for both AmountCAD AND CAD Developed % Latest.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, Can you be a little more precise in how the specific column is selected? Must all the rows be populated with values? Is it the column with highest total of values? Or both?…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Great! I still think there is something not right with the data though, or maybe just that it is represented in a different way than my example, as I did not need that kind of logic to suppress…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Calculating a CLV measure
Hi Kate, Can you give an example of your data and the calculations you want to perform and how you want to present them ? Maybe some dummy data in excel or something. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Hi Rob, I can only surmise there is underlying data present for some reason. If you create a report with Date of Loss Year and Development Period both on rows and use the raw data measure that you…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Combine members of different dimensions as a new dimension
Hi Dolf, I suspect this is a calculation you would have to perform in the Data Flow for the model you are building. If it is an existing MDX based model (SSAS or BW) then it may not be possible.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Presentation has no charts due to measures calculated
Hi Kate, Can you please explain in a little more detail your difficulty? Maye with some screenshots to help us understand what your problem is. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Stacked and non stacked chart together
Hi Nick, Bit of a tricky one this, as while we can create composite charts of Line & Column, the stacked column chart is a variation of the column chart and we cannot currently create composite…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Europe Design Theme
Hi Kate, I've exported the Europe theme and attached it to this post. To import, from the themes section in Admin, click on Import theme: Hope that helps. Ian
Attachment
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Can you drill down by column instead of cell?
Hi Erik, To create a Variable List, or if you like, a List of Lists, you need to select more than one List to create the List of Lists. In your screenshot above you only have one list selected,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Measures/Dimensions caption translation
Hi Sergio, Can you explain a little more on why you cannot apply the English names in the meta data overlay to the USA role? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Listing all the dimensions of a hierarchy in a Discovery
Hi guys, Regular Hierarchies defined in Pyramid behave the same as hierarchies defined in a SSAS cube, in that as you drill up and down, the column remains the same (the hierarchy name).…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Listing all the dimensions of a hierarchy in a Discovery
Hi Anthony, I'm not sure I understand what you mean. If you are using a Regular Hierarchy you can drill up / down, expand down etc. to show whatever levels you want from the hierarchy.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Text to Dynamic Caption
Simply use the concatenation operator "+" thus: ToString(DateFormat(AddYears(Date(),-2), "YYYY") ) + " and prior" Note, DateFormat() returns a string, so the ToString() function is redundant.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Values appearing as -0 for one user, when they should be %
Check the Execution order for the calculation. Set it to some arbitrary value, if it isn't set or increase its value if it is. This forces one calculated member to be evaluated after another.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Hi Kate, So got around to this sooner than expected! Here's your Excel example, my understanding is you need to calculate the line in red. And there are two intermediary calculations in the two…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Hi Kate, OK, let's take the easy one first! To create the % Drop Off Triangle we need to divide the value for each cell by the corresponding value in Period 1 column for each row (Dates).…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Hi Robert, It depends to some extent on your underlying data as to how you approach this, but you will need two attributes to generate the triangle, the year in which the policies came into force…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Adding a custom map
Hi Adam, The error around "Some locations could not be successfully mapped" refers to the fact that the data value in your data cannot be found in the reference column of your custom map table that…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Overlaying columns/bars with integrated variances (IBCS)
Hi Markus, You can always create your own custom Chart using the Pyramid APIs and a suitable JavaScript program. The Pyramid charting engine is based on the D3 libraries so you can use examples from…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view

1 17 18 19 20 21 25

Back to top

Home

View all topics