ObeeOne's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Anon

Country

Latest Posts

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
- 4 days 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
- 13 days 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
- 1 mth 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
- 3 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
- 3 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 5 mths 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
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Let's talk about Dimensions and Measures
IMO, Pyramid's interface for traversing the semantic model is easily one of the best in the market, if not the best. Regardless, there are a variety of claims in the posting that need to be…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Need help with a new list
I would suggest this optimization, building on Ian's formula: Case([Sheet1].[Letter]="B",7,[Sheet1].[Letter]="C",8,[Sheet1].[number]) so if its "B", set to 7, if its "C" set to 8,…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 5 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Filtering on 2 dimensions and counts
@Malcolm Greentry this out, maybe it does what you're after. create a new date table: either a new real table; a new database view; or as a virtual table in Pyramid's table editor view using custom…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Calculation of a ratio
@Jona Löneke use IF statements to check if the current account is a specific member. Notice the OR statement "||" and the "NULL" value. if( ([DimAccount].^[DimAccount Hierarchy].…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Calculation of a ratio
@Jona Löneke its quick and easy if you know how............. It sounds like you simply want to divide a measure value for the current account by the value of its parent account.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 6 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Netto_workdays
@Stefan La Rooij create a "custom column" calculation in Formulate - which does the raw difference between the dates in these 2 columns (in SQL). Once you have the difference at the row level,…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Need guide on 2025 Feature || Delayed Slicer Execution
click the help link click on the "advanced settings" link in the first note. look for a section called "auto run"
- Redeemed from the Dark Side (Power BI)
- Obee1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Need guide on 2025 Feature || New option to print a single visual in a presentation, rather than the entire slide.
click the help link scroll down to the bottom of the help page or look for "printing specific visuals" in the floating menu.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Building cascading filters/slicers that contain only relevant values of charts at the presentation layer
@Shuvankar Mondal You should build lists or sets in the Formulate tool. Here, you can build logical constructs and use those lists to populate your slicers / filters with what you need.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: How to do Window Aggregation calculation?
For the record, there are "Window" functions for context calculations - which is a specific family of calculations that are dependent on how they are deployed in a give report. You can see them here.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Is there a way to apply Dynamic Masking (or something similar) to Measures?
@Alexander Khater if you are going to mask the measures, just leave them out of the grid. What good are they if they cannot be read? You can use a formula without including the measure visibly in the…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Error When Adding Web Panel In Present
@Cindy Tran it's because some sites will not allow themselves to be embedded in other sites. Google is a very good example of a site that blocks itself - and Wikipedia is a good example of a site…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to Limit Color Logic to a Single Column
@John Fonte This can be easily done through the context menus (rather than the drop zones) as shown below. Here, choose the driving data point, rather than the entire measure.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Concerns about Python Access
@Dmitri Kanounnikov It depends what you think your tenants should be able to do or not. But you cannot have it both ways - you cannot insist on giving your end users access to powerful features and…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view

1 2

Back to top

Home

View all topics