Questions & Answers Category

Has anyone used Pyramid with Dynamics (D365 - FinOps and CE) ?

One of my clients uses Microsoft Dynamics as its core systems - both D365 FO (Fin Ops) and CE (Customer Engagement). In trying to design a DWH / BI solution for them I'm discovering how hard…

• Answered

Report URL Options

I have a report that requires me to embed URLs within the report body. These URLs are parameterized (currently generated by the underlying query and marked as a URL type) and the reports are embedded…

• Answered

Exploration empty in a publication

Good morning, I would like to know if there is a way to not display an exploration in a publication when there is no information? Thank you in advance Have a nice day everyone

• Answered

Renaming a measure

I want to rename a measure from the model. I try it from the model in the tables part and then "Display Name". But after changing it I see the original name in the discovery and nothing changes.

• Answered

Automated Export/Extract to SQL Server

This is a unique client request that I am trying to assist with. The need is to export directly from a Pyramid Discovery to a SQL database. My thought was to connect SQL SSIS job and induct a CSV…

• Answered

Row background color is not exporting same in excel

Hello, Is there any way to export the same color format layout from the pyramid report to excel file. At this point, I can see just the header colors are exporting correctly and that to different…

• Answered

How to have a field ignore a filter in a visual

I am trying to create a benchmark visual that has a set of data sit alongside a group total. For example, say there are 5 companies that exist in a certain state.…

• Answered

Subscribe to 1 dashboard in a presentation

Good afternoon, Is it possible for a viewer to subscribe to only one dashboard in a presentation and not the whole presentation? Thanks, Natalie

• Answered

Question on How to use AI driven Forecasting

I just saw the video on AI driven forecasting. To use GenAI capabilities in pyramid do we need any addition in our license ?

• Answered

Question on - How to print a Publication from a Dashboard

Thanks for this video, it works great but not for calendar slicer for me when I pick date range, any suggestions?…

• Answered

Pyramid Analytical

Hello All, We have embedded the Pyramid Analytical site within one of our SPAs with SSO enabled. The token must be retained for a seamless user experience.…

• Answered

Ability to hide the "start new conversation" option when using custom workflows

Does anyone know where the setting is that allows us to determine if both custom workflows and conversations can be used on a particular dashboard? We were able to control this in the past but I…

• Answered

Setting dimension elements to a secondary axis

Hi, I don't know if the following is even possible using an OLAP cube model. I'm looking to create a graph to view the YoY data with the percentage change overlaid on the secondary axis as a line…

• Answered

Improve Search Functionality of Data Elements

When using the search function (via the magnifying glass icon) for data elements, such as searching for elements when creating a Formula, the output for the search only contains items that begin with…

• Answered

Default theme not pre-selected

Hi, I have created a new theme (circled below) and made it the default within my pyramid environment under the admin settings, however when creating a new present / discovery the old default theme…

• Answered

Common Y-Axis Scaling for Trellis Column Charts

Trellis column charts are nice, but hard to use effectively when each chart has its own y-axis scale. How can I set them to a common scale, or, in the case where I have both vertical and horizontal…

• Answered

Displaying a 0 instead of a blank cell where there's no data for a given date

Hi. This is related to the How To article that Moshe Yossef kindly provided a while back - https://community.pyramidanalytics.com/t/p8hv3sr/how-to-create-a-dynamic-set-of-dates.…

• Answered

How can I print a large number of records (e.g., 10,000) into a PDF document in a presentation, as the current method isn't working?

• Answered

How to skip first N rows when reading an excel file using pyramid when the header is not necessarily the first row.

i have a simple xls but the header row is not always the first row of the file.Using a simple filter i could get rows as per clause in the filter below,…

• Answered

Dynamic SQL - Field Name Changes

Hi I have a table that has values in different languages, I wondered if there is a way to pass the field name for the 'current' language as part of a custom sql statement,…

• Answered

Needs the tooltip feature in other dimension rather than only in Measure values.

Hello, Can we have the feature request about the tooltip in other dimension rather than only in measure values? Currently it does appear only in Measure values and did find any scope to have it in…

• Answered

Importing Smartsheet data into Pyramid

Hi Folks, I'm leading a project, and the team wants to import Smartsheet data into Pyramid. We tried using the token, the sheet ID and the URL to do this, however,…

• Answered

Connecting to Tidal software to get the job data and display batch status in Pyramid.

I am creating a Dashboard in Pyramid. Would like to connect to Tidal software and get the job data and display batch status in Pyramid.

• Answered

Content Master Page | Copyright Year

We need to show a copyright year on every slide of our presentations. Currently when we create a new presentation, we add in a dynamic text that shows the year onto the Content Page:…

• Answered

Weighted Product Distribution %

Good morning, I hope that someone can assist us with calculating a product's weighted distribution in Pyramid. Weighted Distribution % = The Total Value of the Customers that buy a Product (where…

• Answered