Search code examples
mdxiccube

iccube DEFAULT time dimension vs NON-DEFAULT


What are the differences between a DEFAULT time dimension and another time dimension ? Is it just like for the default measure, i.e. used if no measure is mentionned in a MDX?

Can we do exactly the same things with a non-default time dimension ?

I'm thinking about Evolutions, running sums, avg, dtXXX functions, ytd function.


Solution

  • The DEFAULT time dimension is the one that is going to be used in custom rollup aggregation (www) when you do not define any hierarchy and a few MDX time functions when no hierarchy is defined (Ytd, Qtd, Mtd, Wtd ...).

    Apart from that there is no difference with a regular time dimension.