Questions & Answers Category

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

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

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

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

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

How to get a Discovery Bar Graph to Sort by One Specific Group ?

I am attempting to build a bar graph displaying data segmented by two bars and I want to sort the bars by magnitude, but I want the bars to only sort by one specific category.…

• Answered

In a Data Model, I want to use one column as the description for another

I have a direct SQL data model. There is a URL(dashboardpageurl) column and a description (dashboardpage) of that URL in another column as shown: I want to use the description column in place of the…

• Answered

Hide/Show dimensions with slicers

I have a discovery with a dozen dimensions. Is there a way to made a few button slicers in present that would enable me to pick and choose which dimensions are shown?…

• 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

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

Embed - Full Functionality

Hi, We have embed license , please guide us to utilize the full functionality as we are able to access less features in Pyramid. What should we do? For eg: From a slide ,…

• Answered

Previous Month Dimension Value

Hello, This has to be simple and I am sure I am missing something very simple I have an attribute for the current month lets say account_status ('ACT','CLS',…

• Answered

Measure appearing in a separate row using lag date formulate

I ran into an issue where I have a prior period measure that appears in a separate row when the dimensions change from prior period. In the screenshot attached you can see the loan officer changed…

• Answered

Support for Private Key Authentication in createDataservers API?

Is the private key option supported in the ServerAuthenticationMethod parameter of the createDataservers API to configure Snowflake data sources?

• Answered

How to undo total column color formatting

I created a few discoveries and color formatted the total and Subtotal columns. I added color formatting to the rest of the table but was then told that this needed to be done in the Total columns as…

• Answered

Parameter: 13 months on a rolling basis or the whole year.

Hello everyone, I would like to add a parameter to a report that allows me to show either the last 13 months on a rolling basis or the whole year. However, if I include it in a parameter,…

• Answered

Selecting Multiple Dimensions at Once

Hey all, This is a simple question about whether a certain functionality exists in Pyramid. Is a user able to select multiple dimensions and add them simultaneously?…

• Answered

Formatting for stacked bar charts

Hey guys! I'm wondering why Pyramid doesn't show the sum over the data labels below the stacked bars but in the middle. There are also no options in the formatting panel to change this.…

• Answered

Lien entre différentes requêtes dans un modèle qui ne fonctionne plus

Bonjour, un modèle a été crée, mais les liens entre les différentes requêtes ne fonctionnent plus : les filtres d'une requête ne peuvent pas être utilisés pour une autre requête et vice versa...…

• Answered

% of max calculation changes on context.

I've noticed that the context of the % of max calculation changes depending on if you have 'values' in the columns drop zone or not. When included it separates the calculation by column (each column…

• Answered

Filtering on 2 dimensions and counts

Hi community, I am struggling to do something that I think should be possible so asking for help here I have a star schema modelled in snowflake and a Direct Query model in Pyramid consisting of a…

• Answered

How to determine DataFlow NodeID?

Good day everyone, I try to automate the change of data models via the Pyramid API. But I can't find a function to get the Node ID of an existing model.…

Calculation of a ratio

Dear Community, I would like to supplement the presentation of a profit and loss statement with a ratio. This should always show the percentage of the upper node.…

• Answered

How to use the 'Publication Print' click action to apply slicers from a presentation

I am attempting to export a matrix-grid discovery to an Excel file on a presentation by using the publication print click action. I am having difficulties getting the discovery within my Publish file…

• Answered