Latest Activity

Time Intelligence - Trading Calendar injection

i am looking for a way to let the Time intelligence function use my customer's trading calendar instead of the Gregorian Calendar.

Order Dimension Tables

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

Filtering Based off of Measures and Totaling

I have a report that needs to be built where two of the measures that I am looking at, cannot equal 0 when they are added together. I created a new column to total them so I only have to filter on…

Group Dimension Elements

Hello, How can I group in the report some elements? I have a field with A, B, C, D, E and F, and I want to create an extra field with value XX when field 1 is a, B or C,…

• Answered

How to remove border in mini-tab

Hi Team, Is there a way to remove the border in mini-tab. Thanks, Raveena

Enable email templates

Hi Team, Can we enable a specific email template for one workgroup without making it the default for all workgroups? Thanks, Raveena

Pyramid MHTML File Support and Format Retention

Hi Team, Does Pyramid Support MHTML files if so how we can retain the format? Thanks, Raveena

Pyramid Learning Hub Help

My colleague sent an email to learninghub@pyramidanalytics.com on Monday and then on Tuesday after recieving no response, he created a support ticket only to be told "Our technical support team…

Exporting Multiple Discovers to a Single Excel Sheet

Hi, I want to collate multiple discovers onto a single page and export them into one Excel file. The export should appear as shown here, where each table represents a separate discover.…

• Answered

Bringing in slicers as columns in Drill Down report

Hi, Can we configure an action on a Present so that, when it navigates to a Discover via actions, the slicers are passed through as columns in the destination Discover? Thanks, Raveena

• Answered

For certification

How will I log in to Pyramid Analytics for certification? And I can practice also.

• Answered

Exporting Multiple Discovers to a Single Excel Sheet

Hi, I want to collate multiple discovers onto a single page and export them into one Excel file. The export should appear as shown here, where each table represents a separate discover.…

• Answered

Conditional Formatting Not Working

I am encountering an issue with conditional formatting not applying to cells that use the INDEX(MATCH()) excel formula. The formatting works correctly in Tabulate mode,…

DateDiff documentation says "dy" for days, but Custom Column only accepts "dd"

Hello PA Team, I found an inconsistency between the PQL documentation and the actual behavior of DateDiff in a Custom Column. https://help.pyramidanalytics.…

• Answered

Export to Excel

Hello, I am trying to export a Publication to Excel and want to maintain the layout of my page. Specifically: I have three reports/grids on a single Publication page, but when exporting to Excel,…

• Answered

Model Mapping between OLAP Cube and InMemory

Hello everyone, my aim is to map a slicer over two different models. One is a OLAP Cube and the other one a InMemory model. In both models I use the exact same Slicer "Buchungskreis ID" And also the…

• Answered

How do I categorize a column into groups?

I am trying to build a formulate to categorize our bank products and bucket them together. What syntax or method should I use? CASE( CONTAINS([product], “Checking”), “Checking”, CONTAINS([product],…

• Answered

Continuous date table

Hi All, I want to include a continuous date table in the model and I am looking for a function similar to Dates = CALENDAR(DATE(2019,01,01), Date(YEAR(TODAY()), 12,…

• Answered

Use one date to filter multiple fields

Hello, We are trying to make it so that a user can select a single date and it will filter the data similar to this where clause, replacing the ? with the date: where trans_date<=?…