Dimension Description

[sap_user62]

Hello friends,

I get a file feed of transaction data from a non-ecc system which I have to load to a bpc model via BW. They sent the master data and master description as a part of the transaction feed (example product id and product description) Attribute sits in one BW infoobject and the Description is mapped to another BW infoobject in the transformation. The master data is automatically updated with the load to the BW cube.

I added a text table to the attribute. I need to create multiple DSO's to get the unique combinations of attribute and text and then load it to the BW infoobject. The transaction data is huge.

Is there a way in BPC, that i can use to map the description from a different BW object or any other way to acheive this requirement

thanks for your time

Ed.

[former_member186338 · Accepted solution]

What is the reason to load file first to BW??

Options:

1. Simple script on vbscript or javascript (about 30 lines) can process text file and generate master data file removing duplicates. This file can be directly loaded to BPC as load master data. Then the original file will be loaded as transactional data also directly to BPC.

2. Load original text file as master data load to BPC and remove duplicates in ROUTINE badi. Then load original file as transactional data also directly to BPC.

[sap_user62 · Accepted solution]

Thanks Vadim for your reply.

The feed has detailed information, which we did not want to bring into BPC model, but keep in BW for error analysis if any, to the source system.

The generation of files is automated, it places the file in BW application server and loaded to the targers by a process chain.

Can the load of files to BPC server be automated, without some manually updating to BPC server.

I will look into your option of generating a file based on the unique master data.

[former_member186338]

"Can the load of files to BPC server be automated, without some manually updating to BPC server." - for sure! You can schedule running BPC DM package to load data (master or transactional) from file. File can be located in some AL1 folder.

[sap_user62]

Thanks Vadim for your reply. I have a non-ecc (old IBM) system which generates transaction data and sends MQ messages to an ETL tool.The ETL in turn processes the messages and generates a flat file, which is consumed by BW and moved to BPC.

if I ask the source to generate a separate master data feed, source need additional queues and also additional ETL mappings for master data.

I was wondering if any way its possible in BW or in BPC

One way, is to just map the BW attribute to the ID, check in BPC if any ID's are missing description (those would be the new ones), then manually add the description in BPC Web.

[former_member186338]

OK, You have an external system. generating text file with master and transactional data.

Is it possible to generate 2 files instead of single file? First with master data to update BPC master data, second - transactional data.

Or you can process single file with some script to generate master data file and transactional data file.

[sap_user62]

its BPC standard.

[sap_user62]

Thanks Vadim for your reply

BPC - 10.1/BW7.4

example

line 1 account1 companycode1 product1 productdescrp1 amount ... and few other fields

line 2 account2 companycode1 product2 productdescrip2 amount... and few other fields

there are around 100k lines in each feed, currently I am running a listcube with aggregated product and productdescription list to update BPC dimension manually.

The BW attribute can be updated to the ID> but I am having trouble mapping the description.

[former_member186338]

BPC - 10.1/BW7.4 - standard or embedded?

[former_member186338]

Sorry, but not clear: what BPC version you are talking about?