Why My Data Form is Still Read Only...!!!


Why My Data Form is Still Read Only...!!!

There are times when we wonder why our data form is read only, there can be many reasons,

various points can be checked to get rid of this. I will try to jot down few of the them which 

 may take you out of this situation.

1. Refresh the database, because whenever you open a data form, Planning communicates 
with Essbase to retrieve data for that combination, if the member  is not present in Essbase 
then the form will be read only for a particular row if the new member is in the row.

2. The next thing that can be looked if its a read only form or not. To check it, you can edit the 

 web form and can look in the other option's tab and make sure Make Data Form Read Only is 

 not checked, you will find this option under Display Properties, here is a link for details. You 

 cant check this option for Composite data forms.

3.  Make sure all the members in the data from are level 0, you might want to check Page and 

 POV members as well, because we are allowed to enter data only at the level 0 through data 

 forms(Talking about bottom up Versions). Even if a single member in the member combination 

 is not level 0 that combination will be read only.

4. Check if Scenario is open for the period for which you are trying to enter data. Here is 

 the link for detailed info on it. 

5. If the data form is read only for BegBalance only, then again scenario dimension comes in to 

 picture, make sure you have checked Include BegBalance as Time Period. You can check the 

 same by editing the scenario .

6. Make sure members in Page and POV are with data storage property Stored or Never 

 Share.

7. As we know that every web form is designed for a single plan type and every account 

 dimension member has a source plan type, make sure that source plan type of account 

 members is same the one for which data form is designed. You can edit the account member 

 to find the  source plan type for that member.

8. If its a multi currency application, check if you entering data at Local Currency Member.

9. Check if the Entity Member for which data form is read only is not a part of active planning 

 unit, in other words check if workflow is started. Easiest way is to edit the scenario and 

 uncheck enable for Process Management.

10. Cell is of Green Color (#87C7CA) background, it means there are supporting details for 

 this cell, you need to double click the cell to make changes.  

11. If admin is able to write in the data from but a user/ few users is/are unable to then make 

 sure that user has the write access to all the members in the intersection.

12. If you have included Asymmetric Section then, Planning gives you an option to 

 make Asymmetric Row/ColumnRead Only. 
Will be adding more if something pops into my mind later. 

Cheers..!!!
Rahul S.
https://www.facebook.com/HyperionPlanning

Comments

  1. AnonymousDecember 19, 2013 at 12:50 PM

    Thank you for this blog. Helped me!

    ReplyDelete
  2. Dermott BeverleyJanuary 24, 2014 at 3:53 AM

    We were inadvertently trying to design a form with the Reporting Currency on the selection. Doing this made the form "read only". Just another one to note.

    ReplyDelete
  3. Dermott BeverleyJanuary 24, 2014 at 3:55 AM

    Creating a form with the reporting currency showing on the form as the "input" currency will also make the form Read Only.Just another one to note/add.

    ReplyDelete
  4. AnonymousJune 20, 2014 at 9:07 AM

    I use this list a lot. I've been using Planning for years and it still catches me out! Thanks

    ReplyDelete
  5. UnknownMay 10, 2016 at 8:46 AM

    awesome

    ReplyDelete
  6. 栋栋December 8, 2016 at 6:47 PM

    Good post to read

    ReplyDelete
  7. GiriFebruary 20, 2017 at 6:48 AM

    Wonderful Post. This helped me. Thanks.

    ReplyDelete
  8. Urbano8300November 15, 2017 at 3:51 PM

    This once again saved the day! Thanks.

    ReplyDelete
  9. AnonymousDecember 13, 2017 at 8:57 AM

    Your blog saved me on so many occasions. May God bless you and I owe you a lunch. Let me know if you are in mid-west next time. :-)

    ReplyDelete
  10. AnonymousJanuary 13, 2018 at 2:17 AM

    Wonderful post !!

    ReplyDelete
  11. AnonymousMarch 27, 2018 at 4:04 AM

    very useful post

    ReplyDelete

Post a Comment

Popular posts from this blog

Multiple Navigation Flows are Active

Image
We have witnessed an issue where application migration or sometimes service restart in PBCS/EPBCS activates multiple navigation flows.  If multiple navigation flows are active you wont be able make changes in any of them, because in order to make change in navigation flow you have to make it inactive. Typically you may end up in following situation:  Solution is pretty simple: 1. Create a copy of any of the existing navigation flow:  2. Give it any desired name:  3. Now, you will see one additional navigation flow, with inactive status: 4.  Make it active: 5.  At this point of time you will have one active navigation flow and two inactive  6. Select the additional navigation flow you have created and delete it  7. Now you are back in business: Rahul S.
Read more

The Member Does Not Exists For The Specified Cube

Image
The member "" does not exist for the specified cube or you do not have access to it. Issue:  If you are running into a issue, where for a RTP member selection is throwing an error for a missing member, this regardless of the member you have selected in RTP or regardless of rule. You may be able to execute the rule from Calc Manager and not from Planning. Reason: You may run into this issue if: 1. You have added members in Planning and have not refreshed the cube 2. For the default value of a RTP in calc member you have a member which is not valid any more for planning application 3. For the default value of a RTP in calc member you have a member which is not valid any more for a plan type Solution: 1. Refresh cube 2. Update Default value of RTP which is causing issue to member which exists 3. Deploy the rule Rahul S.
Read more

"Smart View handled an unknown exception thrown by Microsoft Office" Error on Vista, Windows 7, Windows 2008

My MS-Office Components are Crashing After Installing Smart View on Vista, Windows 7, Windows 2008! This is one more one pretty common issue,   "Smart View handled an unknown exception thrown by Microsoft Office."   This is actually a known issue in version 11.1.2.1. If you look at the read me of Smart View you will find bug# 11696583 "On Vista, Windows 2008, and Windows 7 operating systems, Excel may terminate abruptly upon launching after you install Smart View. Workaround: Turn off “User Access Control” in User Accounts, available from the Control Panel." Here is the link to read me: http://download.oracle.com/docs/cd/E17236_01/epm.1112/readme/sv_1112100_readme.html When the User Access Controls are on Smart View faces problem in registering, when you set it off Smart View register itself like a charm. To have more information on UAC: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx Now, when y...
Read more