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

`itemId` Parameter for `dataSources/addRolesToItemAndBubbleUp` API

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

• Answered

Scheduled maintenance down time

Afternoon, I've looked but have not found any means to have pyramid shut down access for scheduled maintenance. Main requirement is to prevent JDBC calls interrupting Netezza service procedures.…

• Answered

MTD YTD QTD manual functions

Hello community, I am aware of the pre-built MTD/QTD/YTD function using Time intelligence date hierarchy as filter. However, for the purpose of my dashboard,…

Reuse Data Models to Build other data models.

PROBLEM: Currently, we build data models that contain a set of tables (data model for products, data model for financial information); but these tables can have relationships between them too (EG:…

• Answered

Ability to make number of user inputs dynamic

Hi, I am preparing a dashboard where a dashboard user fills in the list of products to analyze- like product 1, product 2 and so on. Then for each product the user should enter the # of units.…

• Answered

Slicer UI settings

I have a slicer in my Present report. I have it as a button format. I want the filter options to be displayed horizontally instead of the default vertical layout.…

• Answered

Pattern for expected behaviour (general Q)

As I am getting acclimated to using Pyramid, one of the things I'm struggling with is the expected behaviour. Specifically, I have a line chart with two lines.…

• Answered

Can you please update me if the network diagram chart type option is available in Pyramid or the marketplace?

• Answered

How to create quantities sales report

Hi, I coudn't find answer on my question anyware so just creating new topic... I want to create a report for specific departments and subdepartments which will show me units sales of all product…

• Answered

Is there a way to communicate with external models real-time

Hi all, I have a slide where a user inputs a parameter (say price). Is there a way where pyramid can take the parameter, send it to an external predictive model which returns the buy probability (%),…

• Answered

Is there a way to set a process to automatically copy a presentation from folder to another?

I want to set a schedule that moves a copy of a presentation from my pre-prod folder to my prod folder. I want it to overwrite the copy every time. Is there a way to do this via the API or some other…

• Answered

Sub Total Color Formatting - to be exported in Excel

Hi Team, Need your help on getting color formatting on sub totals and same to be exported with color to the excel. Please guide how we can achieve the same.…

• Answered

How can we give a specific colour to Subtotals in a schema?

Hi, I found this older discussion in the Q&As, https://community.pyramidanalytics.com/t/g9hqrlc/how-can-we-identify-which-part-of-a-theme-to-change can anyone please guide where we can give color to…

• Answered

How do I add the Tooltip for the last element in a Waterfall Chart

Hello PA-team! Tooltip Issue for the Total Element There is currently an issue with the tooltip functionality for the generated last element (Total) in the Waterfall chart.…

• Answered

Access Multiselect Parameters values in Formulate

Hi, I’m trying to access multiselect parameters in Pyramid Analytics. Specifically, when using multiselect parameters in a dynamic caption, only the first selected value is shown,…

• Answered

How to define a Design Theme for grids with a single-color background?

I'm afraid this is almost becoming a feature request, but maybe I've overlooked something... I would like to define a Design Theme that provides a completely single-color background for grids, e.g.…

• Answered