-
Live Connection SAP BW - Extrapolation of Budget values to a monthly split (linear)
Hi there, I would like to extrapolate the following budget values to a monthly view from a given year view only. For example, from SAP BW we only get the annual accumulated budget figure.…
- 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
-
Combining two discovery tables in present
Hi We have two tables which we are trying to merge. The left one defines top 20 suppliers with their market share in cur month, previous month, cur ytd, current ytd.…
- Answered
-
Create a horizontal percent calculation
Hi all, is ther any possibility in Pyramid to calculate how many percent 21 - others form the sub total is? I would like to create a new culomn in wich Pyrmaid should wirte the percent for every…
- Answered
-
How to apply Cumulative Function (Percent of Total) of rows/columns in Charts.
The "Percent of Total" calculation is a context calculation that is designed to factor the "shape" of the query in determining the scope of the calculation.…
-
Change Value on horizontal axis based on variable value selected
I am trying to change dimension in horizontal axis of my graph based on the filter selected. For example, In graph I would like to change value in horizontal axis to created date year, quarter,…
- Answered
-
SSAS: Formulate across cubes and/or databases
Hi folks, is it possible to calculate values across different cubes located in the same or even in different SSAS-databases? I tried with just putting the cubes' name in front of the MDX and was…
- Answered
-
Pyramid's Calculation Engine Explained
Pyramid includes a sophisticated, multi-tiered calculation engine designed to handle the full spectrum of calculations often required in solving analytic questions and problems.…