Latest Activity

Connecting buttons to a slicer to display lists

I have constructed a global parameter with 3 buttons: "All Customers", "Customer group A" and "Customer Group B". I have made 3 corresponding lists (All based on the same dimension,…

• Answered

Comparing dates in a formula

What would be the best practice for comparing two date dimension fields in a formula? Here's an example formula we are trying to create: if(created_date<=evaluation_date, 1,…

• Answered

Add User Search Box within the Role Management Panel

Hello PA Team, I'd like to suggest a simple but very important usability enhancement for the role management interface in the Admin Console. Currently, when I open a role to manage its members,…

• Answered

Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula

I have a report example that shows values accumulating over a two-year time frame. If, at any point, the value for a specific Part/Type falls below a defined threshold,…

• Answered

Subscriptions via SMS

Is it possible to subscribe via SMS rather than email? I can't find anything in the support documentation... Thanks!

• Answered

How do I limit the available months per year

I’m trying to maintain two columns (2024 and 2025) on my Discover Matrix Grid. However, I only want the 2024 column to reflect data from July 1 to December 31,…

• Answered

Monthly percentage of annual value

Hello, I have created a line chart showing the monthly distribution of reported sales. I tried to add a tip tool that shows the percentage of the month's value relative to the annual value.…

• Answered

Model app missing from Explore Pyramid

Hello, I'm trying to work through the Data Modeler certification modules using explore.pyramidanalytics.com however the Model app isn't showing (see image). How do I get it added? Much Thanks, Sarah.

• Answered

create hierarchy without access to the model

Can I create a hierarchy of dimensions without access to the model? (In discover or formulate)

• Answered

Add "Select All" Option to Multi Select Tree

Hello PA-Team! It would be highly beneficial to add a "Select All" option to the Multi Select Tree slicer, similar to the functionality already available in the Multi Select Drop Down slicer.…

How to rename the forecast label

Hello, When I use the forecast tool I get Forcast1, forecast 2, forecast 3... I also do see an option to change the word forecast , but what I don't know is how I change it to be the next 6 months.…

• Answered

Load a whole folder and append multiple same-structure CSV file

Greetings! I looking for a way to load and append a whole set of files into Pyramid (same-structure files from different divisions, or from different days).…

• Answered

Column chart: data labels inside/outside & text direction

Hi, I created a column chart in Pyramid 2018. how can I put the data labels outside the column? And can I change the text direction to horizontal? Thanks in advance! Regards, Rutger Lammers.

• 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

Show Data for the most recent full week

I thought this was going to be easy (and maybe it is). I am working on creating a Pyramid usage dashboard. Part of that is looking at user logins. I have a Discover that shows the total number of…

• Answered

Need help with Dynamic Place Holder - Adddays (business days) to date

Hi I need to create a placeholder text which will show me my base period and comparative period dates. Both of these text placeholders are driven by load date.…

• Answered

Publish email with attchment

Hi team I created an publication and scheduled it. (The output format is pdf or word - still under review which works best). I want it to be send by email and the document to be attached to the…

• Answered

Let's talk about Dimensions and Measures

Dimensions and measures are the two central building blocks in multidimensional reporting. In Pyramid Analytics, they are mainly dealt with in the “Model” and “Discover” modules.…

Need help with a new list

I am working with a pre-existing model that I cannot change. In the model there are 2 dimensions, in this case we'll call them Number and Letter. what I want to do is make a new list where letters B…

• Answered

Enhance Profile Configuration Options

Hi PA-Team! I request to expand the Pro user profile configuration options within the Model module of Pyramid BI (Admin Console > Access > Profiles). Currently,…

• Answered