How to create an Input Form

[former_member386290]

Hello experts.

We are on BPC10.1 NW Classic version. I want to create an Input Form as in the attached .jpg  screenshot of the mock-up Input Form. Please guide me how to do it? On this, Input form, I need to input a large number of Cost Centres and Cost Elements, which may be entered manually or be copied and pasted from an Excel sheet or a combination of bot;thus I may or may not want to use 'member selector'. The problem I face is that whatever the Cost Centres and Cost Elements I enter into this form, they start getting repeated without me doing anything!

Also how to automatically get the Time members (Fiscal Year period) in Columns based on the current dates?

Thanks

Abaper

[rishi4892]

Hi,

For getting COST CENTER and COST ELEMENTS in row axis, use EPM Member Recognition option. By Default it will keep repeating members, so you can just update the members as you want and it will be changed.

For getting TIME in Column axis, use Excel formulas to get current Time(=now()) and make it in the form of Time Dimension format, and Refer the column axis using member recognition.

Thanks,

Rishi