Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

why Essbase filters not updated by Planning 9.3.1.0?

646335May 13 2009 — edited May 13 2009

Hi,
1) I added READ access to member in outline ( Planning 9.3.1) for user Sandy in two cubes but it did not create READ access in filter for third cube. How strange…

2) In that problem cube, I even cleared all data from HSP_Control_Access using DELETE FROM HSP_ACCESS_CONTROL

and restarted Planning service and ran Manage Database> refresh Filters. I added READ rights to Sandy - however, there is still no READ line in security filter fsandy in that one Planning cubes What am I doing wrong?
I even tried rebooting server and running the following:

CubeRefresh.cmd /A:PLAN2 /U:admin /P:password /C /F /DEBUG
Cube refresh completed successfully.

But I still can’t get a READ line for fsandy in filter:

fsandy
Application: PLAN2
Database: Product
Default Access: Create
Active: TRUE
Number of rows: 1
None: @IDES("Account"),@IDES("Scenario"),@IDES("Version"),@IDES("Company"),@IDES("Cost Center")

What else can I do to get filter fsandy to have a line for READ in the 3rd problem cube?

This post has been answered by JohnGoodwin on May 13 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2009

Added on May 13 2009

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

10 comments

893 views