I drag a measure into my crosstab. drag members into my rows and columns but all i get is 0s in my report. I checked in the cube and there are numbers in there. Am i doing something wrong and have to enable something. This is happening for all measures and all the combinations of rows & columns This is a dimensional report out of TM1 cubes
Do we have to state contexts for each dimension in the report. For eg, if i have 6 dimensions, but, my crosstab only needs data out of 2 dimensions, one in row and other in columns. Do i need to specify the other 4 dimensions in context filter else the report would throw 0s
Depending on the structure of your cube, it is very possible that you need to reference another hierarchy. Try placing a member from each hierarchy in the slicer, and running the report after each one. Can you get data from AS?
Thanks. The default member used is the root. When i put context filters for those heirarchies. It does come upwith data.