Hi, all here,
Thanks for your kind attention.
I wonder is there any way for us to define a KPI dynamically? What I mean is whenever we browse the cube across different levels with a KPI, we can always see the KPI bound to different levels? E.g. when I browse sales for a specific region in a particular year, I can browse its KPI, and then when I change the level to a particular country instead of region level, still I am able to see its KPI.
Hope my question is clear.
I am looking forward to hearing from you shortly for your kind advices.
With best regards,
Yours sincerely,
Hi , dear experts here,
Any advices? Thank you.
With best regards,
Yours sincerely,
|||This is how KPI's work any way - If you define the KPI components based off values or calculations in your cubes.
If you defined a KPI as measures.[Gross Sales] you would see a different value for a city as opposed to a region or country.
|||Hi, Darren,
Thank you for your advices.
Could you kindly post an example piece of code here for the above KPI? E.g. [Gross Sale] across different levels of region or country. Thank you.
With best regards,
Yours sincerely,
