Skip to Content
0

Profit Center Hier resulting in #MULTIVALUE

Apr 07 at 11:20 AM

44

avatar image

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.

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

2 Answers

Mark SSS Apr 07 at 02:43 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Sachin Joshi Apr 09 at 07:02 AM
0

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.


Share
10 |10000 characters needed characters left characters exceeded