-
"Classic Pivot table" design
Hi, I want to create a table that is similar in style to the classic pivot table in excel. In that sense I also wish to add multiple attributes from the same "dimension" from my data source/cube.…
- Answered
-
Upgrading from 2016 to 2018
Hi, We have Pyramid 2016 and are looking at upgrading to 2018. Is there any documentation around best practices for the upgrade i.e. build out another environment and have the 2 running in parallel…
- Answered
-
Difference actual week- week prev year
Hello, we would like to calculate the difference of an KPI actual year vs Previous year on weekly base (KW this year - KW prev Year). We have time attributes for Date, KW (i.e.…
- Answered
-
Show an average of the selected members of a filter.
Hi, I would like to be able to show the average of some measures I have calculated. My scenario is as follows: I have some measures shown in a line graph over time.…
- Answered
-
HR Cube - Absenteism hours - Formulate
PYRAMID Hello could someone help me on this one ? I have a HR table, in which I have 3 columns : Absenteeism days Contract hours Calculation of absenteeism hours=absenteeism days*contract hours…
- Answered
-
Comment modéliser mes données correctement
Bonjour à tous, je dois réaliser un reporting en fonction de ce fichier excel. Sur des graphiques, je dois afficher le nombre de journées CP en fonction du nombre de journées.…
- Answered
-
Hide unwanted subtotals
Hello, I'm wondering if it is possible, when including subtotals in a grid, to select which columns you want the subtotals to show for? Currently when subtotals are added,…
- Answered
-
Question on row sorting
I'm converting a BI Office chart. It's laid out like this: Slices - a date parameter at the month level Columns - Two date calculated members that I have defined in my cube (Current Period and Prior…
- Answered
-
Problems with Custom Maps
I've been creating some map reports and I have a postcode hierarchy consisting of Country, Area, District and Sector. When in the hierarchy, the shapes don't change as you drill down.…
- Answered
-
Time Intelligence in Pyramid 2018
Is it possible to get preceding 7 days of full week result or filter in Pyramid 2018? For example, when one date is picked, report should show results for the current week (the last 7 days).
- Answered
-
Question on How to use Measure Lists and Parameters
I just watched this video: https://community.pyramidanalytics.com/t/x2yy1c4/how-to-use-measure-lists-and-parameters Thanks for the video, really nice to see all these videos coming out with Pyramid…
- Answered
-
Bell curve graph
hi, the business is looking to use bell curve graphs in Pyramid to depict performance (using MEAN and Std Deviation and normal distribution). We are struggling to make it work, any insights welcome.…
- Answered
-
Optimizing a Star Schema Data Model
Is there any best practice documentation or tools available for optimizing star schema data models in Pyramid?
- Answered
-
PQL Date Query
I currently have a list that is relying on a parameter in a date format of "Mmm YYYY". This controls two separate formulations that utilise the YTD & lag functions so I can get a YTD and then a prev…
- Answered
-
Colouring different parts of a dynamic text sentence.
As per the above mentioned, is it possible to colour different sections of a sentence that are based entirely on dynamic text - or made in the dynamic text editor?…
- Answered
-
How to create date ranges and aggregate them?
Is it possible to create a date range with Start and End dates? If so, can we aggregate the range to show the values as Average or Sum?
- 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
-
Date Members in formulas
When I create a Date with a formula, using several functions, Pyramid seems to work fine: When using common date functions with the created dates, everything looks correct to me: Also,…
- Answered
-
Use a formulate to set the default parameter value
Hi, I have a parameter value which allows the user to select the GAAP Accounting Period, at the moment to make it easier i have a list which goes from 199901 to Prior month close (202304),…
- Answered
-
Date Formats in Exported Excel Files
I've had a user complaining that when they export a discovery to Excel, they are unable to filter on date columns- normally in Excel when filtering dates, they are grouped together by year,…
- Answered
-
Creating a Moving Annual Average
Hi, I am trying to create a moving annual average of customers to feature on a graph I have i created in discover (please see attached). How would I go about doing this?…
- Answered
-
After Editing MDX Query in "Query" tab in Pyramid ,not able to save changes .
Hi, After Editing MDX Query in "Query" tab in Pyramid ,not able to save changes if you save it changes in MDX query and run query then all slicer disappear.…
- Answered
-
Multi-measure pie charts
I have to measures in percentage that add up to 100% and I want to show in one pie chart both of them. I'm using version 2020.27.113 but it doesn't work for me. Could you please explain how to do it?
- Answered
-
Use single measurement as a fixed / set Measurement AND as a Dynamic Measurement at row level or in Calculation
Dear all How can I create a measurement with a set/fixed value that any filter or dimension will not impact? I am working in Higher Education, so my use case will be unique as it is not a commercial…
- Answered
-
total filter but without the dimension in discovery.
Hi I have a discovery where I have a set of premium values by reference. I want to exclude any reference where the premium value is above a set value. This is possible using the total filter which…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
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