Dimensional report level issue..

[surendar]

Hi folks,

I am facing data issue in my report..Basically my report is based on dimensional model.

I have created a report in Analysis studio and opened in reoport studio.when i ran the report i could find data descrepancy in the heighest level.

Eg:Suppose i have Product ,Product Family,Categoty code,Category are my heirarchy levels

My first level data is wrong.when i drill down to the next level then onwards the data is matching..

Don't know where the problem exaclty.I think the model is fine bcoz the other reports based on different dimensions are working fine(data matching with database)in all levels.

Any help would really appreciate...

Thanks in Advance....