Loading transaction cost data
I have a requirement implement an Excel application into SAP BPC.
Currently we have Cost hierarchy in Account Dim , all cost element are Calc members with formulas in the account dimentions , except for the basemembers.
Each of the basemembers has as source data Excel table.but this table doesn't contain information for the others dimensions that I have in my cost application
I want to load transaction data for the cost at basemembers level ( leaf in the hierarchy) ,
Exapmple of source data :
Do I have to add other dimention like Entity ,Category...How I can do that because its not in my source data ?
Or I use the lookup as the old Excel application do , then my cost cube=application will be empty ?
Please advice me .