User Community

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…

Order Dimension Tables

Is there a way to order the tables in Pyramid? I want them in a specific order not alphabetical order.

• Answered