Data saving failed

[Former Member]

Hi,

We are trying to save the data through input schedule but we are getting below error message.

We are trying to enter data for cost center 270000 which is base member of QA_OPSUPP but not on the parent. Please find below the Hierarchy.

It is fine with all the remaining cost centers. Please let me know what's wrong with the load.

Thanks,

Suman

[Former Member · Accepted solution]

After changing the hidden sheet (deleting row 270000 = QA_OPSUPP) in the main report it is still taking the parent. For example CC 200000,formula showing like below.

but for 270000, it is like this,

Please let me know what needs to be changed.

[Former Member · Accepted solution]

Suman,

Your dimension members QA_OPSUPP and 27000 have same description i.e. 'Operations Support'. Now, your EPMOlapMemberO formula says -

EPMOlapMemberO(EPMMemberDesc(F8), blah blah ) wherein your F8 is 27000. So, it picks its description which is Operations Support. Now, when system tries to find the corresponding ID for this description, it hits QA_OPSUPP first and so EPMOlapMemberO identifies QA_OPSUPP and not 27000.

Can you give it a try with below formula -

EPMOlapMemberO(F8, blah blah) - Instead of using EPMMemberDesc, just use F8 (the exact member).

Hope it helps!!

Regards,

Ashish

[Former Member · Accepted solution]

Thanks Ashish, it helped.

Actually I tried changing the description using lower case but it was still taking QA_OPSUPP. Now I changed member description to 'Operations Support(P)' and it worked.

Once again thank you all for your responses.