Skip to Content

Multivalue Error while grouping

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 19, 2017 at 07:01 PM

    Hi,

    Apply a context option to the variable

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

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 19, 2017 at 08:26 PM

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

    Add comment
    10|10000 characters needed characters exceeded