-
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
Got stuck with a report? Start a discussion or help others to move forward.