Union of custom columns (Static Values)

I am in need of creating a static dimension with multiple measure names such as: sales, expenses, cost, count, etc. These are to be given to a multiselect dropdown in a report that gives the measure names in multiple rows as per selection. I have tried creating a list of custom columns using the Union and facing the error
"Lists must use members from the same table and column"
Is there any possibility of executing this?
Thanks in advance
Ananth
7 replies
-
Hi Ananth,
this sounds as if you are looking for a Parameters! This is an option when opening Formulate...At Step 1 select "Global" (i.e. the values do not come from your model! I think you only need the names of measures, not the measures itself!), at Step 2 select "Text" as List Type and create your list by simply adding caption-value-pairs.
Finally, Step 3, select the type of slicer/filter which should visualize your parameters.
When adding this parameter to your chart the user can select a measure name from the drop down. Subsequently, the corresponding measure is assigned to a "dynamic measure placeholder" - technically a formula - which finally delivers the values of the selecred measure.
I hope that was your requirement at all! Have a look at this article which describes the interplay between a parameter and dynamic measures or dynamic dimensions: https://community.pyramidanalytics.com/t/p8y69k0/tip-of-the-day-dynamic-dimensions-and-measures
Best regards,
Michael -
Hi
Are you requiring the selection of groups of measures with a single click?
For example with one click put all the outgoing Measures ,Expense, cost, Overhead, on the rows, or with another click, Sales, Margin and Net Margin and Units sold on the rows?
Ian
-
Hi
Measures in a slicer and Measures based Parameters do not support Multi Select as an option.
I tried a number of approaches as a workaround but hit roadblocks in each one. If I ever overcome them, I'll come back and let you know.
For now, I'm afraid you're stuck.
Hope that helps.
Ian
-
Hi,
Although true multi selections on measures is not supported.
If you need a dim named "Measures" , you could consider to create it via a file ( Excel , CSV ) and uploaded it to the model.
I would preferer to create it as a table / view in the data source.
Regrading the multi selection on "Measures", if "Measures" is a dim you could link it to the tables in the model
or create a calculation with a case /if expression relative to the "Measures". currentmember.This will give the user experience ( or simulation ) of a multi selection on "Measures".
Tnx
-
Thank you!