Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

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
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.…
- VP Product Management
- 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
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
OK. I'll DM you to set up a call. Ian
- VP Product Management
- 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,…
- VP Product Management
- 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…
- VP Product Management
- 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.…
- VP Product Management
- 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,…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Making a population pyramid chart - specify total for %, and reverse axis direction
Hi Adam, The Tornado chart was included in the 2020.11 release. It seems, for some reason, somehow, that the partners server has escaped the upgrade process!…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Trouble Drilling up
This is working as designed.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Switching from AD to SAML
Thread closed.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: #run_time_error
Thread closed.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Twitter Source questions
Thread closed.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: How to Update Pyramid 2018 to the latest version.
Thread closed.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Model Parameter Default Value
Not directly, but you could define a custom member "default" that is whatever the member is you want as your default and add that to the parameter list. Thread closed.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: user Profiles not working with AD-group-users
Please consult Help: https://help.pyramidanalytics.com/Content/Root/AdminClient/access/Profiles.htm?Highlight=profile Thread closed.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: data retrieval
Use Formulate to calculate current and previous week values based on a parameter of week number. Show these in your report. Select "Last" as the default wee number.…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view

1 19 20 21 22 23 24 25

Back to top

Home

View all topics