If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Urgent - no data in dimensional report

Started by cogcurious, 17 Sep 2011 07:09:18 AM

Previous topic - Next topic

cogcurious

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

cogcurious

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

CognosPaul

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?

cogcurious

Thanks. The default member used is the root. When i put context filters for those heirarchies. It does come upwith data.