cancel
Showing results for 
Search instead for 
Did you mean: 

BPC 10 - Hierarchy Master Load Issue

former_member226891
Participant
0 Kudos

Hi Team,

I am trying to load the Hierarchy Master data for G/L but I am getting 0 records.

First I loaded my G/L master data which got loaded with G/L Account No , Acctype etc. But the Hierarchy Load is not working.

When I saw in BW I can see my GL InfoObject is Compounded.But I only loaded the data with below details.

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=0

ROUNDAMOUNT=

*MAPPING

ID=ID

ACCTYPE = *NEWCOL(AST)

Now if Compounded InfoObject is my issue for Hierarchy then I changed my transformation as below.

*MAPPING

ID=0CHRT_ACCTS+ID

But even after that my Hierarchy Load is not working and also I am not getting the G/L Description in the Dimension of BPC.

Below are the snapshots of Before making changes to Transformation File and after making changes to Transformation File.

Also PFA screen shot of the error while loading the Hierarchy.

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

NODENAME=NODENAME

HIER_NAME=HIER_NAME

PARENT=PARENT

ORDER=ORDER

*CONVERSION

HIER_NAME = Test_Conv.xls

EXTERNALINTERNALFORMULA
1000PARENTH1

Please guide me on this issue as I am very much new to SAP BPC

Accepted Solutions (0)

Answers (9)

Answers (9)

Former Member
0 Kudos

Hi ,

Are you done with the issue ???

I am also facing same error.Can some one pls help me.

I am attaching the file here.

Thanks in Advance.

Santosh.

Former Member
0 Kudos

HI  Ravi,

Could you Provide Infoobject Data, how you want the data in Dimension.

former_member226891
Participant
0 Kudos

Hi Anil,

PFB the hierarchy in BW

After Loading the master data text only the GL is flowing not its Text Node

Former Member
0 Kudos

Ravi ,

Can you Show BW data As shown in the screen shot

0 Kudos

Hi Ravi,

I think the problem lies in your hierarchy text nodes in BI.

For Example:

In your case

TATA Housing Development Company Ltd has NODE NAME as 1000, since its a text node it should be a combination of text and numbers like TATA1000 (just for an example). The same applies to all other text nodes as well.

Try to create a test hierarchy in BI and see if it works.

Regards,

Vishal Ghag

former_member182709
Contributor
0 Kudos

Hi Ravi,

Can you use external format and have a try? As I know, there is a bug in BW 740. Internal format is not working. What's your BW version? BW 740?

Best regards,

Charlie

former_member226891
Participant
0 Kudos

Hi,

I have tried the external format also. BW is 7.3

satishkumar_bvv
Explorer
0 Kudos

Hi

As per my understanding from this issue, there is a sequence in BPC system when you are extracting data from BW to BPC system. 1) Hierarchies need to be uploaded 2) Text to be moved 3) Attributes has to be uploaded.

In the above case you have  been uploaded the Master data( Text and Attribute) and you were trying to uploading Hierarchies because this hierarchy list might not be part of your Load of data.

Please clear the members data of your trail loads and then start with first Hierarchy upload followed to upload Texts and Attributes.

I can see from your error screen shot the hierarchy members have not been imported properly.

Regards,

Satish

former_member226891
Participant
0 Kudos

Hi,

I tried many options but still unable to load the Text Nodes.

Please guide me what selections I should put .

Regards,

Ravi

bhagyesh_ravange
Active Participant
0 Kudos

Select last one i.e Chart of Accounts and rest unselect and load.

former_member226891
Participant
0 Kudos

Hi

Oks but what I should select in Attribute Tab if I select Chart of Accts as 1000 it only loads the GL data and not the Text Node

I can first load my GL independently then I can go for text load.

So if I use that option what should be the Transformation file parameters and the selections to load th Text Node.

Regards

Ravi

bhagyesh_ravange
Active Participant
0 Kudos

It should load Nodes also.. still nodes are not loaded?

Are you selecting yes to Import text node and giving hierarchy name...

former_member226891
Participant
0 Kudos

Hi

I have selected Yes in Text Node and also given the Hierarchy name also only selected COA in Attribute List.

Its realy wierd unable to crack where is the issue

Former Member
0 Kudos

Hi Ravi,

In the below screen, the member id is filtered to 1000, but no level is chosen. I guess its assumed as just that member alone., not the complete hierarchy.



So please try either removing the member ID filter or fill the level also to say for ex. 10 (which means 10 levels below the hierarchy are also selected)

Probably this could be the cause for text nodes not getting imported.

Bindu

former_member226891
Participant
0 Kudos

Hi,

Please guide me how can I Import Text Nodes.

The Text nodes are not flowing please help

Regards,

Ravi

bhagyesh_ravange
Active Participant
0 Kudos

In set selection you have to select import text node and give the hierarchy name..

I think you have earlier done that and also you have mentioned above that text node has been imported..

former_member226891
Participant
0 Kudos

Hi,

I missed to whether the Text Nodes were imported or not.

I just saw the G/L.

So the basic issue is that my Text Nodes are not getting loaded.

Please guide me

Regards,

Ravi

former_member226891
Participant
0 Kudos

Hi,

In my selections Attributes Tab I have chosen Chart of Accounts as 1000 so will it not only extract the G/L? How can it extract the Text Nodes?

Regards,

Ravi

bhagyesh_ravange
Active Participant
0 Kudos

Are you getting any rejected records while loading Master data..

bhagyesh_ravange
Active Participant
0 Kudos

Could you share the screen shot of your Attribute list Tab..

former_member226891
Participant
0 Kudos

Hi,

bhagyesh_ravange
Active Participant
0 Kudos

I am talking about "Attribute list" tab which is the last tab.

bhagyesh_ravange
Active Participant
0 Kudos

In that attribute list select required items.. and validate the transformation file

former_member226891
Participant
0 Kudos

Hi,

PFB

bhagyesh_ravange
Active Participant
0 Kudos

Could you go to Tcode: RSA1, Expand 0GL_ACCOUNT Info object and share the scree shot..

former_member226891
Participant
0 Kudos

Hi,

PFB the screenshots

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Ravi,

While loading hierarchy specify the Top node of hierarchy.

Shrikant

former_member226891
Participant
0 Kudos

Hi

As I am very new to SAP BW and BPC

Please guide me how can I find in BW which is the Top Node of the hierarchy.

Also where I should mention in BPC the top node.

After including Top Node would I be able to see the Description of my GL which is compunded.

Regards

Ravi

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Ravi,

BW -> RSA1 -> 0GL_ACCOUNT - > you will find hierarchy

In BPC while loading hierarchy - > set selection - > hierarchy

May be helpful ..

Shrikant

former_member226891
Participant
0 Kudos

Hi,

1 issue got resolved was my GL which is compounded was not giving any description.

But I loaded my master data again where I in the selections Hierarchy Tab I added Member ID.

But my major issue still remains is that I am unable to extract the Hierarchy.

Even I added Top Node in the Selections under Member Id but still it gave same error in Validating Transformation file that zrop records found.

PFA images of all the settings been done to load the master data and hierarchy.

Please its really urgent please help me out.

Master Data & Text

*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=
ROUNDAMOUNT=
*MAPPING
ID = 0CHRT_ACCTS + ID
ACCTYPE = *NEWCOL(AST)
*CONVERSION

Hierarchy Upload

*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=
ROUNDAMOUNT=
*MAPPING
NODENAME = NODENAME
HIER_NAME = HIER_NAME
PARENT = PARENT
ORDER = ORDER
*CONVERSION
HIER_NAME = Test_Conv.xls

EXTERNALINTERNALFORMULA
*PARENTH1

former_member226891
Participant
0 Kudos

Hi,

Also do I need to create any Nodes in BPC.

I just loaded my master data with GL's.

Do I need to create the Nodes in BPC i.e. Sources of Funds,Application of Funds etc as shown above in the BW Hierarchy Object screen shot

Also PFB the screen shot of the error.

former_member212095
Participant
0 Kudos

Hi

Kindly mention the FSV name of your heirarchy i.e. 1000 in the External column in your conversion file CONV.xls. Also mention the Hierarchy name in your selection file while loading heirarachy

Hope it helps

Regards

Gaurav

former_member226891
Participant
0 Kudos

Hi Gaurav,

I have already tried that option it was not working thats why I mentioned as * in the EXTERNAL column.

As per your suggestion I tried now but again its the same error.

Regards,

Ravi

former_member212095
Participant
0 Kudos

Hi Ravi


Pl check the file name in your transformation file


HIER_NAME = Test_Conv.xls


but your conversion file saved in CONV.xls


Try changing your conversion file name in transformation file as CONV.xls and test if it works.


Regards

Gaurav

former_member226891
Participant
0 Kudos

Hi Gaurav,

Its just a mistake I have checked it with proper file its the same issue.

Regards,

Ravi

former_member212095
Participant
0 Kudos

Hi Ravi

In your Set selection you have mentioned as hierarchy name as 1000 and member ID as 1000.

Do not mention the member ID name and try if it works.Keep it blank

Hope it works now

Regards

Gaurav

former_member226891
Participant
0 Kudos

Hi Gaurav,

I have tried that option also

Can you please check the BW Hierarchy Object that I have attached do I need to mention anything else while loading the hierarchy as per that Object

Regards,

Ravi

bhagyesh_ravange
Active Participant
0 Kudos

Can you confirm that your Hierarchy name is 1000..

former_member212095
Participant
0 Kudos

Hi Ravi

While loading master data , can you check whether the nodes are also loaded in BW.

You can check the same in your BPC account dimension.

Regards

Gaurav

former_member226891
Participant
0 Kudos

Hi,

PFB the screen shot of the hierarchy.

Hierarchy Name = 1000

Top Node Name = 1000

Please help me I am really struggling to find the solution

Regards,

Ravi

former_member226891
Participant
0 Kudos

Hi Gaurav,

Actually I am new to BPC so here Nodes you mean by Sources of Funds,Application of Funds etc as per the screenshot of the Hierarchy I have attached?

If yes then in Account Dimension I can only see the G/L I cant see any Nodes such as Sources of Funds,Application of Funds etc. So what is the issue while I loaded Master data then?

Regards,

Ravi

RamanKorrapati
Active Contributor
0 Kudos

Hi Ravi,

Are you familair with BW?

if not then please check below things.

Log into Bw server, T code - RSD1-->0GL_ACCOUNt-->display it.

Go to Tab - Hierarchy -->Maintain hierarchy --> see here you hierarchy technical name is 1000 or some other name. As i know no one will use hierarchy tech name as 1000.  please the exact techncial name of your hierachy.

Another way:

Try to load BW attributes/text/hiearachy data to 0GL_Account and run Attribute change run.

Later try to load data into BPC and see.

if you get issue, please share error logs in detailed.

Thanks

bhagyesh_ravange
Active Participant
0 Kudos

While loading master data don't mention member ID i.e 1000 in Hierarchy Tab leave it blank. and check whether nodes are loaded..

former_member226891
Participant
0 Kudos

Hi,

I have tried that but its not working.

The nodes are not flowing in BPC

Regards,

Ravi

former_member210696
Active Contributor
0 Kudos

Ravi,

Text nodes need to be imported while loading master data to load the hierarchy. Did you import the text nodes while loading master data?

Regards,

Ashish

former_member226891
Participant
0 Kudos

Hi Ashish,

I have blindly followed below 2 links to load the Master Data Text & Hierarchy.

I have also imported the Text Node.

http://scn.sap.com/docs/DOC-35363

http://scn.sap.com/docs/DOC-35364

Regards,

Ravi

former_member226891
Participant
0 Kudos

Hi,

PFA structure of the dimension.

Please help me on this.

Regards,

Ravi