Dynamic Eliminations

I’ve been trying to do some dynamic eliminations using sets of sets. i.e creating two crossjoined sets (from 2 different dimensions) then making a set of the resulting sets.…

• 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

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

Displaying only yesterdays Date

The data my company collects is a day behind, is there a way to show just the data information from yesterday? Ex: Today is 4/10, the most recent data I have and want to show in the discovery is 4/9?…

• Answered

Ordering the Months

Currently when I am displaying the MonthName field it defaults to showing me the names in alphabetical order. How do I fix this to show me the regular order (January, February, March, April, May,…

• Answered

Reg:SAP ERP systems

Hi Team, Can we connect pyramid analytics directly to SAP ERP data source? or do we need to have any connectors?? Thanks in advance.,! Regards, Manish

• Answered

Is there a way to create groups and then filter within those groups

My discovery table needs to contain some groups so I can filter by those. For example with countries the data set we use has them broken out, I will need to create a group for all the European…

• Answered

Azure Analysis Services

Does anyone here actively use Azure Analysis services? How do you find it?

• Answered

GA input call/record limits

Hi all, do you know what the limits are for how many records/days/etc. can be pulled in from Google Analytics at a time? We are only receiving a limited part of the data when pulling from longer…

• Answered

OLAP Createating a Calculated member under the Hierarchy

Hello All Can we create a Calculated member under a Hierarchy and add it to a different parent under the same Hierarchy in an OLAP Cube. To give an example Let us assume there are 4 Level for…

• Answered

embedding with php or python

I have seen examples of using the embedding functionality with c#, java, and js/ajax? Does anyone have a example in php or python? Thanks. Kevin

• Answered

Enable export themes from BI Office to Pyramid 2018

Can the Pyramid team provide themes for Pyramid 2018 that match the themes that are available in BI Office? In particular, some of the default themes like Pyramid 2013 and Pyramid 2016 would be very…

• Answered

Why Are Themes Not Securable Objects?

Given that themes now appear to include features for defining specific master pages for presentations and publications, it would seem helpful to have themes be securable objects so that only certain…

• Answered

MODEL: Change stored procedure used to access data on SQL Server.

Hello, I have been testing Pyramid. In a model, we can obtain data from a SQL Server from a table or executing a stored procedure. If I want to use another table,…

• Answered

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

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

• 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

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

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

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

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