Skip to Content
avatar image
Former Member

EPM: Combobox Row

Dear All,

I'm designing a template with:

Row:

- account

- CC

Column

- Time

- Category

etc.

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.

Thanks.

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 26, 2015 at 10:05 AM

    Still unclear - what the user will enter in this template at once?

    What dimensions are used?

    Who is responsible for what?

    How many lines will be filled (approximate)?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 06:24 AM

    Ok. Thanks.

    But, a question, when the users fills the combobox, when you save/refresh the data, the combobox values will be "reseted". Any way to sort this out?

    Lets imagine a budget holder fill the data in combobox and send to Budget Approver.

    When Budget Approver open the template he won't see the combobox filled correctly from BH, because this information it is not in the system.

    My advise would be to create a separate report so they can check the values and update the combobox in input report when they want to change something.

    There is one more (not recommended) - Create 4 new dimensions.

    What do you think?

    Any another option?

    Cheers

    Add comment
    10|10000 characters needed characters exceeded