EPM: Combobox Row
I'm designing a template with:
The objective is:
the user have whole Accounts from the hierarchy and select the Costcenter.
The initial solution I provided is using EPM Insert Member, for example, fro, Expenses, they select the CC1-SONY-DEP1-NYC or CC1-SONY-DEP1-NEW
But, they rejected this because there is thousand of CC and the users are bit lazy for use the EPM Insert Member
They requested (as they as initially) the Combobox
Combobox1: CC1 (they have CC1 to CC50)
Combobox2: SONY (they have so many brands)
Combobox3: DEP1 (they have so many Departements)
Combobox4: NYC (they have so many Citys)
after that they selecting (from backend or from EPM) I can concatenate and deliver the final costcenter.
It is possible to achieve this? What would be the alternatives.
2nd: When I open again the input template it the Costcenter should derive the Base (I will hide with empty row with columns
PS. its all because the users are lazy about it.