Latest Activity

How to call or execute(take as data-source) an SQL stored procedure in pyramid analytics

hi all, I was trying to call an SQL stored procedure from custom query into pyramid analytics in below way. exec dbo.[Get_SalesdetailsPyramid] The statement is valid,…

• Answered

Filter a second dimension based on the value of a first dimension in Discover

Contents Hi Community, Please bare with me whilst I try to explain what I am trying to achieve. This is a very slimmed down example, but suffice to say,…

• Answered

Finding Numbers for Yesterday

Hi Everyone, Our daily numbers (sales, manufacturing etc.) works behind by a day. When we say daily, we mean what we did yesterday. How can I achieve that in a formula?…

• Answered

Indicator to ONLY the total/subtotal

I am aware of the option to remove/include the indicator from Totals.... Is there a way to include it ONLY for totals/subtotals?

• Answered

Last month of Quarter - Date Lists & Formulates

I need to create a rollforward which is a Quarterly rollforward (see SNIP below of rough draft). This will past 5 quarters of data. I will be creating formulas for each of the listed items (Beginning…

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

Help Getting Stacked Bar Plot to Use a Consistent Set of Colors

I am building a discovery that is a paired stacked bar plot with the following characteristics: The X-axis is year. The Y-axis is a percentage of total annual insurance cost of workplace injuries.…

• 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