August
B 2015 August B 2016 AugustThank you always in advance for your warm guidance and generous help...
My variable Count Vacation contains formula:
=Count([Vacation]) In ([Employee];[Year];[Month])
1.What does semicolon mean? Does order of dimensions matter?
2.How is it different from:
=Count([Vacation]) In ([Employee]) In ([Year]) In ([Month])
3. Is there any page where it explains IN context operators...?
Thank you...
Hi Hayden,
Refer the Webi user guide which explains this in detail:
https://help.sap.com/businessobject/product_guides/boexir31SP2/en/xi31_sp2_webi_ffc_en.pdf
https://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp5_ffc_en.pdf
Regards,
Mithilesh
Hello Hayden,
The semicolon is used to include multiple dimensions to be used with In operator
If you use the second part of the code the measure value bifurcation will be different than your first part
All you need to Know about IN, ForEach & ForAll Context Operators
Above document will help you learn the syntax
For me these two are different formulas..Tested with your data and got the different result.
I would suggest check your detail data and compare what you are getting same or not.
Dear All,
1. Thank you for the pages.
I was able to confirm that my first variable formula is correct...
2. What I am still struggling is default output context...
Would you recommend it putting it like this?
=Count([Vacation]) In ([Employee];[Year];[Month]) In ([Employee]
Add a comment