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

[former_member187267]

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

[former_member186338]

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/

[former_member186338]

P.S. And "And Budget 2017 is from time dimension." - absolutely strange and unsupported idea!

[former_member187267]

No Vadim,

P.S. And "And Budget 2017 is from time dimension." - absolutely strange and unsupported idea!--

This means that i am taking 2017 from time dimension not text Budget, As budget is from category dimension .

Thanks,

Prabhat

[former_member186338]

What is the member ID you have in time dimension?

[former_member187267]

2017.Input as there is budget for one year no month and year related calculation is there and even in report also there is no month related data is there so i created 2017.Input , 2016.Input like that ..

Thanks,

Prabhat

[former_member186338]

Incorrect time dimension structure, please search the forum - I have explained it number of times.