GENERATE({ @DateRange }, { ParallelPeriod([Book Date].[Hierarchy].[Year], 1, [Book Date].[Hierarchy].CurrentMember) })

This would loop through all the dates in the parameter and go back to the same periods in the previous year.  I'm not sure how to do something similar in PQL.

For example, I want to show a report that compares the data for dates 1/1/26 through 5/31/26 to data for 1/1/25 through 5/31/25.  

 How would I do this in PQL?

I can reproduce a UI crash in Model when opening the settings window for an Unpivot node.

Scenario:

ClickHouse > Table > Unpivot

Steps to reproduce:

1. Create a new model.

2. Add a ClickHouse source.

3. Select a table from the ClickHouse source.

4. Add an Unpivot node after the Table node.

5. Select the Unpivot node.

6. Click Settings in the Unpivot properties panel.

1.

 2.

 Expected result:

The Unpivot settings window opens and I can configure the node.

Actual result:

The settings window starts loading, then the whole Model screen turns gray. The interface does not recover. The only way to continue working is to refresh the browser page.

The issue is reproduced when clicking Settings for the Unpivot node. I will attach screenshots showing the model flow before clicking Settings and the gray screen after clicking it.

Source type: ClickHouse
Flow: ClickHouse > Table > Unpivot
Pyramid version: 2025.10.005

Thanks

How Pyramid Analytics is different from other tools/technologies available in the market? like Power BI or Tableau or Oracle BI?

What are the unique features that makes PA is more powerful than other tools?

getFormula

It claims to return the PQL or MDX representation of the formulate object. There is no sample of what the output looks like so I am wanting some confirmation that this is what I want before figuring out how to implement the code.

For example, let's say I have a custom formula/measure that is defined as a ratio and was built in Formulate using the Growth template in the Marketplace (A-B)/A. Would this API call return the actual column names seen in the Syntax Preview?

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 view & the exported Excel view. How can I fix the zero missing in the Excel export.

Thanks,

Raveena

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 memory usage on runtime servers. The runtime machine became almost unresponsive because of memory exhaustion, and requests routed to that runtime started hanging.

My question is about prevention. I want to understand how an administrator can find this kind of risky or inefficient self-service content before it affects the environment.

Questions:

1. Are there built-in admin tools, logs, audit data, repository queries, or monitoring views that show which content items consume the most memory on runtime servers?

2. Is there a way to identify reports, dashboards, or models that create very large intermediate result sets or expensive runtime queries?

3. After a runtime overload event, is there a recommended way to identify which content item caused the memory spike?

4. Are there recommended limits, alerts, or isolation settings that can prevent a single heavy content item from overloading runtime servers?

5. What is the recommended process for reviewing and optimizing this type of content in self-service environments?

The goal is to detect and review this type of content in advance, before it overloads runtime servers.

Pyramid version: 2024.03.002

Thanks

Here is a simplified example:

Rows 1-5 are from Discover 1

Row 6 is a simple Sum Total

Row 7 is coming from Discover 2 on sheet2

Row 8 is Row 6 divided by Row 7

This part is working as expected.  I can change the slicer and it returns the correct data.  The problem is when I drop it in a dashboard.  The slicer in the dashboard, which I pulled from the Tabulate, is not changing the data even though the breadcrumb is showing that the value is being passed in.  I’m sure it is something I missed in configuring either the slicer in Tabulate or the Visual Area.  Do I need to create parameters? Should I not include a slicer in the tabulate? How do I get the dashboard and tabulate to communicate?

We are currently using a matrix-format report with subtotals in Pyramid Analytics. However, when exporting the report to CSV, the columns become jumbled/misaligned because the matrix layout is flattened during the export process.

We would like to retain the matrix format and subtotal structure while exporting. Are any export settings, formatting options, or recommended approaches to preserve the matrix layout in the CSV output?

Thanks,

Raveena

We have written the following formula to count the number of active users:

Code-Snippet
Count(
Filter(
allMembers([Nutzer].[Benutzer ID]),
([Nutzer].[Benutzerstatus].[1], [measures].[Login Anmeldung ID]) > 0
)
)
The problem is that when we select multiple months in Discover, this formula always aggregates the individual values of both months together instead of splitting them by month.

For example, we have 135 active users in February and 147 in March. However, when I select both months simultaneously in the Discover filter, the formula no longer outputs separate values for each month. How can I adjust this formula to respect the monthly breakdown?

I encountered an issue with SQL Script node in the Master Flow.

Steps to reproduce:

1. Create new model and dataflow
   In our case it’s a simple dataflow from excel file to an In-Memory database

   

2. Open Master Flow

3. Add “SQL Script” and “Data Model” nodes and connect them to the Data Flow

   

4. Configure SQL Script node to access In-Memory DB and choose any available DB

5. In the SQL Script node write query: “SELECT 1”

   

6. Add new Variable in the following manner:
   Change Data Type to “Date” and activate checkbox “List”

   

7. Press Validate or Process Model

I get an error: «java.lang.NullPointerException: Cannot invoke "java.time.LocalDate.format(java.time.format.DateTimeFormatter)" because "date" is null»

If I remove the variable, or deactivate the "List" checkbox, or delete the SQL Script node, the flow is considered correct.

Thanks!

Steps to reproduce:

1. Create new Matrix Grid with said hierarchy, column and measure

   

2. Create new presentation with the created Matrix Grid
3. Open presentation as a viewer
4. Quick Sort the matrix by measure (Sum Cost - in my case)

   

    
5. Expand any Category (in my example – Furniture)

Actual behavior:

Sub-categories are not under the expanded Category, but are sorted like independent rows (The hierarchy is broken).

Desired behavior:

Each Sub-Category is under the expanded Category

Note that in Discover, the «Break Hierarchies» checkbox can be disabled to achieve desired behavior, but a viewer can’t disable it while in presentation mode.

Thanks!

I found an issue with renaming objects in the Search panel.

Steps to reproduce:

1. Select any object in the Explorer, open its Metadata panel and copy its Item ID

   

2. Reload the browser page

3. Without opening the object in the Explorer, navigate to Search, paste copied Item ID into the search bar and press Search

   

    

4. Right-click the object, click rename and type in new name

   

5. Press the Search button again or press Clear and perform step 3 again

Expected behavior:

Search result shows the object with the updated name

Actual behavior:

Search result shows object with the old name

I also found out that there is no issue if the object has been opened in Explorer after the page reload.
 

Thanks!

 Can anyone tell me what I am doing wrong?

Thanks!

I need help creating Previous Month Sales, Current Month Sales, and Growth % in a Pivot.

I have:

• A Sales column

• A Sales Date column in yyyy-MM-dd format

Initially, I created a custom Month column, and the calculation was working correctly. However, when I tried using the actual Sales Date column directly, it stopped working.

I have already tried using Lag() and the Previous option, but it is still not giving the expected result.

My requirement in the Pivot is:

1st Column = Previous Month Sales
2nd Column = Current Month Sales
3rd Column = Growth %

Also, I need the values to be dynamic according to the Sales Date filter selection.

The Sales Date will be used in the filter.

Could someone please suggest the correct way to achieve?

Thank you!

Is it possible to create a group folder for an existing role? We are currently restructuring our folders and want to avoid creating new roles or deleting existing ones. Doing so would require us to update the roles in the public folders as well, which is highly error-prone.

Creating a new Role:

 
customising an existing folder:

Thank you in advance for your help.
Jona

Can we enable a specific email template for one workgroup without making it the default for all workgroups?

Thanks,

Raveena

Is there a way to remove the border in mini-tab.

Thanks,

Raveena

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, and value ZZ when field 1 is D, E and . 

Does Pyramid Support MHTML files if so how we can retain the format?

Thanks,

Raveena

"Our technical support team primarily handles bugs and issues related to the Pyramid application. 
Since your inquiry concerns the Learning Hub, we recommend contacting the LMS team at learninghub@pyramidanalytics.com for assistance.

In the meantime, we will proceed with closing this support case. 
However, if you do not receive a response from the LMS team or need further assistance, please feel free to reopen the case." 

It's Wednesday and he still hasnt been helped, what is the process to receive help?

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

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.

 I tried adding all the discovers into a presentation slide, but when I export, they end up in different sheets. How can I achieve the desired output shown above?

Thanks,

Raveena

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. I tried adding all the discovers into a presentation slide, but when I export, they end up in different sheets. How can I achieve the desired output shown below.

Thanks,

Raveena

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, Pyramid creates three separate worksheets (tabs) instead of putting everything onto one single sheet.

What I have already tried without success:

• Grouping: Grouped all visuals on the page.

• Export Settings: Checked "Merge Common Cells" and toggled various Slicer options.

My Goal: The content of one Publication page should result in exactly one Excel worksheet, preserving the vertical arrangement of the reports.

Is there a specific setting or a "Layout-Fidelity" toggle I am missing to force Pyramid to treat the page as a single export entity?

Thanks for your help!

I found an inconsistency between the PQL documentation and the actual behavior of DateDiff in a Custom Column.

https://help.pyramidanalytics.com/2024/Content/Root/developer/reference/fx/PQL/Common/Date-Time/DateDiff.htm?Highlight=datediff

According to the documentation for DateDiff, the supported flag for days is:
- "dy"
- "dayofyear"

However, when using this in a Custom Column, the following expression fails:

DateDiff(last_login_date, now(), "dy")

Error:
Unsupported date offset type: dy

At the same time, the following expression succeeds:

DateDiff(last_login_date, now(), "dd")

The issue is that "dd" is not mentioned in the documentation, while the documented "dy" does not work in this context.

Expected behavior:
- either "dy" should work as documented,
- or the documentation should be updated to reflect the actually supported flag values for this function in Custom Columns.

This looks like either a documentation issue or an inconsistency in the function implementation for Custom Columns.

Screenshots attached.

 Thanks.

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 Elements are the same.

 When I try to map two simple test reports in a dashboard the slicer does not interacte with both.

Can someone help me out here? I also attached a PIE file of the Dashboard 

Thank you in advance,

Jona

CASE(
    CONTAINS([product], “Checking”), “Checking”,
    CONTAINS([product], “Savings”), “Savings”,
    CONTAINS([product], “CD”), “CD”,
    CONTAINS([product], “Auto”), “Auto Loan”,
    CONTAINS([product], “Loan”), “Loan”,
    CONTAINS([product], “Fixed”), “Loan”,
    CONTAINS([product], “Business”), “Business”,
    “Other”
)

We have a dashboard with a slicer for cost centres. The sales organisation should cascade on this so that only the cost centres of the selected sales organisation are shown.

We have currently incorporated the cost centres as a drop-down slicer. However, this is not ideal, as there are several levels in the selection that are not easily visible to the user without the hierarchy being displayed. 

 
If I change the type of slicer to a multiple tree selection, the box (marked in red) where I can tick the cascade option disappears. Why is that? 

As always: thank you for your help!
Jona

1. "SALES by PRODUCT CATEGORY" as stacked column on the primary Y-axis
2. "MARGIN" as line chart on the secondary Y-axis

So, it should look like this...

 ...but the PRODUCT CATEGORY (Color drop zone) should only have an effect on SALES, not on MARGIN. So, I want to have ONE line chart for the overall margin. 

(How) Is this possible?

THNAK YOU!!!
Micha

Hi PA team,

We would like to implement the following calculation:
We have a list of products, and we want to create a distinct count of these products.

However, for this measure, we would like the results to not be affected by the product color filter when used in a dashboard KPI or in a Discovery canvas.

In our data model, Product ID and Color are in the same table, and in Power BI there is an option to use REMOVEFILTERS inside CALCULATE to ignore specific filters for a measure.

Our question is:
👉 How can we implement similar functionality in Pyramid Analytics?
We have checked the community resources but could not find an equivalent option.

Thanks in advance for your support.

We are running Pyramid in a single‑tenant deployment on our own VMs, and I am trying to generate daily stats for:

• total active Models
• total active Presents

This is to help us track adoption trends and “work in progress” over time.

From what I understand, the content_tbl_item table stores all content objects, and item_type identifies the object type. Based on documentation and older forum references, I have the following mappings:

• item_type = 4 → Models
• item_type = 8 → Presents

To calculate the active counts, I am using these queries:

Models

SQL

SELECT COUNT(*) AS etl FROM dbo.content_tbl_item WITH (NOLOCK)

WHERE item_type = 4 AND (is_deleted = 0 OR is_deleted IS NULL)

AND is_active = 1;

Presents

SQL

SELECT COUNT(*) AS present FROM dbo.content_tbl_item WITH (NOLOCK)

WHERE item_type = 8 AND (is_deleted = 0 OR is_deleted IS NULL)

AND is_active = 1;

My questions

1. Are these item_type values correct (4 = model, 8 = present) in a single‑tenant Pyramid install?
2. Is this the correct and supported way to count active content items in Pyramid?
3. Are there any other flags or joins I should include to ensure accuracy (e.g., multi-version rows, ownership, tenant filters, etc.)?

We are currently designing our own homepage in Pyramid to better tailor it to the needs of our users. The latest reports and favourites should enable them to quickly find the most important reports again. On top of that, we use the news feed to present new features, such as new dashboards or new data models. Futhermore, users can report system malfunctions to us via the ticket system.

Overall, we are satisfied with the content but less so with the layout and appearance. For example, there is no option for a free text field. We currently use discoveries and name them according to the heading. But that shouldn't really be the case.

Does anyone else have any best practice examples or experience with how to make the home page more visually appealing?

I am grateful for any tips.

Best regards, Jona

does the iOS App support Configuration in Microsoft Intune?
Customers wants to prefill Pyramid Server URL over the configuration in Intune. 

https://learn.microsoft.com/en-us/intune/intune-service/apps/app-configuration-policies-use-ios

The attribute I would like to use for the months is called ‘[KJ Month in Year]’.

My first approach was to use a parameter for all ‘[KJ Month in Year]’ members

 I then inserted this into a list using the Month to Date function. 

 In the last step, I then insert the list into an aggregation to obtain only the cumulative value.

 However, at the end I receive an error message.

Does anyone have an alternative approach in mind that works?

Thanks and best regards, Jona

Other client tools see this as a date.  How do I get Pyramid to see it as a date?  Thanks.

 Here is the table in the SSAS model:

Thanks

after the latest major Release we often use the function to print a publication in the body of an e-mail. 

In some cases we have discoveries with many rows in it. I have attempeted to use "visuell flow" in order to avoid one report from visually overlapping another but it didn't work. 

Does anyone have any tips on how I can solve this problem instead?

Thank you & best wishes 

Jona

How can I prevent the pre-query popup from appearing on all slides when a slicer is set as a pre-query slicer on one slide?

Thanks,

Raveena

I was wondering if it's possible to enable scrolling in a "Column Chart" Type discovery, the thing is that i might have a discovery with many categories and it's hard to understand what's going on.

For Example :

 Thanks in advance!

I've had this problem several times in the last few days. Can you confirm this on your end, or should I look for the problem elsewhere?

THANK YOU & best regards,
Micha

A couple of questions - is there a way to configure the tool tip so that the column name and column location are omitted?

Secondly, how can we increase the tool tip's font size? 

I've looked through the help and Pyramid itself to no avail.

Thank you,

Bruce

Currently , while sending an email from Subscription and publication, we are unable to see the email recipients . Its difficult for the team to check with the teams whether the mail is received or not.

Is there any option to enable the all email recipients list (to/cc/bcc) in the email send from Pyramid, not just single individuals  (Both Subscription and Publication).

Regards,

Aaron Y

I'm building a product launch dashboard and struggling with PQL filter context. I need to calculate several "New vs Existing Buyers" metrics that require comparing two different time periods while respecting slicer selections.

My data structure:

• panelist_id - unique buyer identifier
• supplier, brand, sub_brand - supplier hierarchy
• class, category, sub_category - product hierarchy
• period_type - 'LAUNCH' or 'COMPARISON'
• is_launch_product - TRUE/FALSE
• sales_amount - measure

The metrics I need to build:

1. New Buyers % by Supplier/Brand/Sub_brand:

• A panelist is "existing" if they bought from the supplier/brand/sub_brand in COMPARISON period (excluding launch product)
• A panelist is "new" if they did NOT buy from the supplier/brand/sub_brand in COMPARISON period
• Formula: Count of new panelists / Count of all launch buyers
• Must work dynamically with slicers on supplier OR brand OR sub_brand OR Class Or Category Or Sub Category

2. New Buyers % by Class/Category/Sub_category:

• Same logic but for product hierarchy
• A panelist is "existing" if they bought from the class/category/sub_category in COMPARISON period (excluding launch product)
• A panelist is "new" if they did NOT buy from the class/category/sub_category in COMPARISON period
• Must work dynamically with slicers on class OR category OR sub_category 

The problem:

When I use Filter(AllMembers([panelist_id]), ...), the slicer context is completely ignored inside the Filter.

What I tried:

-- New Buyers (using Except)
Count(
    Except(
        Filter(
            AllMembers([table].[panelist_id]),
            ([measures].[sales_amount], [table].[is_launch_product].[true], [table].[period_type].[LAUNCH]) > 0
        ),
        Filter(
            AllMembers([table].[panelist_id]),
            ([measures].[sales_amount], [table].[period_type].[COMPARISON]) > 0
        )
    )
)
/
Count(
    Filter(
        AllMembers([table].[panelist_id]),
        ([measures].[sales_amount], [table].[is_launch_product].[true], [table].[period_type].[LAUNCH]) > 0
    )
)

Expected result: When supplier slicer = "Tnuva", the second Filter should return panelists who bought from Tnuva in COMPARISON (24 panelists).

Actual result: The second Filter returns ALL panelists who bought anything in COMPARISON (41 panelists), ignoring the supplier slicer entirely.

Other attempts that didn't work:

• CurrentMember([supplier]) in the tuple - still ignored
• NonEmpty() - didn't respect slicer context
• Nested Sum(AllMembers([brand]), Sum(AllMembers([sub_brand]), ...)) - didn't work
• Intersect() instead of Except() - same problem

Verified in SQL:

-- This returns the correct numbers:
-- Total launch buyers: 28
-- Existing buyers (same supplier): 24
-- New buyers: 4 (14.3%)

My questions:

1. Is there a way in PQL to make a nested Filter() respect the current slicer context? Something equivalent to DAX's CALCULATE with KEEPFILTERS?
2. If not possible with a single measure, what's the recommended approach?
   • Separate measures per hierarchy level (6 measures)?
   • Pre-calculate in database?
3. Is there a function I'm missing that can "inject" the current slicer selection into a Filter?

Thanks for any help!

Is it possible on a presentation to have the logo (image) change when the appropriate company is chosen via a slicer?

Does using NLQ with the Pyramid Internal chatbot cause any data (semantic as well) to leave my network ?

Or does this just use the semantic data from the model to answer my questions ?

We do not plan to configure any LLM as of now but wanted to check if using Pyramid Internal NLQ engine would cause data to leave our network

Thanks

Mad

Symptoms & Errors:
The export fails almost immediately, and I am seeing the following errors in the system logs:

1. Code Exception (NPE):
   java.lang.NullPointerException: Cannot invoke "api.models.printing.enums.ExportTitleContext.ordinal()" because "titleContext" is null
   at bl.printingEngine.PrintingEngineImplementors.ExcelSheetFactory.getSubTitle(ExcelSheetFactory.java:212)

2. Renderer Crash:
   ... got errors All puppeteer process tabs have died

3. Timeouts:
   On some attempts, the task simply times out (even after increasing maxTimeForProcess to 600s).

Troubleshooting attempted:
I have already tried the following tuning steps with no improvement:

• Reduced printing parallelism in Task Services.

• Increased printing/conversion memory limits (Max Active Server Size).

• Increased all relevant timeouts (Printing job timeout, Query limits).

• Restarted the Task Engine.

Please verify this on your side. This appears to be a critical bug with the Excel export functionality in the new release.

Thanks.

Thanks,

Chun 

Thank you,

Bruce

Any guidance, examples, or documentation references would be greatly appreciated.

Thanks in advance for your support.

I'm trying to create a range slicer system where the slider's min/max values change dynamically based on a period type selection.

My Use Case:

• I have a Rank column (integer) in my data that represents either week rank or month rank
• I have a Period Display column that indicates whether the data is "Weekly" or "Monthly"
• Weekly data: rank ranges from 1-102
• Monthly data: rank ranges from 1-24

What I Need: I want to create an interface where:

1. User selects "Weekly" or "Monthly" (via buttons or dropdown)
2. Based on that selection, range sliders appear showing:
   • If Weekly: Start Rank (1-102) and End Rank (1-102)
   • If Monthly: Start Rank (1-24) and End Rank (1-24)
3. These slider values filter my data by the Rank column

thanks in advance!

Greetings.

When exporting a CSV file from Discover or Presentation, the column order changes to a weird (non-alphabetical) sequence. I want the columns to export in the exact same order as created in Discover.

This works fine in Excel format, but only occurs with CSV. How can I preserve the original column order in the CSV export?

------------This is the Discover and see the order

------------After Exporting this in CSV format
 

Thank you in advance.

For example below i have 'spend on shop' selected- if i change to 'share',  it will still have the conditional formatting for 'spend on shop'

 Is there anyway around this ?

Thanks,