topic Re: Upload SAS Library to LASR in SAS Visual Analytics

Upload SAS Library to LASR

Achraf_Ougdal — Mon, 15 May 2023 13:42:17 GMT

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 ?

Re: Upload SAS Library to LASR

SASKiwi — Mon, 15 May 2023 20:16:15 GMT

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;

Re: Upload SAS Library to LASR

TSBruce — Tue, 16 May 2023 12:16:10 GMT

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.