Date:         Sun, 31 Jan 2010 03:50:15 -0800
Reply-To:     Ludwik Dylag <ldylag@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ludwik Dylag <ldylag@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: OLAP permissions / ACL
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

We need to build new cubes, so setting cube's metadata once is not
enough.
Because after "proc olap create" we need to do something like "revoke
select on dimension from group" OR "assign MyACT on cube"

>
> When you say builds cubes monthly if you are actually just trying to
> update an existing cube then there is a better way.
>
> You have to remeber that like most of SAS nowadays cubes have 2 main
> parts, the physical data and the metadata.  If your just trying to
> update the data (ie refresh) then you only need to update the physical
> data as you will have set up the metadata when first building the cube
> (part of the metadata is the security permissions).
> So moving forward with this what you can do in order to perform an
> update of the cube data is to delete the physical data only and then
> create the physical data and all this without touching the metadata
> which means that whatever security you have applied will continue
> after the update has completed.
>
> To do this you would need code similar to:
> Proc OLAP Delete_Physical
>           Data=&Data.
>           Cube=&cube.;
> METASVR olap_schema="SASMain - OLAP Schema";
> Run;
> The above deleted the physical data whilst leaving the metadata.  Then
> Proc OLAP Data=&Data.
>           cube=&cube.;
> METASVR olap_schema="SASMain - OLAP Schema";
> Run;
> This will then rebuild the physical data again leaving the metadata.