topic Connect SAS Visual Analytics with SSAS Cubes in SAS Visual Analytics

Connect SAS Visual Analytics with SSAS Cubes

Achraf_Ougdal — Tue, 02 May 2023 10:04:38 GMT

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 — Tue, 02 May 2023 11:44:19 GMT

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 — Tue, 02 May 2023 12:35:45 GMT

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

Thank you

AhmedAl_Attar — Tue, 02 May 2023 14:49:32 GMT

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

Achraf_Ougdal — Tue, 02 May 2023 14:52:18 GMT

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

AhmedAl_Attar — Tue, 02 May 2023 15:09:31 GMT

You are welcome 🙂

Amko — Sat, 06 Jan 2024 13:40:14 GMT