Context Operator "In"...where can I learn the syntax?

[Former Member]

Employee	Year	Month	Count Vacation
A	2015	August
A	2016	August
B	2015	August
B	2016	August

Thank 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...

[Former Member · Accepted solution]

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

[amitrathi239]

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.

[Former Member]

Thank you all for your help...

[Former Member]

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]

[Former Member]

Default context is something which gets applied automatically to a measure value based on dimensions included in the block you don't have to worry about that.

I don't recommend you to use the second formula

[Former Member]

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

Above document will help you learn the syntax