Skip to Content
0
Dec 07, 2019 at 08:00 PM

#Multivalue Error - HANA Database delegated measure

100 Views Last edit Dec 07, 2019 at 08:05 PM 3 rev

Hi Experts,

I am using BO 4.1 IDT, Webi and HANA as backend. The issue iam getting is #MULTIVALUE in Actual Measure Object.

please see the screenshot attached for more info.

I tried below formulaes options in Actual report Column but unsuccesfull:

1) =Max([Actual] ForEach ([Emp Name];[Actual])) // getting only 100. expected all values 100, 90, NULL for same Emp Name

2) = [Actual] // #MULTIVALUE

3) =sum( [Actual]) // #MULTIVALUE

4) =Sum([Actual]) ForEach ([Emp Name];[Actual]) // 190 aggregated value incorrect

5) =Sum([Actual] ForEach ([Emp Name];[Actual])) // 190 aggregated value incorrect

// #MULTIVALUE

I have provided an working sample by bringing Emp Type dimen object into the table to show the actual value splitups but user donot want Emp Type dimen object in the report layout even not as hidden column or in available objects.

Please help to resolve this error by matching with expected output table.

Appreciate your quick help.

Many thanks,

Dinya

Attachments

output.jpg (29.1 kB)