I am using http://www.obs3.com/pdf/A%20Different%20Approach%20to%20Time%20Calculations%20in%20SSAS.pdf to make a seperate dimension for the data calculations, which works in my Sales cube. But when I use the same dimension in an other cube (Called 'Procurement')
and copy the MDX in the calculations tab, I am getting some errors:
Error 57 MdxScript(Procurement) (9, 8) The 'Date Calculations' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified. 0
But the 'Date Calculations' dimension does not have a hierarchy!
Now I don't know why I am getting these errors, could you guys help me out so I can understand them and fix the problem?
Thanks you in advance,
View Complete Post