-
Dynamic “initial price” driven by a user-selected date filter
How do I calculate a dynamic “initial price” driven by a user-selected date filter? Background I have a receiving ledger with a few million rows of receiving entries.…
-
"Model", one word and many meanings
When working with Pyramid Analytics we often mean different things when we refer to “Model” or “Data Model”. In this post I will clarify the main distinctions between the different model terms.…
-
Is there a PQL equivalent to the MDX Generate function?
I have a report that I am trying to build that will display a current year period and a prior year period. The user needs to be able to select a date range.…
- Answered
-
How to configure Dashboard slicers to work with Tabulate slicers?
I have a tabulate that contains 2 discovers, both filtered by a date. I grab one of the rows from the second discover and place it at the bottom of the first sheet and create some calcs.…
-
Error in interaction between two calendar filters
Hi all, i have the following problem - error in interaction between two calendar filters. How to reproduce the problem: 1) Create a calculated measure. 2) Create a visualization with two date filters.…
-
[Bug] Unpivot Settings causes a gray screen in Model
Hi Pyramid Team, I can reproduce a UI crash in Model when opening the settings window for an Unpivot node. Scenario: ClickHouse > Table > Unpivot Steps to reproduce: Create a new model.…
-
Issues with $0 values exported as $ in Excel export of a Publication
Hi, I have measures in my publication that display values as $0. When I export the publication to Excel, the values appear as just $ without the 0. I have attached screenshots of both the publication…
- Answered
-
Unique features of Pyramid Analytics?
Hello All, I am new to Pyramid Analytics. I wanted to explore it. How Pyramid Analytics is different from other tools/technologies available in the market? like Power BI or Tableau or Oracle BI?…
-
Using the API to return the PQL or MDX of a Formulate
I have a need to retrieve a list of formulas from our instance that includes the name, description and the actual logic for documentation purposes. I have figured out how to get the first two items…
-
How can I proactively identify content that overloads runtime servers?
Hi Pyramid Team, I am looking for recommendations on how to proactively identify Pyramid content that may overload runtime servers. I had a case where opening a specific content item caused very high…
Content aside
-
Read More