-
Adjust default aggregation for date drill down levels.
I have a calendar hierarchy which when drilled down from Year to quarter aggregates by summing the months in the level below; I like this functionality but would prefer to be able to have it average…
- Answered
-
Pyramid Usage Model
Hi Can someone provide a breakdown of what the usage times relate to i.e. is total time the amount of time someone has used the report in seconds , minutes or hours? What is meant by pre-query,…
- Answered
-
How to call or execute(take as data-source) an SQL stored procedure in pyramid analytics
hi all, I was trying to call an SQL stored procedure from custom query into pyramid analytics in below way. exec dbo.[Get_SalesdetailsPyramid] The statement is valid,…
- Answered
-
How to get # of days between given two dates
Hi, How to calculate data difference by using formulas. Need # days between 2 dates such as "Request Date" was available in source and "Today date". Example :…
- Answered
-
Time Intelligence Intepreting US Date when its UK Date sequence
Hi, I have a date time field formatted as dd/mm/yyyy hh:mm:ss Sample 21/09/2019 00:00:00 But Time Intelligence is interpreting is as mm/dd/yyyy hh:mm:ss Server System time has been checked as UTC…
- Answered
-
Failed while creating Formula
I am facing below issue while creating formula for particular column. failed run sql query in model source. model: SELECT SUM([_AddInfosMoves_Allowed_].…
- Answered
-
Call Stored Procedure
How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?
- Answered
-
Enabling access at Folder Level in Public Content
It would be good if we have an option to enable the access to specific folder in Public Content at folder level. At the moment it can only be enabled at object/report level,…
- Answered
-
Can Admin see which reports Users have accessed?
Hi, Can the admin account see which reports specific users have accessed? Often times client users will ask me questions, but I don't know which report they've looked at specifically.…
- Answered
-
Can't log in to pyramid?
If you have configured your Pyramid instance to use Active Directory (AD), and hear that users intermittently cannot log in, check the following, The reason might be that your LDAP address sometimes…
-
Publications with Discoveries across pages?
HI, I have a Discovery with a number of charts that in a publication will go across multiple pages, how do you paginate a Discovery in a Publication?
- Answered
-
Getting Started with Pyramid
In our first session, we will cover the basic getting started workflow from Quick Model, to Discover and finally Present. These examples are simple and designed to acquaint you with the product.…
-
Model running but no discovery building
Hi we've just upgraded to 2020, and looks great! however when I'm running a model built in prior version it runs through perfect and says no issues but it won't load up the discovery for the model?…
- 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
-
map customization
Hello everybody. I'm asking if it is possible to change the by default coloured circle for dimensions put on a map. I'd like to point on a map adresses in a city.…
- Answered
-
Roles lost and KPI's not working after update to 2020
Has anyone else experienced the loss of their Role settings in the Admin console after updating to 2020? Did anyone lose (present, but not functional) their KPIs after updating to 2020?…
- Acknowledged
-
Pyramid 2020 Addressed Issues
Pyramid 2020 release announcement Bug Fixes Admin Fixed an issue where a Tenant cannot be deleted Fixed an issue where the data sources Tenant shows as "Unknown" Fixed an issue where the Content…
-
Pyramid 2020 Released
See your analytic data with Perfect Vision Version 2020 is the major release of Pyramid this year and includes over 150 new features and functional upgrades together with numerous fixes - all…
-
Filter Slicer content based on existance of measures
Hello, I want to create a slide in Pyramid which shows a table with a measure sales of the 12 last months. The measure Sales is connected to a dimension hierachy (Organisation: subteam, team,…
- Answered
-
Cumulative total using Lists
I was looking at creating a measure for the Cumulative Quantities sold over time for individual products. I used the contextual "quick" cumulative measure within the discovery and it seemed to work…
- Answered
-
Gauge titles
Hi all, is there a way to get rid of the second part of the gauge title? It is 'All' for all of my graphs, so in this instance it's redundant. Thanks, Verity
- Answered
-
Adding more than one hierarchy level to a discovery
Is it possible to include more than one level from a hierarchy in a discovery? I need to show both City and State but as they are in the same multi-level hierarchy I can't add both.…
- Answered
-
Formating line chart series
When I try to set dashed line and data labels for only one series in line chart with roght click on item in the legend. That work for only one series and formating is not aplied to selected series,…
- Answered
-
How to contact the Pyramid support team
Users that have signed up to our support plans may contact the Pyramid support team to report any issues they have. The following information is required when creating a new support case and will…
-
Percentage of row total
Hi Is it possible to do percentage of row total ? I can see percentage of total but not on a row basis? Thanks Nick
- Answered
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help