SAP BPC: How to automatically add gl accounts in G/L Account Hierarchy within SAP BW

Hello everyone,

I need to establish a G/L Account Hierarchy within SAP BW. The account details, including their descriptions, are provided in a MS Excel file.

Currently, my workflow involves entering the transaction code rsh1, generating a text node at the appropriate hierarchy level, and then manually inputting each account and its description by copying and pasting from the excel file.

Could anyone suggest a more efficient and less time-consuming approach to add the accounts in the hierarchy in SAP BW?

Thank you in advance,