cancel
Showing results for 
Search instead for 
Did you mean: 

Unit Conversion In SAP BI ( Query Desiner ) using RSUOM :

Former Member
0 Kudos
711

Unit Conversion In SAP BI ( Query Desiner ) using RSUOM :

No Quantity conversion possible :

I want to convert the quantity from " cases" to "8 ounce" using RSUOM .

I uploaded the data in GENERATED DATASTORE OBJECT (UNITS OF MEASURE) as per standard procedure . Screen shot attached .

when excuting the query in RSRT , found the messages

Internal
error: No assignment of DataStore object to DB table

No quantity conversion possible

Kindly help ASAP . I would appreciate your inputs .

Accepted Solutions (0)

Answers (2)

Answers (2)

bhavinvyas
Active Contributor
0 Kudos

Hi Amod,

Go to RSA1 > Source System > right click your ECC Production system > Go to transfer global settings > select Unit of Measurement option   > Select mode as update tables > Execute.

Thanks,

Bhavin Vyas

Former Member
0 Kudos

Hi Bhavin ,

Thanks for the reply . I already done when data was not activated in DSO .

swati_gawade
Contributor
0 Kudos


Hi Amod,

Go to RSRT and perform 'Generate Report' check if you are able to see a different error message.

Go to the DSO check if its in correct Active status. Perform RSRV checks on the DSO. there could be a problem with your DSO definition.

if all seems fine then try to create a test query on a different infoprovider with same conversion. check if issue persists then there is problem with conversion if not then problem with infoprovider.

Hope this helps.

-swati.

Former Member
0 Kudos

Hi Swati ,

The info provider is standard and I attached screen shot too . I followed the standard method by SAP and the document :

Kindly go through the link :

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00944f2f-c3e8-2c10-ccb5-a6e4cc882...

swati_gawade
Contributor
0 Kudos


Please check if conversion ratio is available in T009 table for require conversion.

-swati.

Former Member
0 Kudos

Conversion ratio is already availble in the data stored in standard DSO