0

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

null
    • Lead Consultant Advanced Analytics
    • Michael_Daun
    • 3 wk ago
    • Reported - view

    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

      • Ananth_Periyasamy
      • 3 wk ago
      • Reported - view

       Thank you for your response.

      I however wanted to try a multiselect measure by creating a dimension and converting to list as it provided data driven multiselect option.

       

      Regards,

      Ananth

    • VP Product Management
    • Ian_Macdonald
    • 3 wk ago
    • Reported - view

    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

      • Ananth_Periyasamy
      • 3 wk ago
      • Reported - view

      Hi  ,

      I needed multi select on measure in a dropdown that needs to be append in the rows. For example, if I select the Sales, Expense, Cost from multi select dropdown the report shows as 3 rows with each measures named with corresponding selection. 

      Expected Output:

      Measures A B C
      Sales x x x
      Expense x x x
      Cost x x x

      Example for Multi Select dropdown:

       

      Regards,

      Ananth

    • VP Product Management
    • Ian_Macdonald
    • 2 wk ago
    • Reported - view

    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

    • Michael_Raam.1
    • 13 days ago
    • Reported - view

    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

    • Ananth_Periyasamy
    • 12 days ago
    • Reported - view

    Thank you! 

Content aside

  • Status Answered
  • 13 days agoLast active
  • 7Replies
  • 52Views
  • 4 Following