report does the disappearing act

[cognosfreelancer]

Hello

I have a report that opens against a remote cube deployed on a PPES 7.3 server.

The client is 7.3 as well.

When I open a particular report, there is no data in it.

However when I drag in the relevant dimension from the dimension explorer to the columns areas of the report, the data reappears.

Seems some sort of a link is broken...

Any ideas...
Thanks
NKT

[Darek]

Was it after cube was rebuild?

[cognosfreelancer]

yes that is right. it was after a cube rebuild.
NKT

[dwood09]

This type of thing could occur if you've got zero suppression on and there is no data for the report!

cheers,
DW

[GJParker]

This will happen if you change the name(s) of the dimenions which are/were on the report.

HTH

[Darek]

Or the categories change their category code.

[cognosfreelancer]

There was data for the report, as I was able to reproduce the report by dragging in the original dimension to the columns area

Or the categories change their category code.[

Hmmm... why would normally benign categories change their codes..

NKT

[Darek]

Say you are bringing in an unsorted query, where the same value repeats as source for different columns, which translate to different levels within two separate dimensions. IF those values, come in a different order on two different runs AND cube is build from a "clean and empty" model, than one of them is going to change it's value from "source" to "source~1", while the other will do the reverse.