-
SSAS drillthrough
I've set up a drillthrough action within an SSAS cube, and it works fine in the pop up box in Pyramid 2018. However when you export the drillthrough to excel,…
- Answered
-
Date Parameter for multiple Date ranges
I have to create a date filter that factors in 3 different date ranges. Total date Cost Date Spent Date Each sum needs to be filtered by it's own date but want to create a parameter for one date…
- 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
-
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
-
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
-
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
-
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
-
Rolling Average IMDB Model
Hi, Is there any way of creating a 3/6/12 month rolling average in an in memory data base model? I have tried creating a range list between current member and a lagged value but this doesn't seem to…
- 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
-
Default to todays date on Date Filter
How do I get the Date Filter to default to todays date on a Discovery? ( Scenario : The user wants to look at a WTD?MTD etc up to a point in time but wants the Date Filter to defaults to today's…
- Answered
-
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
-
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
-
Azure Analysis Services
Does anyone here actively use Azure Analysis services? How do you find it?
- 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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help