cancel
Showing results for 
Search instead for 
Did you mean: 

Alternative UOM.

0 Kudos
62

Hi,

I need to display Order unit, if it is blank I need to display UOM with the key figure.

Presently Iu2019ve added new field in the report and displaying the Order unit/UOM.

Presently i am displaying as below:

UOM (Order Unit / UOM) Qty

PC 10

EA 20

But my requirement is to display it as

QTY

10 PC

20 EA

When I use nodim itu2019s automatically picking UOM, I cont change the values of cube because its used in different report so please help me how to achieve this.

Regards,

Vikram

Accepted Solutions (1)

Accepted Solutions (1)

former_member199691
Active Contributor
0 Kudos

Do not use "NODIM" and have Qty KF in the columns, you will get both Qty and associated unit with it.

Regards,

Gaurav

0 Kudos

Hi Gaurav,

When I remove the NODIM itu2019s picking the Base UOM with Key figure, but my requirement is it should show Purchasing Order Unit (POU) if POU is blank then it should display Base UOM.

Regards,

Vikram

former_member199691
Active Contributor
0 Kudos

You can display the unit which is associated with the Qty. To acheived what you need you should create a Qty KF with Unit as POU and populate it accordingly (i.e. fill it with Base UoM if POU is blank). Then use it in the query.

Regards,

Gaurav

0 Kudos

Thank you Gaurav, my problem is solved and Iu2019ve rewarded you with points thank you very much for you help..

Answers (0)