BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Achraf_Ougdal
Obsidian | Level 7

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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;

 

View solution in original post

2 REPLIES 2
SASKiwi
PROC Star

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
SAS Employee

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 295 views
  • 2 likes
  • 3 in conversation