Knowledgebase: Planning
Non-Admin Users Get Error 1051544 and 0200315 When Logging into Smart View and Excel Add-In Respectively [ID 855264.1]
Posted by Priya Doyle on 26 October 2012 02:25 PM

Click to add to Favorites To BottomTo Bottom

Aug 27, 2011PROBLEMPUBLISHED3
There are no commentsComments (0) Rate this document Email link to this document Open document in new window Printable Page

 

 

Applies to:

Hyperion Planning - Version: 9.3.1.2.00 and later   [Release: 9.3 and later ]
Information in this document applies to any platform.

Symptoms

Get Error: Cannot open cube view. Analytic server error(1051544) unknown error: Not a Valid entry when logging into the Excel Add-In.

After selecting the application, get error:

Message on contacting or application (appname) Server:Error(10200315) Error Parsing Formula for [Region Definition] (line 1): Invalid Object Type

Cause


This issue was caused by not doing a complete security refresh from Planning Web.  id not perform complete security refresh.

 

Note: The non-admin status refers to the Shared Services user IDs that are not set to admin. Admin Planning users, have access to all members in all dimensions, access to all forms, and have accounts set to admin through Shared Services. Using the admin ID on the admin user machine, you can make a connection using Smart View and Excel Add-In. Using an ID that is not set to admin connecting to the same admin user machine, you will get the error message in Smart View and Excel Add-In. 

Solution

Run security refresh from Planning and recycle all the services.

1. Log into Planning Web.
2. Navigate to Administration>Manage Database
3. Select the checkbox for Security Refresh and select Refresh.

 
 
 
 
Copyright (c) 2012, Oracle. All rights reserved.   Legal Notices and Terms of Use   Privacy Statement
(4 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: