If statement in FM

[fml55555]

Hi folks,

I have an IF statement that I need to implement in the framework manager. This IF statement checks a condition on a field in  dimension (Say D1) and then based on the result, it either picks a field from another dimension D2 or D3(else condetion).
All dimensions are connected to the same  fact (F1).

What is the best way to achieve this. Should I create a new model query subject (connected to the same fact (F1)) where I create the if statement and drag the required subjects from the other dimensions (D1, D2 and D3)?


I am kind of new to this so please forgive if this is a very basic question
Thank you very much!

The datasource is SQL
The FM is 10.2.1

Please let me know if you need more details

[cognos810]

Hi fml55555,
In the Database View, implement your relationships for the dimensions(D1,D2 and D3) to the Fact(F1). Then in the business view create the model query subject. One of the items in this MQS should be having the IF THEN ELSE/CASE statement.
CASE [Database View].[D1].[Column to choose between D2 and D3]
WHEN 'We want D2'
THEN [Database View].[D2].[Column to choose when we want D2]
WHEN 'We want D3'
THEN [Database View].[D2].[Column to choose when we want D3]
END

If I understood your question correctly, that should suffice.