User Community

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<=?…