Skip to Content

Profit Center Hier resulting in #MULTIVALUE

Experts,

I am facing #multivalue error in my webi report

My Webi Report is using 2 queries

Query 1 :: Hana View based on BeX Query

Profit Center Code
profit Center Level 1,2,3..12

Query 2 :: Universe

Order Descritpion
Order Number
Profit Center Code Without leading Zeros
Costs

Now I want to display Profit Center Hierarchy, Profit Center Code and Total Costs associated with either profit centers coming from Hana view based on BeX and Universe in the report
I now merged Profit Center Code from both the queries
Merged Entity
Profit Center Code = Profit Center Code (Query 1) and Profit Center Without leading Zeros (Query 2)
and created a detailed object "Profit Center Code"

In the report,Total costs are displayed for childs but parents are shown as #MULTIVALUE error for profit centers.
In most of the cases, my child #6 is being shown with aggregated values but to its parent #MULTIVALUE is shown

I need pointers in order to resolve this issue at the earliest

I tried every possible solution from my side, but couldn't get it work
Already tried options ::
1.Avoid Duplicate Row Aggregation was also checked but it didnot help
2.Neither does min and max functions work while aggregation on cost

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 07 at 02:43 PM

    Hi Sachin,

    Make sure the right aggregation is set. Try Force Merge.

    Also try separately from each DP and compare which will give a fair idea of values of each dimension at the display.

    Some where multiple values for costs are present for the parent and thats what you need to find out . Looking at dataset will be more helpful.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 09 at 07:02 AM

    Thanks for sharing your thoughts Mark.

    Do you want me to check in the Semantic for Aggregation level ?

    Also if you could elaborate more as all the details objects been created at Hana side and they been merged at webi level.

    Attaching screen shot for your reference .

    I've also been through the

    http://trustedbi.com/2012/05/29/secret-formula/

    but unfortunately it is not working in my case. report-structure.jpg I badly need help from experts on the issue.

    Add comment
    10|10000 characters needed characters exceeded