Skip to Content
0

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

Jan 31, 2017 at 04:50 PM

56

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Jan 31, 2017 at 05:04 PM
0

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/

Show 5 Share
10 |10000 characters needed characters left characters exceeded

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

1

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

0

What is the member ID you have in time dimension?

0

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

time.jpg (136.3 kB)
0

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

0