Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
Re: PQL Custum Measure: modify value before passing to aggregation
Hi Frank, Using PQL in Formulate, you are creating what we call "Semantic" calculations. By this, we mean that the calculation context is the dimensional semantic model in Pyramid that describes the…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Adding "All" to a slicer
Hi Adam, Can you please clarify, do you mean a check box that selects all members, or an [All] member that is the aggregate of the members? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Python
Hi Konoha, It is very vague what you are asking for here. If your question is about Python coding techniques, you will probably be better served by submitting your question to a specialist Python…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Parse excel doc
Hi Konoha, Please see my response to your other query on this topic: https://community.pyramidanalytics.com/t/g9ht4c6/python-and-excel Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Python and Excel
Hi Konoha, There are many and varied Python packages for handling Excel files. Note that .xls and .xlsx are very different formats and require different Python packages to handle.…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Showing a comparator "geography type" in a chart
I think this has been answered / solved in other threads from what I have seen. Marking this as Answered.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: How can I convert date hierarchy into specific format?
Hi Philipp, What is the data source for your dates? Ian
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Totals of sets
Hi Maaike, Ah. Yes, it is a limitation in SSAS Tabular in that it sometimes chokes on creating totals that include calculated members that are totalled using the AGGREGATE function.…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Totals of sets
Hi Maaike, I can't seem to reproduce your issue. I created sets of members, then an aggregate of the set, combined it with an existing member and added totals.…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view

1 21 22 23 24 25 26 27

Back to top

Home

View all topics