UOM is not converting in APO reports(Remote Cube-Bex)

[Former Member]

Hi Guru's

I am using SCM5.0 with BI7 and i have created the reports (Bex)in DP with remote cube.

Here i am unable to get the option to convert the units from ton - kg - pc.

System by default taking the ton from PA, But i need to convert this into kg/ pc in my report.

Note: I have maintained conversation in master data(product).

I think i have missed some settings in Q-Designer/ Cube settings?????

Please help me experts in this regards.

Great thanks for your help!!!!

Regards,

Santosh

[Former Member]

Hi,

Edit the Infosource based on your PA:

1. Add new KF to Communication structure - let's say QUANT_PC

2. In transfer rules for new KF choose "Routine". In ABAP code read the conversion factor from master data and calculate the quantity in PC. Assign to RESULT.

3. Activate

Now you can add new KF to your remote cube and new KF will be accessible in BEx reports.

Regards,

Alexander

[Former Member]

Hi Santosh,

Maintain unit conversion in transfer rools as subroutings.

Regards,

Alexander

[Former Member]

Hi Alex,

Thanks for your reply..Please explain me in detailed....thx for u r help

[Former Member]

Hi,

Please update this??