EPM: Input form

[former_member697627]

Hello experts,

Is it possible to have an input form with input-ready rows, in other words, report with blank rows where users can insert their values?

When i try to do it i get this error: unable to recognize the report : unable to figure out axis content from the sheet.

Thank you in advance,

[Marc_Kuipers]

Hello Soumaya,

There is nothing special about an input form in EPM. You simply create a normal report and then you indicate on the "sheet options" that you want to use the report for input.

Then, when you enter some data in a cell (note: make sure you are at leaf-level members for all the dimensions) you can click 'save data' and the cells will be submitted to the BPC server

For more info, check https://www.youtube.com/watch?v=83ewhldFu_w

Good luck!

Marc

[former_member186338]

Sorry, but your answer is not related to the question! Question author want to add members to the row dimension by end user...

[former_member186338]

"End users are not familiar with the tool, and i cannot propose to passe by EPM insert Member."

Sorry, but you have to train them! There is no easy way of adding rows just typing a member. Automatic member recognition produce strange results in most cases.

And, please!!!!

STOP USING "Insert File" instead of correct "Insert Image"

I will not answer questions with "Insert File"

[Marc_Kuipers]

You're so kind 🙂

Maybe use CAPSLOCK all the time, so we can hear you a little better.....

[former_member186338]

You need to have at least one line with some dimension member. Then the user will be able to add more rows!

[former_member697627]

That's what i did.

But it's still not working, whenever i try to insert member manually in cells the report generates the error that i specified in my question.

[former_member186338]

soumayaitaazize

Sorry, but unable to understand, what are you doing.

Use EPM "Insert member"

[former_member697627]

End users are not familiar with the tool, and i cannot propose to passe by EPM insert Member.

As you can see on the caption, what i need is to be able to fill rows manually.

capture.png