1

Combine members of different dimensions as a new dimension

Hello

I am trying to create a new dimension by combining members from two other dimensions. Is this possible? For example: Combining a member from the Product dimension with a member from the country dimension in formulate.  The aim is to isolate unique combinations for analysis purposes instead of adding the dimensions to rows. 

Thank you 

Dolf Jordaan

1 reply

null
    • Senior Director of Product
    • Ian_Macdonald
    • 2 yrs ago
    • Reported - view

    Hi Dolf,

    I suspect this is a calculation you would have to perform in the Data Flow for the model you are building. If it is an existing MDX based model (SSAS or BW) then it may not be possible. If it is a Direct Query model, then the calculations would need to be performed in  a custom query that makes up one of the tables  in the model view of the database.

    If you can supply a little more back ground information on the scenario, we may be able to help further.

    Regards,

    Ian 

Login to reply

Content aside

  • Status Answered
  • 1 Likes
  • 2 yrs agoLast active
  • 1Replies
  • 45Views
  • 4 Following