EPM Insert and Dimension Override

[Former Member]

EPM NW 10, SP 20

I am having issue with EPM Insert in my worksheet and after a search i found the note 1922033

which essentially says i can't use EPM Insert  if my report has EPMDIMENSIONOVERRIDE

Any workaround found? We can't simply say to client, it doesn't work !!!

~Dilkins

[Former Member]

Hi Andrew,

We had a similar issue couple of months back........

Wanted to use the EPM Insert functionality but couldn't use it due to Dimension Override and Suppress zero functionality.

My workaround was.......I created a local member in the Input form, for using the EPMPathLink Function. Using this Function i opened another new Excel where the user would see the same input form structure but without the override. In general, in this sheet user would only see 1 row of members, and here they can use the EPM Insert functionality to insert the row and save the data.. The same row would be reflected in the original input form after Refresh....

Hope this helps you....

Regards,

Priyanka

[former_member186338]

Ups, to my mind even VBA is better

[Former Member]

Yes Vadim.....Definately VBA is an option! I just shared what solution I had implemented....:) Hope you agree with it....

[former_member186338]

"We can't simply say to client, it doesn't work !!!" - yes, you can!

There is a logical issue between fixed members as a result of EPMDIMENSIONOVERRIDE and the ability to insert an additional member

You can use VBA to disable the cell with EPMDIMENSIONOVERRIDE to be able to insert, but I don't know your requirements (steps of user activities)

Vadim