Skip to Content
0

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

May 10 at 07:50 AM

128

avatar image

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.

10 |10000 characters needed characters left characters exceeded

Searching for this, I don't see a resolution except to try back again at the universe level. https://blogs.sap.com/2018/02/06/what-is-new-in-sap-lumira-designer-2.1-asug-webcast-question-answer/ and https://archive.sap.com/discussions/thread/3893614

You are welcome to join this upcoming webcast from SAP to ask them directly: What’s new in SAP Lumira 2.2

0

Dear Tammy Powlas,

Thanks for your reply, we have tried all the projection functions at BO IDT universe(.unx) level,

but the % values are not properly aggregated at "Lumira Designer 2.0" Edit Initial View panel as well as in the Graphs.

Please find the below screen shots in details:

Edit Query Panel (Lumira Designer):

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

Edit Initial View of (Lumira Designer):

The percentage values are not showing properly removing the “Case Type” dimension from the rows, the % values are summing up by year wise.

Percentage values are summing up by year wise after removing the “Case Type” dimension from the rows

Percentage values are summing up by year wise in Bar Charts:

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

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".

Dear all anyone can please help us on the above mentioned % percentage issue in "Lumira Designer 2.0", It is an urgent which is having the 60% dependency on the entire project.

Kindly do the needful.

Thanks,

Subba Rao.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers