Skip to main content

Planning Web form not saving my data….

So I haven’t written to my blog since long and that’s just because I just did not find anything worthwhile all these days. Today I encountered a strange issue. So I thought to share with you guys.

We had a Planning web form set to input data. No Business Rules or calc scripts attached. Just an input form.

The issue : Every time any user enters the data into the form it says the data is saved but does not show up the data.

Causes: Probably one would think this might be a simple case of Implied Sharing or usage of a label only parent member with one of the single child only hierarchy in the form.. sure thing .. SO DID I!!
Its simpler than that!

Another weird behaviour: data is saved and reflects in the web form when I enter and submit through the Smart View Planning add-in

So what is the issue: the layout of the web form!
The data form was designed to check data values at CurrYr and NextYr. However the current year and next year were both set to the same value. In such a case when you enter the value in the current year intersection it just doesn't save. Now at this point I am not sure why but the strangest part is that if you enter that very same value under the NextYr column it reflects in both CurrYr and NextYr columns, so basically its just taking up the last value at the form. So either you need to remove the NextYr Column or set Next Yr to a different value to allow it to save through the web form properly.


In my case I did the latter and whoa!! Data saves now… Amazingly the same did not give me any trouble with saving data through Smart View. This issue is only specific to Planning. Now meanwhile when I am analyzing the strange behavior... do throw in your opinion guys.. J


Cheers!!

Anvi

Popular posts from this blog

Temp files related issues on your Essbase Server

While running an Aggregation process or a restructure in essbase have you ever encountered either of these: EAS quits accepting logins Essbase going down time and again. Failed Data load / Failed Data Export / Failed Level 0 export All of the above together :) In all these cases, there is a huge possibility that you are facing creation of tmp files issue on your Essbase Server, specifically if you are on Linux The Temp directory contains mostly files that are required temporarily. Many programs use this to create lock files and for temporary storage of data. Do not remove files from this directory unless you know exactly what you are doing! Many of these files are important for currently running programs and deleting them may result in a system crash. Usually it won't contain more than a few KB anyway. On most systems, this directory is cleared out at boot or at shutdown by the local system. In MS-Dos  and Windows , the temporary directory is set by the environment ...
Home

Shared Connection and Private Connection

You connect to data sources through shared or private connections. Shared Connections •Shared connections are stored in a central location and are available to multiple users through the Smart View Panel. You cannot add, edit, or rename shared connections, but you can save them as private connections, which you can edit and rename. Private Connections •Private connections are those that you create by saving a shared connection to your local computer or by entering a URL to a provider that is not configured for shared connections. When you create a private connection, it becomes the active connection. Shared Connections : 1. From the Smart View ribbon, click  Panel . 2. From Smart View Home or from the menu displayed when you click the arrow next to Home button, do one of the following: • Click a connection name under  Recently U sed . You can click    to pin items to this list. • Select  Shared Connections  to open th...
Home

Registry file to update Smart View Timeout Settings

“ The Request Timed Out. Contact your Administrator to Increase netRetryCount and netRetryInterval. IE7 and IE8 & IE9 have a 30-second timeout when waiting for communication from the server. When adding form data, Smart View can take longer than 30 seconds to get confirmation from the Planning server that the changes were made and saved. A similar constraint exists for Essbase data. Pre update registry Settings Open the command prompt window by clicking the start  button   >Search bar >Key in regedit navigate to the below path and check the existing settings you might not have” KeepAlive,ServerInfo & ReceiveTimeout ” HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings Automated Resolution Steps 1)       Create a file called “test.reg” 2)       Edit the file in notepad. 3)       Add th...
Home