Loading Hierarchy ... HANADB ==> BW ==> BPC

[Former Member]

Dear All,

I have a COST_CENTER table at HANADB(OLTP). This table - COST_CENTER , contains a column, named PARENT_ID, and it contains parent ID of the key column ID.

What I am able to do:

----------------------------

- Able to create an attribute view on COST_CENTER table at HANADB.

- Create an InfoObject at BW side and this is created on top of COST_CENTER  attribute view.

- I am able to view the COST_CENTER data at BW through the InfoObject. I am able to see PARENT_ID column data as well.

What I want to do:

------------------------

I have created a DIM_COSTCENTER dimension using BPC's web front end. This is created as an InfoObject at BW's end. Here, I need to see the COST_CENTER table's data that is available through an attribute view(created on top of COST_CENTER ).

i.e. I need to see data, including hierarchy, at the DIM_COSTCENTER. The data for this has to come from the attribute view, created on top of the COST_CENTER OLTP table.

How can I do that? I am able to load the ID and DESC data thru data manager package thru EPM add-in. However, I do not know how to load the hierarchy. As the PARENT_ID is just another column having some data(as far as OLTP/HANADB is concerned), I do not know how this column will be treated at BPC side.

Would appreciate any help on this. It seems to be very straight forward, however, I am not able to get it done. Not sure if I miss anything here.

Regards,

Peri

[former_member200327]

Hi Peri,

This only seems straight forward, but it's not.

Problem is that hierarchy in BW is stored in a number of tables each of them has completely different structure from the one you described. You can try building a view that represents those structures; then you'll be able to see InfoObject hierarchy and load as from a regular InfoObject.

Alternatively you can dump that HANA table into a flat file and load Hierarchy from that flat file.

Regards,

Gersh

[Former Member]

Hi Gersh,

You are right that it is not straight forward. The advantage of IBP for Finance/sFIN is that it is tightly integrated with S/4 HANA, allowing us to the master and actuals data from ERP in real time. Exporting/importing hierarchy might lead to data latency... unless we do the data update in real time thru' SLT.

I am still thinking of how this can be achieved otherwise.

Thanks for the response.

Regards,

Peri

[former_member200327]

Hi Peri,

I'm confused: which model of BPC are you trying to implement - Standard or Embedded?

Initially you said that you created Dimension via Web front end loaded it using DM Package - this is all Standard model. Now you are talking about real time update which is Embedded model.

Can you please clarify?

Regards,

Gersh

[Former Member]

Hi Peri,

Have you created virtual Characteristic in BW for COST_CENTER?

have a look at training course AC120, it teachers you how to do it.

Andy

[Former Member]

Hi Gersh,

He is using the new product IBPF.

It is embedded BPC on top of S/4 Simple Finance.

Andy

[former_member200327]

Hi Andy,

IBPf is not new. It has same capabilities as Embedded model - you just can map InfoObjects directly to HANA objects. But you can't use DM Packages in IBPf and you don't create Dimensions in Web in IBPf.

It's one or another, but not both.

-Gersh

[Former Member]

Hi Gersh,

Thanks for the response.

It is a standard model.

Actually I have created Virtual Charactertistics at BW in which one of the attribute is the ParentId. I am able to load ID and other attributes from virtual characteristics into a dimension, created via Web front end (standard model), successfully via DM package.

And, I wanted to know how to the load hierarchy of the dimension from the ParentId attribute of the virtual characteristcis. This is where I am stuck. Hope this clarifies the requirement.

Regards,

Peri

[Former Member]

Yes, Andy.

I am using IBPF to create a Virtual Characteristics.

However, my requirement is to load one of the attribute of the virtual characteristics as the hierarchy of the standard model dimension. Hope this clarifies my requirement.

Regards,

Peri

[Former Member]

Thanks, Andy.

Yes, I have created virtual char. for COST_CENTER. ANd, I am able to view the data at BW side.

Thanks,

Peri

Message was edited by: Folu Kehinde Removed request for copyrighted material

[former_member186338]

What about standard hierarchy load from BW?

[Former Member]

Thanks, Vadim.

However, I want to see an hierarchy  of OLTP at OLAP side(BW). I am still scratching my head.

Thanks,

Peri