cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy Loading from BW to BPC (Text Node)

Former Member
0 Kudos
480

Hi SCN,

HierarchyInfoObjectNode Name
Hierarchy 10HIER_NODEHIERHIER (without numbers) < this is the problem *mother node name
Hierarchy 1 (Child node)0HIER_NODEHIERHIER001000
Hierarchy 2 (Child node)0HIER_NODEHIERHIER002000

We're wondering why can't we upload our hierarchy from BW to BPC properly where the mother node is a text node.

What we are getting in BPC are only the child nodes, so basically, it is not under one umbrella.

BPC Output:

+Hierarchy 1 (Child Node)

+Hierarchy 2 (Child Node)

Supposed Output:

Hierarchy 1 (Mother Node)

     +Hierarchy 1 (Child Node)

     +Hierarchy 2 (Child Node)

Thanks!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member

Hi Anne,

Please take some screen shot of your hierarchy in BW.

also screen shot of the transformation file, your selection screen.

Andy

Former Member
0 Kudos

Hi Andy,

The hierarchy in BW looks like this:

+0HIER_NODE AAAAA   --------> this is the TEXT node without numbers and below 12 chars

       +0HIER_NODE AAAAA0100  ------> child node with number in label and zero at the end

       +0HIER_NODE AAAAA0200  ------>child node with number in label and zero at the end

Now, are problem is when uploading hierarchy in BPC, the hierarchy in BPC is getting the child nodes. But the TOP or the PARENT hierarchy node (0HIERNODE AAAAA) is not being pulled in BPC.

We are experiencing an error which is:

Command failed: end position is out of record index.

About our transformation file,it is working fine its just that the mother node is not being pulled.

Can you suggest how are we going to get the mother node?

Thanks!

former_member190501
Active Contributor
0 Kudos

Hi,

What Options did you maintain in transformation.

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

Thanks,

Raju

Former Member
0 Kudos

Hi Andy,

Yes that is the same option we have in our file.

Thanks,

former_member190501
Active Contributor
0 Kudos

Hi,

Can you share your Set Selection -->Hierarchy  tab options.

Thanks,

Raju

Former Member
0 Kudos

Hi Raju,

The Set Selection for our hierarchy tab is:

Hierarchy Name (which is AAAAA) - Empty - Date - Member ID (which is the top/mother node)

Thanks.

former_member190501
Active Contributor
0 Kudos

Hi,

Which option selected :

set filters by attr AND hier    /  set filters by attr OR hier

If you attach screen dumps then it will be easy to investigate.

Former Member
0 Kudos

Hi Raju,

It's set filters by attr OR hier

Language tab = EN

Attributes are: 0BJ_CURR, 0COSTCENTER, 0COMP_CODE, 0PROFIT_CTR


We are experiencing an error which is:

Command failed: end position is out of record index.

Thanks

former_member182709
Contributor
0 Kudos

Hi Anne,

Can you attach your transformation file and conversion file. And what's your BPC version and BW version, e.g. CPMBPC 800 Sp14 ,BW 730, SP05

Best regards,

Charlie

Former Member
0 Kudos

Hi Charlie,

The details are as follow:

CPMBPC 801 SP8, SAP BW 731 SP14

Master Data Trans File:

master data hierarchy transformation file

master data hierarchy conversion file

thanks.

former_member190501
Active Contributor
0 Kudos

Hi,

Can you just try replace following line

PARENT=PARENT(5:12)+*STR(_PC)

as

PARENT=PARENT+*STR(_PC)  and test it.

Thanks,

Raju

Former Member
0 Kudos

Hi Raju,

It is still not working. We are using (5:12) to remove the first 4 letters and to get the characters starting from 5 to 12.

Thanks

former_member190501
Active Contributor
0 Kudos

Hi,

It seems the issue is because of substring. Can you just try with out substring .

Thanks,

Raju

former_member211812
Participant
0 Kudos

Hi Varaprasadraju

I am Also facing the same problem,

am using 1000PCSM(Hierarchy name) were child node are getting loaded but parent node is not getting loaded.

0 Kudos

Hi Toufiq,

Were you able to resolve your query/issue?

former_member186338
Active Contributor
0 Kudos