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

Debugging Cubes

Started by dsds, 09 Jul 2012 01:23:56 PM

Previous topic - Next topic

dsds

I have some wrong numbers coming up in my cube and need to debug it. For  categories i can go and check the same in the category view. Is there a place i can see the measure values too other than looking at mdc file in Analysis studio. I think not but wanted to be sure. Else, how do you approach debugging cube

antoxic87

You can see cube content via powerPlay or report studio or Analysis studio. You need to perform queries for db and for cube that return same result. first of all you should prove connection between dims and facts. any fact table row cann't contain data in dimension link column where it must be. thus cube can be without that row.

MFGF

Is it possible you have set the data type of your measures too small and the numbers are overflowing as they get aggregated up the levels? I have seen that happen before.

Regards,

MF.
Meep!