Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How to bring up a second filter/slicer when selections are made in the first one?
Hi @Rory Sinclair , Your explanation is a little confusing. Can you try again and maybe my feeble brain can understand what you are wanting Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Present
- Reported - view
Re: How to do an outer union in Pyramid?
Hi @Raveena Mariappan Use the JOIN Block and specify "Full Outer Join" in the join type: It doesn't matter what the join fields are. You can see the data from both tables stacked in the preview pane.…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: disable Welcome Screen for all Users
Hi @b hoppe It is not possible to disable the initial welcome screen globally when a new user logs into Pyramid, although there is the "Don't Show Again" checkbox, bottom left,…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: How to use the 'Execute JavaScript Action' Click Action to Modify a Filter
Hi @Alexander Khater If you use individual images of the separate parts of the body, those can be used directly rather than superimposing the transparent rectangles.…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 2
- Questions & Answers
- Reported - view
Re: MTD YTD QTD manual functions
No reply for more than a month. Marking as answered.
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: How to use the 'Execute JavaScript Action' Click Action to Modify a Filter
Hi @Alexander Khater “Execute JavaScript” is not the right way to go to achieve what you are after. This Jump Action is designed to run JavaScript code,…
Attachment
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How to use the 'Execute JavaScript Action' Click Action to Modify a Filter
Hi@Alexander Khater , When you say "sets a filter on the Discovery to a specific value", do you mean a slicer or a variable value filter on a measure? Ian
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: How to Set a Default Size For Pop Up With IFrame
Hi @Alexander Khater Unfortunately it is not possible to specify the size of the popup window when using the "Jump to URL" > "Popup in iFrame" action. You can however use the "Execute JavaScript"…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: how do i get a shapefile for rainfall station and data for Negeri Sembilan, Malaysia
Oh, I found this very quickly. You're welcome! :) https://infobanjirjpsns.water.gov.my/Rainfall/District/8 Ian
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: how do i get a shapefile for rainfall station and data for Negeri Sembilan, Malaysia
Hi @isma You can search online for geojson shapefiles of Malaysia. I found this page with minimal effort: https://simplemaps.com/gis/country/my#admin1 Download it and follow the instructions for…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How to replace a string cell with a text value using Calculated Column
Hi @Roman Lyakhovsky Are you trying to replace the values as part of a Data Flow in your model? If so, you could use a PQL expression such as if(IfNull([Size],-1)=-1,"No Data",…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Seeking to Apply Security to End Users on 'Analyze Further' option for discovery
Hi @Alexander Khater Rather than restricting the content based on calculated filters etc., where you need to restrict access to specific rows based on the user id,…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Improved Support for Data Models with Different Granularities
Hi @TKH TKH Why complicate things with a bridge table? It's not needed. Just join your calendar table to your Actuals by Date and your Plan by Month, either the 1st of the month date or the year…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Headcount from the previous month automatically updated on the 1st of the month
Hi @Frédéric WILHELM Here's a solution using dynamic lists. It relies on the fact that you never have a headcount measure value for a future date. Create a Formulate list using your model.…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Headcount from the previous month automatically updated on the 1st of the month
Hi @Frédéric WILHELM From your post and the code you quoted, I deduce that you are working with Analysis Services using MDX. Analysis Services does not have a DateTime data type.…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Headcount from the previous month automatically updated on the 1st of the month
Hi @Frédéric WILHELM Just to clarify, you want the headcount as of the previous DAY, or the headcount of the previous MONTH? Do you have an existing Measure of headcount? If you do,…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Having trouble to make an average over a created column
Hi @Friedrich Schmid , OK. Your issue in your example is that you are basing the last six months off the current member, which is defined by your slicer.…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Having trouble to make an average over a created column
hi, @Friedrich Schmid Are you wanting to display the average across six months for each day of the month? So for example, the average value of Day 1 over the six months? Please clarify. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: String Display
@Sanjai Sorry, I missed a "d" in the function name. It should be FormattedData(0,3) If you right click on the cell in question, you can pick the function off the list.
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: IN operator in Pyramid Formulate (Custom Column)
Hi @Mad Amruthur , Try HasItem(). See Help: https://help.pyramidanalytics.com/Content/Root/developer/reference/fx/PQL/Common/String/HasItem.htm?Highlight=hasitem Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: String Display
Hi @Sanjai Try FormatteData(0,3) instead. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Incorrect handling of strings with different cases in in-memory
@TKH TKH It is the underlying database that defines how Pyramid's queries are interpreted. For example, when populating a slicer, you can configure if the Pyramid query uses Group By or Distinct to…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Reuse Data Models to Build other data models.
Hi @Cesar Jaitman Labaton Take your data flows for the products and finance models and change the target so that they write their tables of data to the same database.…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Ability to make number of user inputs dynamic
Hi @Pranoy Karun Vijay , You can use the advanced search option available in multi select slicers to enter lists of values to match to the slicer values: Like Christian,…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Is there a way to communicate with external models real-time
Hi @Pranoy Karun Vijay The short answer is no. You could potentially take your value and pass it to some external system via a parameterised HTML link in a Web window on the slide and that web page…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- 1
- Questions & Answers
- Reported - view

1 3 4 5 6 7 26

Back to top

Home

View all topics