Raveena Mariappan

Discover Excel export – subtotal rows are merged

Hi Team, When exporting Discover to Excel, the subtotal rows are exported as merged cells across multiple columns. Is there a configuration or export setting in Discover to prevent subtotal rows from…

How to Change Font Color for Measure Values in Discover

Hi Team, In Discover, the values in the measure columns are displayed in blue font. How can we change the font color of these values? Thanks, Raveena

Duplicate Subtotal Values in Excel Export

Hi Team, When the subtotal is displayed in a separate column, why is the subtotal amount repeated on every detail row in the Excel export, even though it appears correctly only at the subtotal level…

Pyramid Email Subscription Delivers Both Excel and XML Files to Box

Hi Team, In a Pyramid model, we have an email subscription node configured to send an Excel file to a Box folder using the “Allow uploads to this folder” feature.…

Enabling Multiple Selections for a Presentation Column

Hi Team, Is it possible to enable multiple selections for a column in a presentation? Thanks, Raveena

• Answered

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

Preserving Matrix Layout in CSV Export from Pyramid Discovers

Hi, 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…

• Answered

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

How to remove border in mini-tab

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

• Answered

Pyramid MHTML File Support and Format Retention

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

• 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

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

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

Pre-Query Slicer Popup Appears on All Slides

Hi Team, 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

Parent-Child Sales Aggregation Issue

Hi Team, Lets say we have sales at parent level in base dataset1 and same is assigned to the corresponding children in dataset2. The total sales should remain 60 even when displayed at child level…

• Answered

Attach pdf as an attachment in email node

Hi, Is there a way to attach a PDF when sending an email? Thanks, Raveena

• Answered

Configuring FTP Source with Host, User, and .ppk File

Hi, Can I configure an FTP source using a Host, User, and a .ppk file? Thanks, Raveena

• Answered

Support for Private Key Authentication in createDataservers API?

Is the private key option supported in the ServerAuthenticationMethod parameter of the createDataservers API to configure Snowflake data sources?

• Answered

API for Testing In-Memory Data Source Connection

Is there an API available that tests the connection to the in-memory data source and sends an alert if the connection fails?

• Answered

How to do an vertical union in Pyramid?

I want to combine data from two sources but stack the results vertically, even if there's no direct match between the left and right datasets. How can I achieve this?

• Answered

`itemId` Parameter for `dataSources/addRolesToItemAndBubbleUp` API

For the dataSources/addRolesToItemAndBubbleUp API, what is the itemId parameter, and where can I find it?

• Answered

List itemType: database in dataSources/getDataSourcesByTenant API Output

The dataSources/getDataSourcesByTenant API currently returns details for itemType:server in the output. How can I include itemType:database in the response as well?

• Answered

Where can I find the query text information in the Pyramid repository database?

I'm building a transaction logs dashboard and can get most details from the transactionView table, but I can't find the query text information. Is the query text stored in the Pyramid repository…

• Answered

Is there a way to get the current logged in user?

I want to retrieve the current logged in user. The API Gets details for the current user. (pyramidanalytics.com) returns "devservicerw" as the current user,…

• Answered