Choose an specific dimension element

I'm trying to apply different data points depending on the element value. this is how i built my formula: if(CurrentMember([CalendarioMO].[date full month name]) = DateFormat(Date(),"MMM yyyy"),…

• Answered

Automatic Filter by Calling User

Hello, I have a client who needs to limit and automate the filtering of data based on the calling user. In this example, each advisor will be looking at their student success information.…

• Answered

How to I show data point that do not have a value

Hi, I have a report, where we don't have sales data for the time period, but I want to show the empty cells on the report . Like in this example 123456 didn't show up. Who could help me to solve this.…

• Answered

How to turn on Action Tooltips?

I was going through a video tutorial on adding action tooltips to a discovery. In the video the user can select a Tooltip in the Action To Do section of the Action Panel (1st screenshot).…

• Answered

Is it possible to connect a webhook to Google Chat?

• Answered

How to calculate 90 percentile based on category

I need to calculate 90 percentile in one of my discovery (there is no option in model). Since there is no direct way to have 90 percentile, instead I am trying using standard deviation (1.…

• Answered

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