on 05-13-2014 12:06 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Update the formula and try changing it Detail and select an Associated object.
Thanks,
Jothi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.