EPM, No data to save

[former_member585782]

Hi Experts!

I have a problem.

1. I created some Input forms by EPM, all them worked.

2. After I allowed Member formulas on the AUDITTRAIL, Created formula [AUDITTRAIL].[Other]=[AUDITTRAIL].[Input] + [AUDITTRAIL].[IC]

3. Created new input form with AUDITTRAIL. I Input values and try to save data in a result msg "No data to save"

4. I try input data in my other reports(step 1) which worked. Result msg "No data to save".

5. Created new input form I had same result -  "No data to save".

If I create web Input form there is no problem all web forms save data.

I reinstall my EPM and Office but I have save problem.

Pls help solve my problem. Thank you.

[former_member585782 · Accepted solution]

Hi

Thanks everybody.

It was my inattention, in the report I have dimension which I don't use and it was invisible in context pane. The value of that dimension wasn't  the lowest layer of hierarchy so EPM couldn't save my data.

Regards

Amirkhan.

[former_member186338]

Hi Amikhan,

What happens if you remove the member formula?

B.R. Vadim

[former_member585782]

Hi Vadim

Thank you for your answer. Yes I removed formula It didn't help to solve my problem, but I can't uncheck (Allow Member formula) it is disabled.

[former_member186338]

Hi Amikhan,

Then you issue is not related to the member formulas...

Try to check the data sending from another computer ...

B.R. Vadim

P.S. Yes, if you Allow member formula you can't revert it back in the BPC interface.

[Former Member]

Hi,

Close excel completely and try to login again and see if that solves your problem.

Regards,

Kalyan.

[former_member585782]

Thanks for your answer but as I wrote before I completely reinstall EPM and Excel and it didn't help

Regards,

Amirkhan

[Former Member]

Hi,

Please check security if authorization changed as a result of allowing member formula.

Regards,

Kalyan.

[former_member585782]

Hi

I have sap_all. and have all admin profiles.

Regards

Amirkhan

[Former Member]

Hi,

I meant please check the Security>Data Access Profile>Select the model and see if read/write access is selected for secured diemsions.

Regards,

Kalyan.