Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

UoM Conversion

The Actual Work (Key Figure) entered in the R/3 can be in either Mins or Hour. Example:

Workorder... UoM ... Actual Work

10004593.....MIN ... 7.25

10004593.....Hour... 3.5

These transaction is loaded into BW, and store in the Cube as follow also:

Workorder... UoM ... Actual Work

10004593.....MIN ... 7.25

10004593.....Hour... 3.5

When I display this on the query, I have the following on the result:

Workorder... UoM ... Actual Work

10004593.....MIN ... 7.25

10004593.....Hour... 3.5

Question:

How can we convert the UoM from MIN into Hour???

Can this be achieve in Query Designer level or the conversion need to be built in Update Rule, how?

We're on BI7, any new functionality support this? We need it to be converted into Hour so that we can sum the Key Figure and display it as

single record on the result.

I know this can be difficult (not possible?) to achieve but I hope some of you come across this.

Please help, thank you!

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question