cancel
Showing results for 
Search instead for 
Did you mean: 

#MULTIVALUE error in SAP BI 4.1 SP3 WebI report after upgrade

Former Member
0 Kudos

Facing issues after upgrading from BO 3.1 SP3 to SAP BI 4.1 SP3.Below are the details:

1.The WebI report is created with 2 data providers. The report tab has a vertical  table with 2 dimensions and 3 measures.

2.In the report layout the objects displayed is coming from base dimension and not merged dimension.
3.The data in some of the rows displays as #MULTIVALUE and some of them display the value.

4.The report also have Sub totals and no breaks.

Based on point no 3, not able to verify whether the subtotals are been calculated correctly. Please share your inputs,suggestions or solutions to resolve this issue.

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

sateesh_kumar1
Active Contributor
0 Kudos

Hi Mahesh ,

This may be because of changes happened in BI 4.1 calculation engine.

consider formula rewriting tool for BI 4.1 SP3

http://wiki.scn.sap.com/wiki/display/BOBJ/BI+4.1+SP03+WebI+Calculation+Rewrite+Tool+-+WHERE+Operator

Former Member
0 Kudos

Hi Satish,

   Have referred this document. But did not help me to resolve the issue.

Thanks

Mahesh

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I had the same issue when BO migrated to v 4.1

I did this workaround along the lines of the advice of what was given to you previously:

Original Formula

[objY] =Sum([objX]=0 Or [objX]=1) + 0   - I had 0 in my formula to avoid null returns

New Formula

[objZ] = [objY] Where ([objX]  In ([objX]) =0 Or [objX]  In ([objX]) =1) + 0

Message was edited by: Jaspal Singh

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Update the formula and try changing it Detail and select an Associated object.

Thanks,

Jothi

Former Member
0 Kudos

Hi Jothi,

    I tried the way you have mentioned, but no luck.

thanks

Mahesh

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Do you have the Associated object on layout?. Drag and drop in a column and if you dont want to display hide it.

Also , did you check the Extended Merged dimension option in properties?.

Thanks,

Jothi