hyperion interview questions and answers
Showing posts with label hyperion interview questions and answers. Show all posts

Planning Dataform When Trying to Edit Throws Error: "The Dataform Is Currently in Use and is Locked by User"

Issue

While trying to edit a data form in Planning application, error message stating "The data form is currently in use and is locked by user".

Cause

When the data form is closed using the using 'User AB' and not the buttons on the bottom of the screen this would have caused the form to unlock. 

Solution

To resolve this issue take the following steps:
1. Login as the Admin user, open the web form and close the web form using one of the buttons provided at the bottom of the Edit window (i.e. save or cancel).

2. No changes need to be made, just closing the window without using 'User AB' should solve the issue and the web form should be editable again.

Opening Forms In Planning Web Causes IE to Hang

Symptoms

After migrating forms from Planning 9.3.1 to 11.1.2.1, unable to open some Planning forms from within Planning web, the same forms open fine from within Workspace.

Cause

Ampersand character "&" present in the name of folder or in the name of the form.



Solution

1. Login to Planning web as an administrator.
2. Edit the form/folder which has Ampersand character "&" in the name.
3. Remove Ampersand character "&" from the Planning form/folder name.
4. Re-test the issue.

Error Opening a Data Form: "Security and/or filtering has resulted in a required dimension not being represented on this data form."

Symptoms

In Hyperion Planning when you click on a data form, you get this message:

Security and/or filtering has resulted in a required dimension not being represented on this data form.

Cause

A new dimension was added or the user trying to open the webform does not have access to at least one dimension member in the webform.

Solution

Check the following:
  1. Login to Planning web as an administrator.
  2. Go to Administration -> Manage Security filters -> create the filter for the user that is unable to open the webform.
  3. Log in to the EAS console as admin -> Go to the Essbase server -> Drill down to the Database and Edit the filter for the user (Right click on Database -> Edit -> filters).
  4. Check that the READ filter for that user includes a member for all dimensions in the NONE access line.
Additionally:
  1. In Administration-> Dimensions, give access (to that user) to a member from the missing dimension in the READ access line (from the filter)
  2. Recreate the filter for that user.
  3. Check the filter in the EAS console -> Essbase to make sure that changes have been reflected.
Subscribe to: Posts ( Atom )