Skip to Content
avatar image
Former Member

Percentage values are not displaying correctly in “SAP LUMIRA DESIGNER” application

We are using the below versions of the SAP BI software’s for the BI Reporting Analytics:

SAP BI BO Version:

SAP BusinessObjects BI Platform 4.2 SP 4 Patch 3

Lumira Designer Version:

SAP BusinessObjects Lumira Designer Release 2.0 SP2 Patch 1 (Version: 20.2.3)

Applications:

1.SAP Lumira Designer 2.0 SP2 Patch 1
2.Information Design Tool 4.2 Support Pack 4 Patch 3

Data Base:

Oracle

Land Scape:

We are designing the dash boards by using the “Lumira Designer” application by pointing to the BO IDT Universe(.UNX) files(Here the Universes are Built on top op of the “ORACLE” DB by using the ODBC Relational Connection)

ISSUE Details:

We are facing the issues to display the percentage values in “Lumira Designer” application level (Edit Initial View Panel & Bar Charts).

The percentage values are summing-up while removing the dimensions from the Data Source “Edit Initial View” panel Lumira Designer.

Edit Query Panel (Lumira Designer):

Here the percentage (% Closed) values are populating correctly in query panel.

NOTE:

We are created the Percentage calculation at BO IDT Universe application level:

Here we are applying the Projection Function as “Sum” for the “%Closed” Measure

%Closed = (Closed / (Closed+Open)) *100

Dimensions:

Year: MV_BICC_NO_CASES. YEAR

Case Type: MV_BICC_NO_CASES.CASETYPE

Measures:

sum(MV_BICC_NO_CASES.OPEN)

sum(MV_BICC_NO_CASES.CLOSED)

We have tried all the “Aggregation” functions at Universe level for the percentage calculation, but no solution.

Below are the aggregation functions we have tried at Universe level:

1)Sum (Issue: Values are summed up at “Lumira Designer”)

2)Average (Issue: Percentage values are not populating correctly, value diffeences)

3)Count (Issue: Not supported for percentage)

4)Min (Issue: Not supported for percentage)

5)Max (Issue: Not supported for percentage)

6)None (Issue: Not supported for percentage)

7)Delegated (Issue: Not supported for Lumira Designer, but it supported in Webi)

We also created the percentage calculation at ORACLE DB itself, and created the calculated columns at BO Universe level, facing the same issue, the % values are getting sum up once the dimensions are remove from the data source query.

If we tried the projection function as "Delegated" at the Universe level the % values are showing properly at WEBI report level but in the LUMIRA DESIGNER values are not populating correctly, the values are showing "NOT_EXIST".

Please help us on the alternate solutions to handle the percentage values at “LUMIRA DESIGNER” application.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers