List last FULL month

Hi, I am not sure if I am doing something wrong, but I can't work out how to create a set containing dates from the last full month (so today, I want all dates in February).…

• Answered

Removing extra whitespace on Storyboard

When I add a report to a storyboard and try to shrink the panel smaller, I get '0.0 Measure' and my report doesn't display. How can I remove the extra whitespace?…

• Answered

Moving existing Pyramid 2018 setup to new server

Hi, we'd like to change the server on which Pyramid is installed. What would be the best path to migrate our content to a new machine? Actual setup is using a local Postgre database.…

• Answered

Help with displaying full year and Week To Date

Hi, My users have two separate data discovery that they would like combined in to one, and I can't seem to figure it out. They both have a year week hierarchy on columns,…

• Answered

Calculate difference between columns

I'm trying to create a very basic grid that has two Terms in the columns and several measures in the rows. How can I add another column that shows the difference between the measures for the terms?…

• Answered

Discovery chart - how to show % values to 1dp?

Hi all, In my discovery chart, I would like to show my axis labels to 1 decimal place (they currently show to 3 decimal places). E.g. they show 1.200% when there is really no need.…

• Answered

getAllConnectionStrings returning a 302

When I try to hit my instance of the Pyramid API 2.o to getAllConnectionStrings I am receiving a 302. How can I remedy this problem?

• Answered

How to hide or remove Cumulative Total (Column Measures)

Hello, I have applied Cumulative total on Returns and moved it to Rows so that the cumulative totals are applied on Row level. How to remove or hide this measure column? TIA.

• Answered

Parameters don't seem to be working

I added a parameter to one of my dimensions which I also have in rows in my grid. I am not sure if I did something wrong, but when I change the selection in the parameter's drop-down,…

• Answered

What happened to sorting?

My experience previously was that I could have Elements show up in a report in the order I selected them. What I am currently experiencing seems to be it puts all "standard" Elements (i.e.…

• Answered

Experience going from BI Office to Pyramid 2018

Hi All, We recently upgraded to v6.5.2 but were wondering what your experience has been going from BI Office to Pyramid 2018 including converting existing storyboards and reports.…

• Answered

Switching from AD to SAML

We would like to switch our authentication from AD to SAML. I have reviewed the documentation, but I was wondering if anyone has configured SAML and what your experience was.…

• Answered

Server Sizing

We are new to Pyramid 2018 and are trying to get an idea on server sizing, in particular memory and cpu, before we lock in our configuration in AWS. Our current config is: Processor:…

• Answered

Grand Totals Not Working with Filters

Hi! I don't know if I'm doing something wrong but the Grand Totals are off when you put a filter. It does not recognizes the filtered list, the total is still on the entire data selection.…

• Answered

Number Formatting in Discovery

Hi all, I have the attached discovery prepared from the attached data model. I am having trouble displaying the variance information as a percentage rather than a number format.…

• Answered

Publication - Slicers for email and display name

Hi, I have a publication that is distributed by email address, which is a slicer in the publication. I also use this email address in some dynamic text on the front page of the publication.…

• Answered

implementattion of chord chart in pyramid 2018

Hi Team, Do we have an option of implementing chord chart in pyramid 2018? If yes,can you please help me out on this? Thanks, Regards Manish

• Answered

NQL and OLAP models

We noticed that natural querying and some other cool features (Time Intelligence, Clustering, Outlier analysis,…) don't work with OLAP models, but only within Pyramid-created models.…

• Answered

Creating a Moving Annual Average

Hi, I am trying to create a moving annual average of customers to feature on a graph I have i created in discover (please see attached). How would I go about doing this?…

• Answered

'select server for saving model drop down box' in Pyramid is empty

• Answered

Is it possible to create a cascading global slicer in pyramid analytics?

• Answered

How to combine elements under single header

Hi all, I am looking to combine a group of elements (R1, R2, R3) to create element R which I can use in a Discover Matrix Grid. If I add R1, R2, and R3 to a list then my list of elements looks like…

• Answered

Error connecting to MongoDB

I'm trying to join to MongoDB, unfortunately unsuccessfully. ERROR text: "Failed to open connection 'Unable to load authentication plugin 'org.mongodb.mongosql.auth.plugin.…

• Answered

'Lagging' Time-Scale in Discovery

Hi all, Please see attached screenshot. I am trying to build a section of an existing report at my company in discovery for export to excel (for the time being).…

• Answered

Problems with Custom Maps

I've been creating some map reports and I have a postcode hierarchy consisting of Country, Area, District and Sector. When in the hierarchy, the shapes don't change as you drill down.…

• Answered