Essbase data loss and data shifting due to IMPLIED_SHARE setting

Per the Oracle technical reference for IMPLIED_SHARE the following steps must be performed any time the IMPLIED_SHARE setting is changed in essbase.cfg: Add IMPLIED_SHARE FALSE to essbase.cfg. Restart Essbase Server. Create a new application and database, with the IMPLIED_SHARE setting in place. Rebuild the outline, with the IMPLIED_SHARE setting in place. Reload the data. Run aggregation or calculation scripts. Restart the application. However, the technical reference does not say what would happen if the above … Read More

Planning Bug Alert: Data form column resizing does not work in Planning v11. when the columns contain more than one dimension.

Data form column resizing (using any of the options available) does not work in Planning v11. where data forms have more than one dimension in the columns. The width resets to the default value even after the column widths have been updated. This affects the form when opened in Workspace and Smartview. Oracle has identified this as a known bug and expected to be fixed in v11. Please note: The column does resize to ‘fit … Read More

Planning Member Formula Editor does not work after applying PSU

We applied Planning PSU to fix a SmartView bug we had encountered during development. PSU did not resolve the issue, however we also noticed that after applying PSU the Planning Formula editor did not work. The page was stuck at the message ‘Loading Member Formula Editor..’ Planning was rolled back to PSU so that the Planning member formula editor can be used.  We were using Internet Explore 9, however looks like … Read More

Form Formula in Planning displays as #No ACCESS in Smartview for a non-admin user

On a recent Planning implementation we encountered an issue where a formula in a Planning form displayed #No Access in Smartview when accessed by non-admin users. When we logged in as an admin, the formula worked fine. The same formula displayed correctly when accessed through the Planning web. Planning Patch Set Update (PSU): did not resolve this issue either. We raised an SR with Oracle and after a few development iterations; Oracle confirmed … Read More