Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

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).…
- Senior Director of Product
- 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.…
- Senior Director of Product
- 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.…
- Senior Director of Product
- 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.…
- Senior Director of Product
- 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…
- Senior Director of Product
- Ian_Macdonald
- 3 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).…
- Senior Director of Product
- Ian_Macdonald
- 3 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…
- Senior Director of Product
- Ian_Macdonald
- 3 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…
- Senior Director of Product
- Ian_Macdonald
- 3 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…
- Senior Director of Product
- Ian_Macdonald
- 3 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…
- Senior Director of Product
- Ian_Macdonald
- 3 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
- Senior Director of Product
- Ian_Macdonald
- 3 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…
- Senior Director of Product
- Ian_Macdonald
- 3 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
- Senior Director of Product
- Ian_Macdonald
- 3 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.…
- Senior Director of Product
- Ian_Macdonald
- 3 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.
- Senior Director of Product
- 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
- Senior Director of Product
- 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.…
- Senior Director of Product
- 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.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Adding Countries to recognised countries
Hi Gen, The shapes Pyramid uses to colour in a named country are derived from MapBox rather than defined by Pyramid. MapBox is the underlying mapping service used by Pyramid.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Trellis - why the 4 column limit?
Hi Adam, There isn't any limit, except maybe practical considerations. Make sure you click on the "Scale to Fit" option to see all the trellis values: Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
OK. I'll DM you to set up a call. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Partial Model Update in IMDB
Each Data Flow in the Master flow will have its corresponding Model (make sure you add the "Model" block to that data flow in the Master flow so that when you double click it,…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Partial Model Update in IMDB
Hi Moshe, Yes. In your master flow, you create multiple data flows, each of which loads from different source. You then run none, one or more if them based on a variable value or other test set…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
Err... Yes. The revised calculation takes into account the fact that it is not a simple cumulative total, but that the result the calculation for one row feeds into the calculation for the next row.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Partial Model Update in IMDB
Hi Mosche, You can do this today using Master Flows. This allows you to test conditions and run particular data flows depending on the outcome. Check out the Office Hours recordings,…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view

1 16 17 18 19 20 21 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Listing all the dimensions of a hierarchy in a Discovery

Re: Listing all the dimensions of a hierarchy in a Discovery

Re: Text to Dynamic Caption

Re: Values appearing as -0 for one user, when they should be %

Re: How to create a loss triangle in Pyramid Analytics

Re: How to create a loss triangle in Pyramid Analytics

Re: How to create a loss triangle in Pyramid Analytics

Re: Adding a custom map

Re: Overlaying columns/bars with integrated variances (IBCS)

Re: PQL Custum Measure: modify value before passing to aggregation

Re: Adding "All" to a slicer

Re: Python

Re: Parse excel doc

Re: Python and Excel

Re: Showing a comparator "geography type" in a chart

Re: How can I convert date hierarchy into specific format?

Re: Totals of sets

Re: Totals of sets

Re: Adding Countries to recognised countries

Re: Trellis - why the 4 column limit?

Re: Cumulative Rate Changes

Re: Partial Model Update in IMDB

Re: Partial Model Update in IMDB

Re: Cumulative Rate Changes

Re: Partial Model Update in IMDB

Home