Re: security role lost after adding calculated members to a virtual cu

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mosha Pasumansky [MS] (moshap_at_online.microsoft.com)
Date: 11/05/04


Date: Thu, 4 Nov 2004 20:40:53 -0800

Yes, this is a known issue with non-structural updates to virtual cube.
Unfortunatelly, no solution exists other then refresh roles to get them
recreated on the server.

-- 
==================================================
Mosha Pasumansky  - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"yongli" <yongli@discussions.microsoft.com> wrote in message
news:024F7E72-561D-4E70-969F-05E89DB3F632@microsoft.com...
> I wrote a script to install a several named set and calculated members to
a
> virtual cube.  As a OLAP admin, I was able to browse the cube and found
the
> new calculated members work fine.
>
> But one of our client (belong to one of the cube role) could no longer see
> the cube.  After further investigation, we found the security file was
blown
> away after the script run.  Basically we have to remove and add the role
back
> in AS manager to restore the order.
>
> Have you seen the similar problems, what is wrong here?


Relevant Pages

  • Execution Location Problem
    ... Appologies for this recurring question. ... I have a cube with circumstances that would benefit from 100% server side ... Model uses over 240 calculated members and 10 calc cells. ...
    (microsoft.public.sqlserver.olap)
  • Re: OLAP cube build stuck (Project 2003 Server)
    ... It looks like the OLAP build just died. ... I'm thinking a Project Server ... Concerning the admin permissions needed to build the cube: ...
    (microsoft.public.project.pro_and_server)
  • Re: Syncing Issues with OLAP cube
    ... There is a PSI method to synchronize the WSS sites with the RDB, if that would work better for you and be less tedious. ... You could call this method from the Cube event handler to sync WSS items before building the cubes. ... However, to attempt an answer, all updates and changes etc in Project Server ...
    (microsoft.public.project)
  • Re: Analysis Services service hangs cube build / timeout on proces
    ... We have a rebuild of the nightly cube build and quite often the first ... Is our Production Server not ... Attempted to Process the cube through SQL Server Management Studio ... OLE DB error: OLE DB or ODBC error: Operation canceled; ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Viewing Cube data in a client web browser
    ... Logon a client machine with the user name and password you are using to log ... If you cannot browse the cube from the client but the server. ... >>> view a report generated with OLAP cube. ...
    (microsoft.public.sqlserver.olap)