31 Juli 2012 21:41
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?
01 Agustus 2012 5:46You 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.
01 Agustus 2012 15:45
Sorry need clarification on that. I am new to it, Is there a way to do it in MDX ?