Skip to Content
0

BEX Query - Single value display instead of cumulative value

Jun 19, 2017 at 09:08 AM

82

avatar image
Former Member

I have data in infocube is as mentioned below for Equity Share values(ZJV_ESHARE).

I am geting result in BEx Query as mentioned below for Equity Share values.

I want to show the vaule of ZJV_ESHARE to my WebI report. But it is giving me cumulative values shown in the BEx screen mentioned above.

Please guide me to do the same .

Regards,
Sanjay Gajera

+91 89050 74894

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Anand Kumar Jun 19, 2017 at 09:47 AM
0

Hi,

Check the setting of the info object.

regards,

Anand

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Anand,

Thanks for the response.

Please let me know which settings i need to check.??

Regards,
Sanjay Gajera

0
Former Member

Anand,

I want single value instead of cumulative vales .Please have a look at below mentioned screen shots.

Here i need output as ZJV_ESHARE = 2.72 while it is giving me values as 195.912.

Please help me to solve this.

Regards,
Sanjay Gajera

bex-issue-1.jpg (67.2 kB)
bex-issue-2.jpg (76.9 kB)
0

HI,

Are you using any constant selection at key figure level?

Check this blog :

https://blogs.sap.com/2006/09/19/the-hidden-secret-of-constant-selection/

Regards,

Anand

0
Former Member

Dear Anand,

Can you please guide in some details as i am not able to get what you are saying for this solution.

Please do the needful.

Regards,
Sanjay Gajera

0
Loed Despuig Jun 27, 2017 at 06:37 AM
0

Hi,

I think you forgot to attached the screenshot?

Maybe you ticked the CUMULATIVE setting of your keyfigure in query designer?

Regards,

Loed

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Please find the screen shots.

I need the value is 2.721 instead of 195.912 which is the cumulation of all records with value 2.721

bex-issue-2.jpg (76.9 kB)
bex-issue-1.jpg (67.2 kB)
0