Key Figure value in a report

[Former Member]

I have a report which is built off an infoset,

When I view the data in the infoset I see the following data

Doc Num Key Figure1

1234 100

1234 100

1234 100

1234 100

In the report the key Figure1 is shown as 100

I have tried to model the same on a cube where Key Figure1 and in the report my Key Figure1 is shown as 400. How can I get it to be 100 as in the info set?

Thanks

[former_member182343 · Accepted solution]

Take date charecterstic (calday) into query and make query more granular, then you will get desired output.

If you dont want to show date char in query output, them make it hide.

Regards,

rvc

[Former Member · Accepted solution]

Thanks.

I have created identical queries on both providers and both fields have Posting Date and Clearing date only in the query.

The BEx properties definition of KeyFigure1 is identical in both queries

Difference being Infoset query will show 100 for Key Figure1 info cube query will show 400 for Key Figure1. Display of data from RSA1 for both info set and info cube gives an amount of 400 in both case

[Former Member]

Changed design of cube

[anshu_lilhori]

Hi,

Please provide the complete output because the values which you are displaying cannot be possbile until there is some unique characterstic as i see you have same document number for which in report it may display 400.

Find out the unique characterstic on which you are drill dowing further and based on that you are getting repititive values.

Provide me the complete layout of the report then i will provide you the solution if it wil be techincally feasible.

Hope it helps.

Regards,

AL