Auto Mapping on Transformation Between DataSource and Cube not working

[tnecnivo]

Hi BW gurus,

Recently I have installed a Standard cube (0PUR_CO1) and also installed 2 Standard DataSource:- 2LIS_02_HDR, 2LIS_02_ITM.

After I activated it, I right click on the InfoCube and create Transformation, between the Cube and the DataSource.

Normally it would have auto mapped for us right from the start, However, in this case, the Transformationm, there are none are Auto Mapped.

It has a lot of InfoObject, and apart from those obvious ones (e.g. Vendor etc) I can map manually, but there are around 80 other Characteristic and Key Figures which are not mapped automatically.

Is there are function to Autp Propose Mapping between a Source and Target?

Thanks in advance,

Vince

[former_member182343 · Accepted solution]

Hi,

It happen at times. I suggest you to Use RSOSFIELDMAP and get right combination of Field and infoobject and map them respectively.

Regards,

rvc

[tnecnivo · Accepted solution]

Hi Vijay,

May I know how to use RSOSFIELDMAP?

I've tried @ ECC, T-code: SE11 or SE16, trying to display the table, however, it says:-

"No table entries found for specified key"

Any advice on how should I check the table?

and also how to compare the table?

Thanks!

[former_member182343 · Accepted solution]

HI Vincent,

It is at BI side.

Give the Datasource name at OLAPSOURCE filed.

Give Field name at FIELDNM.

Regards,

rvc

[tnecnivo · Accepted solution]

Worked like a charm, thanks Vijay!

[sander_vanwilligen]

Hi Vincent,

As far as I'm aware there is not such a auto-mapping function in SAP BW.

In case of Business Content installation, you can be helped if the transformations or transfer rules/update rules (3.x data staging technology) are installed.

In Business Content there is a DSO in between the DataSources and the InfoCube: DSO 0PUR_O01. I assume that "legacy" 3.x data staging technology is used since the Business Content is rather old.

From an Enterprise Data Warehousing perspective I can imagine that alternative approaches can be appropriate. Please refer to my publications in the area of Data Warehouse InfoObjects and Mapping Services:

Best regards,

Sander