There is cube and data load for this cube is successful but when I check the report data is not available . There is a navigational attribute in the report so will there be any depedency on the master data load i.e.; only after the master data load is successful will the report displays the data . Is there way to find out when the data is available in report?
The report shows data immediately the data is loaded to this cube.
If you don't load master data, then the value of this NAV attrb would be blank in report, but all other fields will show data.
I believe, due to some filter (Characteristic Restriction), the data is not beind showed in the report. Please carefully check whether there is any filter for which there is no corresponding data in cube.
To test, you can create a copy query by copying from this original query. Then remove all filters and check if data is coming in report or not.
Please feel free to ask me if you still have any question.
Thanks for your reply.
In the query they have 1 keyfigure but had unhided this keyfigure and when I run the report it only displays the characterstics and they are many filters on these charcterstics in the query designer. This report is created on cube but the rpeort is displaying data after the master data load is completed, not sure whats happening.