Skip to Content
0

Multivalue Error while grouping

Jul 19, 2017 at 01:30 PM

37

avatar image

Hi,


I have a webi report built on BeX query.
I have only 3 objects in my report
Entity, FS & 1 KF.
The entity & FS are Key.

I have custom sorted the FS.
This is a Cross Tab report.
I applied Group on FS. I can see the group name in the cross tab but the measure is #MULTI VALUE".
All other FS are showing up the values.

Can someone tell me if grouping can be applied on Key object ?
The KF I use is set to "Use Standard Aggregation" in the BeX query.
Should I change to Summation ?

Version am in is BO 4.1 SP 07

This is what am trying to achieve.

FS1 FS2 FS3 FS4 FS5 FS6 FS7 Calc

Entity1 1 2 3 4 5 6 7 18
Entity2 2 3 4 5 6 7 8 21
Entity3 3 4 5 6 7 8 9 24
Entity4 4 5 6 7 8 9 10 27
Entity5 5 6 7 8 9 10 11 30

Calc is nothing but the sum of FS5 + FS6 + FS7.

Thank you
Ash

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

2 Answers

Jyothirmayee A Jul 19, 2017 at 07:01 PM
0

Hi,

Apply a context option to the variable

=Sum(FS5 + FS6 + FS7) IN ([Dimension] or [GroupName])

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded
Ashok Thiruvenkatam Jul 19, 2017 at 08:26 PM
0

Thanks Jothi. I still have the same error. :(

Share
10 |10000 characters needed characters left characters exceeded