Hello,
I have 3 measures.
Measure 1 created from query 1.
Measure 2 &3 created from query 2.
Since webi allow only one measure, how can this be achieve? I have searched on google, but I did not found any comprehensible answers from other forum. I would appreciate if someone could help me with this.
I was unable to create a pie chart with 3 measures in Webi.
However in order to make my pie chart, I made a Calculation View in SAP Hana joining the measures from the 2 sources into one single measure.
I was then able to create my pie chart using one measure. Hence, created a variable with an IF statement to categories the pie chart.
Hi Ashraf,
Can you elaborate the requirement a bit more.
To start with you can try to include all the three measures in a variable and then using this variable.
Something of a If-else condition but then would like to know the requirement.
Hope this helps.
Regards,
Amit
That's what I was trying to do. I have created a Variable Measure Total.
Measure Total = Measure 1 + Measure 2 + Measure 3
Then created a Variable Dimension like:
If ___________ then "Measure 1"
ElseIf __________ then "Measure 2"
ElseIf ____________ then "Measure 3"
The problem is how do I differentiate them in the if condition statement.
Add a comment