on 01-29-2015 4:30 PM
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
EXTERNAL | INTERNAL | FORMULA |
1000 | PARENTH1 |
Please guide me on this issue as I am very much new to SAP BPC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Ravi,
Could you Provide Infoobject Data, how you want the data in Dimension.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I tried many options but still unable to load the Text Nodes.
Please guide me what selections I should put .
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hi,
Please guide me how can I Import Text Nodes.
The Text nodes are not flowing please help
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Could you go to Tcode: RSA1, Expand 0GL_ACCOUNT Info object and share the scree shot..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi,
While loading hierarchy specify the Top node of hierarchy.
Shrikant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 |
EXTERNAL | INTERNAL | FORMULA |
* | PARENTH1 |
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.