ObeeOne's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Anon

Country

Latest Posts

Re: CSV export to UNC path, licensing and permissions
For #3: the publication mechanism does not use parameters - because its supposed to run automatically. What we do as an example, is have custom members (formulas) that auto define the current period…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 5 days ago
- Questions & Answers
- Reported - view
Re: SSAS Model showing NaN where a zero is expected
"NaN" or "not a number" usually shows up when the value is a division by zero. That's what the cube itself would return. The Excel export probably re-interprets this as zero.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Bookmarks
Use mini tabs and the variation "conditional mini tabs"
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Use the same Scale on Y axis and Secondary axis
@Pedro
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Use the same Scale on Y axis and Secondary axis
The point of a secondary axis is that it has its own scale. If you don't want a different scale, put both measures on the primary axis.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Average and Median for the Dimension Value in a Frequency Table
If you simulate your example, and load the data with a granular key, you can achieve the outcomes you want, shown below using the built-in totals. This will work for both averages and median.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Dynamic “initial price” driven by a user-selected date filter
I believe this will work: In the semantic/data modeler in "Model", right click on the "initial price" column and change the metric to "First child." Redeploy the model and it should be done.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 mths ago
- Questions & Answers
- Reported - view
Re: PQL Formulates
You've told the query to find active users for 2 combined months. You also need to tell the query to split out your values by month. So put the months chip into an axis (drop zone - like rows) as…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Pyramid 2025.10 Released
Glad to see many new features, especially some of the big ones like formatting and in-place content from the content tools!
- Redeemed from the Dark Side (Power BI)
- Obee1
- 3 mths ago
- 1
- Product Announcements
- Reported - view
Re: How can we be able to get the recipient list in the email (Subscription and Publication)
You should use the logging mechanics of your email provider to monitor email distribution. For example with SendGrid - you can use its extensive email logging system to monitor your email flows.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 6 mths ago
- Questions & Answers
- Reported - view
Re: question about 'Distinct Count' total function by measure in Row Total
Distinct counting needs to be set up as a model measure. Then you simply use the standard "aggregate" total to get distinct totals. So, in your semantic model,…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: CSV Export Changes Column Order in Pyramid Discover/Presentation
If you export a tabular grid, the column order is correct. If you export a matrix grid, the dataset, driving the matrix is tabularized into a flat table - so it can be used properly as a CSV.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Top or Bottom X using a Parameter - TIP
A second route to the same outcome: Create various lists and save them as individual list items. (Top 10, Bottom 10, etc) Go into Discover, open the custom list tree in the hierarchy's elements tree.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 7 mths ago
- 1
- Formulate
- Reported - view
Re: creating a discovery with category sales and supplier sales without dashboard slicer messing up values
It sounds like you need to tweak the "interactions" in your presentation. Read interactions help and related topics found here.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Filter
@sanjay you should try out the Time Calc Wizard. It will help you build some of this logic and you can then edit it as needed.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Dashboard Gallery: Financial Services
@Jeff Truitt You can inset dynamic text into your dashboards as visible panels or the dynamic tooltip, then use the smart insight functions in PQL. See help.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 8 mths ago
- 2
- Pyramid Dashboard Gallery
- Reported - view
Re: Push Publications to an SFTP Site
You're looking for this File Distributions
- Redeemed from the Dark Side (Power BI)
- Obee1
- 9 mths ago
- Questions & Answers
- Reported - view
Re: Choose which 6 options are available on the popup
You can manually add your own buttons (text or graphic) and attach certain actions to them, as described here.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Dynamic formulation for full year / rolling 13 months
@Jona LönekeThere is a much simpler way of doing this - but it requires some formula logic. You need to use a parameter and a list and it should (hopefully) solve all the issues.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Pyramid 2025.01 Newton - More customer requests delivered!
Thanks Pyramid team. Many things here look great!!
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- 2
- Tech Blogs & Webinars
- Reported - view
Re: Remove "created on" and "slide number" from Present
Yes. You need to edit the master pages.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Calculate the number of days from a date to the current date
Try use the caption of the member and the "dy" day flag. The date member should be set to "currentmember" and the formula should produce a measure. This assumes that the member caption is a well…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Finding Numbers for Yesterday
@Stanley RothThis is another quicker technique that I use for similar activities: Open the Time Calculations Wizard Choose the attribute ("dates") Pick the logic you want ("Last Day") Choose the…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to rename the forecast label
You need to have an LLM and GenAI added to the solution.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@Luke Dyer this is standard behavior. It works like this in most high-end analytic engines, like Microsoft OLAP and SAP BW. You can try and write your own roll-up measure.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view

1 2 3

Back to top

Home

View all topics