Latest Activity

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

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

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

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

How you change default Theme color combination ? only choice is row header setting color ?

How you change theme's default color combination ? ( If it is ugly color combination ?)

• 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

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

Alert email in PA2018

Hi team In BIOffice we had alerts (which could be send out by email) with dynamic text inside form a discovery. Is there a plan to implement those into PA2018? Thx

• 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

Left/Right Outer joins

Hello, I somehow struggle to get my Left/Right outer join working (see print screen). Could you please confirm the Left/Right refers to the fields below (in that instance, "Audit sans...…

• Answered

Connect to SharePoint List in Data Model

Is it possible to connect to a SharePoint list as a source in a data model? I tried various options using the OData source adapter, but could not find a way to get it to work.…

• 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