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 ?
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;
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;
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.