'->' Operator

[Vick]

Does anybody know what is the function of '->' operator. I know it is used for Dimensional data but not sure where can we use it.

I would really appreciate if somebody can give me example for it.

Thanks in advance,
Vick

[Kattrix]

You are correct that it is used with dimensional sources. It is used in the string that identifies a unique member within the hierarchy (aka MUN). Normally, when pulling a member into a data item, the -> symbol is added automatically.

However, there are cases where you might create this MUN string on your own... for example,
1. when creating a member prompt inside a data item
[namespace].[dimension].[hierarchy].[level]->?myPromptHere?

2. when using macros to create dynamically written MUNs based on user selections or for rare complex drill-through/prompting situations.