Universe giving incorrect results

[Former Member]

Hi

I have created a Universe on top of the BEx query and no issues with the Universe in UDT(4.1 Version). However when I build the webi query/Explorer on top of the universe, it's returning incorrect data.
if I use some of the dimensions and measures then it is giving the correct results.

For example if I use
Case 1:
Region, Salesorg, Product group, Customer Segment, SILLHOUETTE, CATEGROY, CUSTOMER and measures

Then the above query is giving correct results
But when I insert licence or season then we are getting wrong results.

Case 2: If we create a query,
Region, salesorg,Product group, Customer segment, LICENSE, SEASON and Measures

then it is giving correct results
But If we insert Sillhouette OR Category OR Customer, then it is giving wrong results.

Please suggest me.

Regards,
Praveen G

[former_member4998]

Hi

Can you please run the Bex Q in BW system using T.Code : RSRT with below selections

Region, Salesorg, Product group, Customer Segment, SILLHOUETTE, CATEGROY, CUSTOMER and measures

And then drill down/ insert licence or season then  check are able to see the correct results .

[Former Member]

Hi Sreenivasulu,

I have executed BEx query in BW system using Tcode RSRT with the dimensions and Measures. There we are getting correct results eventhough if we add licence and Season dimensions.

Please advise us.

--Praveen G

[rajendra_kodavati]

Hi Praveen,

Could you explain in detail about the Incorrect result set that you are getting with the inclusion of Sillhouette OR Category OR Customer ..

May be that would help us in providing either resolution or work around for the issue....