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_member210696 · 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.

[Former Member]

Hi Suman,

Check in your Costcenter dimension whether that member has a formula.

Thanks, Safa

[Former Member]

Hi Safa,

Thanks for the response. We are not using any formulas.

I think the issue is with some settings. When I open the cost center selection it showing the QA_OPSUPP(parent) as the selected members. But for the reamining cost centers, it is the same cost center. Please let me know how can I change this.

on the right hand side they should be 27000 and Member only.

I tried to change manually but getting error. I think there must be some setting which I need to select.

Please advise.

[Former Member]

Hi Suman,

To change it you need just to select all of the right hand members then click on the arrow left.

What is the error you are getting.

Thanks, Safa

[former_member186338]

Hi Suman,

You definitely have some issues with the members selected on the report. Just to test - create a new input form with a single 27000 member and try to save.

Vadim

[Former Member]

Hi Safa & Vadim,

Thanks for the responses. I have created new input form with single member and was able to successfully save data.

I am not able to change the members manually as the input form taking these members automatically. It is a budget template and when we select year 2014, it will display the 2015 year's periods to input data. When I try to change the members, the report is messing up and giving me error.

Please advise.

[former_member186338]

Hi Suman,

"I have created new input form with single member and was able to successfully save data" - then the issue is with your budget template.

But it's impossible to help you without detailed analysis of this template. Try to recreate it...

Vadim

[Former Member]

I have checked template and there is a vlookup in the hidden sheet which maintained few accounts to show up the parent member.

I tried deleting row which had 270000 and saved the files. Then tried to enter data but still getting same error message (cannot store data on the parent QA_OPSUPP). After deleting the row when I select member 270000, in the hidden sheet it is showing both E1 & E1 as 270000.

Please suggest do I still need to change something.