If we have an azure artifacts, how can I directly refer it from pyramid to add packages from the artifacts.

Instead of downloading the file from artifacts in local & then deploying it in Pyramid, I want to able to directly refer it from artifacts.

How to set environment variable in pyramid

I'm trying to set environment variables in Pyramid & access it in my python script within Pyramid. But I'm facing an error, environment variables not set.…

Use Case: Sales Director/Sales Analyst

Hi! I'm trying to follow steps provided in the use case: Sales Director, but I can't see database I have to select ("New Properties"). I have downloaded "Sales Director " folder too,…

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