A dimension base member is also a node on the hierarchy

[Former Member]

Good Day Experts,

I have an issue here, I am loading master data from HR Org Unit to a BPC dimension XXX using data package, The HR Org Unit has a hierarchy which has sub-nodes on the hierarchy. The master data and the hierarchy load completes successfully but transaction load from the cube fails because the transaction data has the node but BPC does not allow data to be loaded on the node, on the dimension base members. Can you please advise of the best way I can load the master data and the hierarchy and still be able to load the transactional data on the base member/node in BPC.

Your help will be much appreciated.

Thanks,

[Former Member]

ok.. thanks I will try a badi and see if it works

[former_member186338]

Well, badi will work for sure, but you need to write correct code in this badi 🙂

I have tested standard approach with transformation and conversion - looks like not possible (it's possible to create extra members, but hard to apply hierarchy)

[former_member186338]

Looks like you have to use routine badi in transformation files to load master data, hierarchy and transactional data.

[Former Member]

Hi,

Currently in BPC:

Desired in BPC to have a leading "1000" for the nodes and the special base members below the nodes and be able to load the transactional data for an example:

10002028920 (Node)

- OU_20289720(Base member) (load transactional data)

- OU_20289745 (Base member)

100020289746 (Node)

- OU_20289746 (Base member)

100020298329 (Node)

- OU_20298329 (Base member)

- OU_20298330 (Base member)

Thanks,

Themba

[Former Member]

Hi,

The business meaning of the values is that they need to be able to report headcount and the number of employees and the org unit dimension will give them more functionality when its comes to reporting.

Thanks,.

Themba

[former_member186338]

Sorry, but I do not understand how do you want to present figures in BPC:

For example in BW you have:

Parent1: 20

..BaseMbr1: 3

..BaseMbr2: 4

..BaseMbr3: 10

What do you want to have in BPC?

[Former Member]

Hi,

As requested... see below the key figures

Thanks,

Themba

[former_member186338]

And what is the business meaning of the values?

[Former Member]

Hi,

As requested.... see below transactional data from 0PA_C01

Node 1 - 20289720

Child 1 - 20289746

Child 2 - 20298330

Please advise

Thanks,

Themba

[former_member186338]

I don's see any values! VALUES!

[Former Member]

The business value in BW for their personnel number reporting. Below is what I have on the node:

Below is the example

We are loading master data and the hierarchy from: 0ORGUNIT to our BPC dimension, see below:

In this case, member: 20289720

and We load the hierarchy (see below) again from: 0ORGUNIT to our BPC dimension, see Node Name: 20289720 (the node has data and its sub nodes )

N

Now the issue comes when we have to load the transactional data from BW to BPC from cube: 0PA_C01

BPC will not allow the data to be loaded on the node.

The reason we want to do it, it is because the transactional data on the bw cube is against the node and also the node has base members which have transactional data.

Thanks,

Themba

[former_member186338]

Sorry, but I don't see values! No transactional data samples like:

Node1 = ?

..Child1 = ?

...

..ChildN=?

[Former Member]

Hi,

We are loading master data from 0ORGUNIT but the issue is that there is duplication between dimension members and the hierarchy nodes. Transaction load from the cube: 0PA_C01 fails because the transactional data from BW is loaded on the node but BPC does not allow data to be loaded on the node.

Please advise of the best way I can load the master data and the hierarchy and still be able to load the transactional data on the base member/node in BPC.

Thanks,

Themba

[former_member186338]

What is the business value of the BW data on nodes? What do you have in children of the node? Can you provide some example with numbers?

[Former Member]

Hi,

Characteristic- 0ORGUNIT is used from 0PA_C01.

Thanks,

Themba

[former_member186338]

Then you have to load master data from 0ORGUNIT

[Former Member]

Hi,

Yes we are doing that but the issue is that the HR Org Unit has a hierarchy which has sub-nodes on the hierarchy. The master data and the hierarchy load completes successfully but transaction load from the cube: 0PA_C01 fails because the transactional data from BW is loaded on the node but BPC does not allow data to be loaded on the node.

Please advise on how I can around this issue.

Thanks,

Themba

[former_member186338]

And what characteristic is used in 0PA_C01?

[Former Member]

Hence I wanted to get clarification on comment that suggested.

Can you please on the possible solution for my issue.

Thanks

Themba

[former_member186338]

You have posted in October: "We are loading master data and the hierarchy from: 0ORGUNIT to our BPC dimension" - why not?

[Former Member]

Hi

In this post, it was suggested that I base the source of master data dimension on the organizational unit characteristic in 0PA_C01 (transactional cube). Hence I tried load the master data from this cube.

Please advise,

Thanks,

Themba

[former_member186338]

You can't load master data from cube.

[Former Member]

Good Day Gurus,

I have tried to source my master data from 0PA_C01 as suggested.

I am getting the below error when try to load master data from transactional data

Please advise ,

Thanks

Themba

[former_member186338]

"when try to load master data from transactional data" - sorry, but what do you mean???

[Former Member]

Hi,

Can you please give a sample of how transformation file would look like if the source is based on 0PA_C01.

Thanks.

Themba

[former_member186338]

Sorry, but try to do something yourself! Perform some tests and show results!

[gcybill]

Hi Themba,

You can create another master data and hierarchy loading in such a way that every node will have a respective base member representing the node. For example: OU_20289720.INP under OU_20289720

The source of master data can be based on the organizational unit characteristic in 0PA_C01.

Then, divert the transaction data loading to OU_20289720.INP instead of OU_20289720.

[Former Member]

Hi Gurus,

Any help on this matter?

Please help.

Thanks,

Themba

[Former Member]

Hi,

Currently in BPC:

Desired in BPC to have a leading "1000" for the nodes and the special base members below the nodes and be able to load the transactional data for an example:

10002028920 (Node)

- OU_20289720(Base member) (load transactional data)

- OU_20289745 (Base member)

100020289746 (Node)

- OU_20289746 (Base member)

100020298329 (Node)

- OU_20298329 (Base member)

- OU_20298330 (Base member)

Please advise on the best way we can create the special base members (master data) for the node and still be able to load transactional data.

Thanks,

Themba

[Former Member]

Hi,

We are loading master data and the hierarchy from: 0ORGUNIT to our BPC dimension, see below:

In this case, member: 20289720

and We load the hierarchy (see below) again from: 0ORGUNIT to our BPC dimension, see Node Name: 20289720 (the node has data and its sub nodes )

N

Now the issue comes when we have to load the transactional data from BW to BPC from cube: 0PA_C01

BPC will not allow the data to be loaded on the node.

The reason we want to do it, it is because the transactional data on the bw cube is against the node and also the node has base members which have transactional data.

Please advise on the best way we can create the special base members (master data) for the node and still be able to load transactional data.

Thanks,

Themba

[former_member186338]

Please show what do you have in BPC and what data you want to show in BPC!

In BPC it's possible to load data only to base members...

[Former Member]

The reason we want to do it, it is because the transactional data on the bw cube is against the node and also the node has base members which have transactional data.

Please advise on the best way we can create the special base members.

Thanks,

Themba

[former_member186338]

Sorry, but not clear! Can you provide sample with some numbers.

[former_member186338]

Looks like you aew talking about BPC standard! BPC standard doesn't support loading data on nodes, no way! You can create a special base member to load node data, but what is the reason to do it?