Computing a Dimension from Dimensions

Question

Is there a way in Analysis services Cube processing that a new dimension can be created based on existing dimensions?

Like if I have a UTC Time dimension (Say Dimension 1). 

I want to say, if the UTC time is between A and B time, subtract or add this many minutes (Which is Dimension 2) to the UTC time and Give me a NEW dimension Local Time (Which can be Dimension 3).

Is there a way to do that?

Thanks

-Sarah

Answer 1

You can have one table for a Time/Data table and have all variations of values in this table. Then build different hierarchies out of it. So what i mean here is, for the variations of values, have a separate column for it and have it calculated when populating the time/date dimension table itself.

---

vinu

Answer 2

Vinuthan

Sorry need clarification on that. I am new to it, Is there a way to do it in MDX ?

Thanks

-Sarah