Connect SAS Visual Analytics with SSAS Cubes

[Achraf_Ougdal]

Hello Everyone,

I have a pretty simple question, Is it possible to visualize SSAS Cubes with SAS Visual Analytics ? if yes, How does it work exactly ?

Thank you so much in advance

[AhmedAl_Attar]

Hi @Achraf_Ougdal 

What is SSAS Cubes?

SAS Visual Analytics can only work with data that has been loaded into Memory (LASR/CAS) Server depending on your SAS deployment (SAS 9.4/Viya).

No connection to external sources - but you can load supported external sources into memory 

[Achraf_Ougdal]

SSAS (Sql Server Analytics Services). I understand that I should first load the data in-memory, but is it possible in my case ?

Also, could you please see this other topic ? I'd appreciate it if you're able to answer it too : https://communities.sas.com/t5/SAS-Visual-Analytics/Questions-regarding-SAS-Visual-Analytics-Install... 

Thank you

[AhmedAl_Attar · Accepted solution]

@Achraf_Ougdal 

You probably will need SAS/ACCESS Interface to OLE DB licensed and configured in order to interface with your SSAS Cubes. 

[Achraf_Ougdal]

Thank you so much for your help I really appreciate it !

[AhmedAl_Attar]

You are welcome 🙂