Skip to Content

BPC 10 – Insert a New (Dynamic) Line in an input template

Jul 26, 2017 at 11:39 AM


avatar image

Hello Experts,

I’m trying to add a new line in an input template and I would like to ask you which you think is the best approach.


  • a. After open the template must show only values with data (we need to hide zero and empty values)

Goal to achieve:

  • b.Once open, the user can add a new line and enter a new value


Step1): The user open the input template and see which data was already load:


Step2): User realize that he/she needs to upload data for account BS003 so he/she needs to insert a new line (line#3 for this new account). Ideally, the user should be able to select Account (from the dimension) and time:


Step3): User upload the new amount in the new line:


Do you have any suggestion?

Thanks you all!

p1.jpg (16.7 kB)
p2.jpg (24.1 kB)
p3.jpg (22.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Jul 26, 2017 at 01:38 PM

First - incorrect tags, has to be:

EPM Add-In for Excel


You have to use standard "Insert Members" method:

Right click on some cell on the row axis and select EPM -> Insert Members

You have to specify members for all dimensions in the row axis (ENTITY, ACCOUNT, TIME).

10 |10000 characters needed characters left characters exceeded