How to define KPI dynamically?

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,