Non Cumulative infocube and query showing different result

[Former Member]

Hi All ,

I am working with a non cumulative infocube and when I am displaying the data I can see only one record for one date , but when query is executed I can see many records .

Can somebody explain me how these records are populated .

Data in BI

P01

Calday	plant	batch
01.01.2014	B001

Data in Query:

with filter as calday 01.01.2014     and plant P01 .

B001P01145

calday	plant	batch	Total quantity
01.01.2014	P01	123
01.01.2014	B002

Thanks in advance.

Regards ,

Abhishek bhattacharya

[Former Member]

Hi,

Can you generate the query again in RSRT using the button "Generate Report" and then check the result.

Regards,

Amit

[Former Member]

Hi Amit ,

I have done that its still showing same output.

[former_member223480]

Hi there

If the query is not based on a mutli, then you have to check your infocube, try to rebuild as a first step the indexes, if you have the same behavior execute a query directly on the infocube.

If the issue is also there then try with the rsrv repair steps to exclude any issues on the infocube.

If everything is correct then try to find the same data with the listcube on your infocube.

Thank you

Yiannis

[Former Member]

Sorry for wrong display

Data in Query:

with filter as calday 01.01.2014     and plant P01 .

calday	plant	batch	Total quantity
01.01.2014	P01	B001	125
01.01.2014	P01	B002	45

[anshu_lilhori]

Please check the data properly in cube.You have the quantity split-ed in 2 batches.

Also make sure that query is created on the same cube which you are checking and not on MP.

Regards,

AL

[Former Member]

Hi Anshu ,

Many thanks for your reply .

I have checked the data again , in BI there is only one record for that date.

It has something to do with non cumulative keyfigure , as when I am removing the keyfigure total stock I can see only one record.

Thanks in advance