Creating "1st Month of the Year of the Previous Month" in a list

I have the following as a Range List which is the *First Month of Current Year* until previous month I want to change the start of the list to be the first month of the previous year instead.…

• Answered

Using SQL queries to build reports

Hello, Is there a way to use SQL queries to build the reports themselves? Forgive my unfamiliarness with Pyramid, but I only see the option to query using SQL when creating a data model.…

• Answered

Preset number of Y ticks in advance

Hi, I want to build a line plot in discovery that would have pre-set 5 parts to split into, no matter the data min and max. Meaning, If I have 0 as Mix measure and 100 as Max,…

• Answered

Monitoring health of pyramid analytics server and in memory db components- telegraf

Does pyramid analytics connect nicely to any telemetry tools like influxdata’s telegraf? I am hoping to manage and observe the health of pyramid analytics in grafana dashboards where we have a number…

Inserting a blank column

Hi, Trying to build a simple report. Are you able to inside a blank column in Pyramid like you would an excel document?

• Answered

Hiding a Column

Hi, Trying to build a simple report. Are you able to simply hide a column in Pyramid like you would an excel document? For example - Where some columns pull through blank i'd like to simply hide.

• Answered

Measure Waterfall chart operational in version 2020

Hello all, I'm working in version 2020 and I am struggling to get the custom visual measure waterfall chart to behave. Is there a bug within this object.…

• Answered

Is there an example of how to use the API's to export a discovery as a PDF?

Hello, I've read that it's possible through the API's to export discoveries. Does anyone have example code of how to export a discovery to a PDF using the API's? Thanks, Rob Clark

• Answered

Rename an element?

A quick question, and quite possibly something I have overlooked, but, is it possible to do an ad-hoc renaming of specific members within a hierarchy, in a fashion similar to altering the caption…

• Answered

Experience on Ipad's

Hi Community, for us it is currently quite challenging to get a good Pyramid experience with an Ipad. We would like to use the pyramid app as it is easier to deploy on multiple Ipad's centrally.…

Data bar indicators in discovery matrix grids 'didappaear' when all metric values are negative

I have 9 custom metrics presently displayed in a matrix grid. These were all built (to the best of my knowledge) in an identical fashion. I have applied conditional formatting to each of the metrics.…

• Answered

Azure VMs - Supported SKUs for 2023 update

What are the Azure VM SKUs that are compatible for use with Pyramid version 2023.1? During an upgrade to the latest 2023 version, the installation gave this warning:…

• Answered

Is there a way to add a discovery to a tabulation without it merging fields?

Hello, Is there a way to add a discovery to a tabulation without it merging the fields? It can be difficult to do formulas against merged columns. I know when I export to Excel I can turn merging off,…

• Answered

Building Custom Filters

Hello, I am trying to create a custom filter for my queries using the Filter() function that I have read documentation on. I believe this will be useful for what I am trying to use it for.…

Count the number of customers depending on specified levels (nested if)

Hi all, I am trying to create a count of customers depending on set Orders Recevied intervals. I.e. for the specific time periods, how many customers made orders within e.g. 1.…

• Answered

Dynamic filter for various slides in the same dashboard

Hi, I want to create a Cube based dashboard with multiple slides. I want to add a country filter for all the slides but each slide it will show just the relevant countries for this specific slide -…

• Answered

Can you switch off Totals for specific columns in a Matrix Grid

I have this grid and don't want Totals for the O'Stock columns. I tried using Colour to no avail, all help greatfully received

• Answered

Use API's to extract data from a discovery

Hello, Is there a way to make an API call to export data from a specific Discovery? Thanks, Rob

• Answered

Using cascading slicers/filters

Hey all, We have a hierarchal table like the one shown above with simple data in the table and this table is hosted in Redshift. When I do cascading slicers so 1 interacts with 2 interacts with 3 etc…

Send a separate Email containing the Password

HI All, Some clients have strict security policies and their practice for sending confidential data involves using distinct channels: never sending reports/data and passwords in the same message.…

• Answered

Connection Oracle Essbase

Hello, Someone who has connected to Oracle Essabse?, In case they connected as it was ? through an ODBC or there is another way?? Thanks,

• Answered

get a list of unique account_IDs from two lists

Hi, I have 2 lists of Account_IDs, some of them are found within both lists and some are only in one. I want to create a new list with unique account_IDs base on the combination of the two lists.…

• Answered

How to Create a measure from a dimension

I have a dimension for my custom Financial Calendar and I want to add a column to my Discovery which is filtered on Year to show the Max Period. When I try and use MAX(Data Point.…

• Answered

How to view underlying query of a discover report

Hello, I am wondering if there is a way to view the underlying SQL query of a discover report? I am not finding the performance dialog in the bottom right of my screen.

• Answered

Suppression of Columns when Column is Filled with dynamic parent

We have a challenge that we cannot solve at the moment. THe data source is a Anlysis Services Cube. We have a parameter based on a Organization Hierarchy.…

• Answered