Michael Raam's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Bank Discount Israel

Country

Latest Posts

Re: Union of custom columns (Static Values)
Hi, Although true multi selections on measures is not supported. If you need a dim named "Measures" , you could consider to create it via a file ( Excel , CSV ) and uploaded it to the model.…
- Michael_Raam.1
- 3 wk ago
- Questions & Answers
- Reported - view
Re: KPI Chart
Hi, Here is a little example. image
- Michael_Raam.1
- 1 mth ago
- Questions & Answers
- Reported - view
Re: KPI Chart
hi, You could also overlap the chart ( disabling axis and such ) over an illustrate or report and get a similar result. You can group them as well in order to control them together.…
- Michael_Raam.1
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Is there a way to create a parameter for a user to choose the time display (eg month, quarter, year)?
Hi, You can consider also creating a date hierarchy and navigate the levels ( year, month, day ) via the parameter selection.
- Michael_Raam.1
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Model management tools
Hi, What you can do with existing functionality is: 1. Export the data catalogs from model ( Json file ) and compare for: - tables - columns - display names 2.…
- Michael_Raam.1
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Paging for long tables
found this article on the site, still works. https://community.pyramidanalytics.com/t/63m9n2/mdx-driven-paging-mechanism I'll open a FR for this issue
- Michael_Raam.1
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Paging for long tables

Hi, We are in the process of converting a legacy system to Pyramid and are facing a challenge regarding long tables over 30K rows. We don't want to show long table and are looing for a way to load…
- Michael_Raam.1
- 1 yr ago
- 2replies
- 61
- Questions & Answers
- Answered
- Answered
Re: Delete vs Purge ???
Hi, We have a scenario where Pro users can not Purge content in their personal folder, although it is according to the documentation it seams restrictive for the personal folders.…
- Michael_Raam.1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: LineBreak in a measure
Hi, The solution I found was to handle the line break at the DB level, and use an aggregation like "Max" on the measure
- Michael_Raam.1
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
LineBreak in a measure

Hi, I'm trying to create a measure to be used as tooltip and it could contain text that is long. Is there a way to add a line break or new line in the measure via a PQL formula ?…
- Michael_Raam.1
- 1 yr ago
- 3replies
- 61
- Questions & Answers
- Answered
- Answered
Re: Use a formulate to set the default parameter value
Hi, Another option you may consider is to create a set with an order that will bring the needed default item to be the 1st item in the set. Use the set as the source for the slicer / parameter and…
- Michael_Raam.1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Sort a hierarchy using multiple measures
hi, Consider the option to create a special sort measure that will be based on the other measures and produce the needed sort order. Example: [Sort measure] = [measure A] * 10000 + [measure B] * 100…
- Michael_Raam.1
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Pyramid Usage Model and Analysis
Hi, We are using the usage model and it is very useful. We started using the mobile devices for Pyramid in addition to the desktops, how is it possible to see the usage driven by mobile vs the…
- Michael_Raam.1
- 2 yrs ago
- Tech Blogs & Webinars
- Reported - view
Re: Running Oracle Procedures inside a Model
Hi, You may need to alter the logic of the procedure to push the data in to a table, instead of returning a data set, and then run a sql select from the table with the data.…
- Michael_Raam.1
- 2 yrs ago
- Questions & Answers
- Reported - view
Auto rotate between mini tabs

Hi, Is is possible to automaticly rotate between mini tabs, in a similar way we can auto rotate between pages on a datshboard ? Tnx, Michael
- Michael_Raam.1
- 2 yrs ago
- 1reply
- 25
- Questions & Answers
- Answered
- Answered
Re: Bell curve graph
Hi, You need to know your math and statistics , but here is an example.
- Michael_Raam.1
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Sourcing Reporting Services Output in a Data Model
Hi, If SSRS does not allow to read the data with out downloading the file, you need to check the SSRS documentation, than you can consider the following.…
- Michael_Raam.1
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: how can i insert a 60 second pause before next iteration of while loop??
hi, You can create a loop in master flow and have one of the steps in the loop do a wait vs the DB source you use or use one of the PQL time functions for the sleep / wait.…
- Michael_Raam.1
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Discovery Data Catalog Export
Hi, If you want to know what table a column is coming from, one option is to open a custom member / measure in script mode and drag the column into it. The table name should be visible as a part of…
- Michael_Raam.1
- 2 yrs ago
- Questions & Answers
- Reported - view

Back to top

Home

View all topics