cancel
Showing results for 
Search instead for 
Did you mean: 

How to remove Decimals in Quantity Objects in SAP BO Explorer View created on top SAP Bex Query?

Former Member
0 Kudos

Hi,

I created SAP BO Explorer report on top of SAP BEx Query.

In SAP BEx Query, Decimals were hided but when i created OLAP Universe on top that SAP BEx Query and Created Index on top of Information Space in SAP BO Explorer and then created Exploration Views. But i'm getting Decimals in my Exploration Views where as SAP BEx Query in RSRT, no decimals were appearing.


Can anyone suggest me how to remove decimals in SAP BO Exploration Views.


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ramana,

I am not use how you connect to SAP BEx query (Via universe or BWA or HANA)

What I could say is BWA and HANA, you cannot adjust this

For universe, you could try in universe layer, there is note about this

For BWA and HANA, this function might be enhanced but you 'd better raise OSS to SAP to check with them

Best regards

Alex yang

Former Member
0 Kudos

Hi Alex,

I have done this by using the below formulae.

<EXPRESSION>IIF(@Select(Key Figures\WAC Value)>=.49, Ceil(@Select(Key Figures\WAC Value)), Floor(@Select(Key Figures\WAC Value)))</EXPRESSION>

Answers (0)