Skip to Content

How to SAVEDimension Values in drop Down list and save it against Time ..

Hi Expert,

I am having travel input template where user will give their travel budget request .

Now I am having 2 dimension

1-Country (User Defined )

2-Post (User defined)

Now i need to have Country - Member in a drop down list like USA,INDIA, CHINA ETC.

in a country column and need to have Post - Member in a drop down list like Manger, HOD, Others- As displayed in a below given image .

Now My problem is i am not able to have save this drop down list values on below given manner and not able to save on this manner ... Please suggest how to achieve this.

And No. of Faculty, No. of Travel, Average Cost is from EOM dimension

And Budget 2017 is from time dimension.

Thanks,

Ravi

travel.png (45.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 31, 2017 at 05:04 PM

    You can't do it directly!

    The only way is to create report with some fixed rows and reference extra columns with comboboxes in EPMOlapMemberO formulas like in my blog:

    https://blogs.sap.com/2013/03/01/static-report-in-bpc-nw-10/

    Add comment
    10|10000 characters needed characters exceeded