Incorrect data retrievel in Query Panel with extra column on left most side
Can any one help me out in solving wrong data retrieval while executing.
I have 8 dimension and 1 measure in Query Panel Result Object and filter having Value Date prompt.
While executing this query. result shows wrong data. I mean data got duplicated not necessary all column cell contains record.
Universe level query shows exactly what I want but while putting dimension and measure of same query shows duplicate record in Webi due to which report shows wrong calculation.
I am using environment.
SAP BusinessObjects BI Platform 4.1 Support Pack 2 Patch 10
Please help me out in solving this.