Account Type for Text Nodes - GL Account

[Former Member]

Hi,

I am loading master data from BW 0GL_ACCOUNT to BPC ACCOUNT dimension type A. As part of data load I need to load the text nodes as well for the hierarchies.

I am able to determine the Account type for individual GL accounts maintained in 0GL_ACCOUNT and not for text nodes from the hierarchy.

As of now I can manually maintain the text nodes in dimension members and its account type. But I don't see this as a ideal solution.

1. How to determine the account type for text nodes? So i can work it out in transformation file. If i maintain a conversion file for the ACTTYPE determination, for any additional node i need to change the conversion file?

2. In the transformation file, if i hard code the ACTTYPE to a particular account type for all the text nodes only will there be any impact?

'-- Selva.

[Shrikant_Jadhav]

Hi SelvaKumar,

1. How to determine the account type for text nodes? So i can work it out in transformation file. If i maintain a conversion file for the ACTTYPE determination, for any additional node i need to change the conversion file?

You need to add some logical text to identity account type in BW side. If you maintain conversoin file for this every time you need change it if any addition of text.

2. In the transformation file, if i hard code the ACTTYPE to a particular account type for all the text nodes only will there be any impact?

Impact will be all the text node will have same account type and it will give wrong result if you have different account type for text nodes.

Shrikant