Upload SAS Library to LASR

[Achraf_Ougdal]

Hello Everyone,

In SAS Studio, I connected to my SSAS Cube using oledb with 

libname test oledb init_string="Provider=MSOLAP.8;....";

the TEST Library was created successfully in SAS Studio, now i'm trying to load this library to LASR.

Can Anyone help ?

[SASKiwi · Accepted solution]

If you use SAS code to load into LASR memory then I find this way works well.

Note you have to delete a table before reloading it and once it is loaded it must be registered in SAS metadata to be usable.

* If table already loaded then delete first.;
proc datasets library = LASRLIB nolist;
  delete MyLASRTable;
run;
quit;

* Now reload latest table.;
data LASRLIB.MyLASRTable;
  set MyLoadLib.MyLASRTable;
run;

* Register or update LASR table in metadata. ;
 proc metalib;
   omr (library = "LASRLIB");
   folder       = "/Shared Data/SAS Visual Analytics/Public/LASR";
   select       = ("MyLASRTable");
   update_rule = (delete);
 run;

[TSBruce]

While it is possible to define a library reference to Microsoft using OLEDB, I am not aware of any way to load MS cubes to LASR for use in Visual Analytics.  You can define access to third party cubes using Enterprise Guide per http://support.sas.com/kb/41722 .  This would allow you to use SAS Enterprise Guide to navigate your SSAS cubes.