Hi Anand
Ok so 8.1 means you are using Transformer 7.3 likely, 7.4 maybe and would possibly maybe have (Hopefully) powerplay client. Does this powercube open in powerplay client?
If it doesn't then you have a problem with the model.
If it does, compare the hierarchical tree seen in powerplay client, (dimensions on the left) with what you see in Transformer Catagory view. Do they look correct? If not then, check the model and the data sources and rebuild.
BTW, you mentioned a report so is this a saved Analysis Studio Report or is it an issue opening Analysis Studio against the powercube?
Should have asked that one first.
Anyway let me know
Cheers
Peter B