Migrating SAS 9.4 OLAP Cubes into SAS Viya

[dipand1]

Hi all,
I’m in the process of moving our analytics platform from SAS 9.4 to SAS Viya and we have several OLAP cubes built on our SAS 9.4 OLAP Server that we’d like to bring over.
Could you let me know if there is a supported way to import or convert existing SAS 9.4 cube definitions directly into Viya? In particular:
Is there a built-in utility or API in Viya that reads the SAS 9.4 cube metadata (.cub) and data?
If not, what is the recommended best practice for re-creating those cubes in Viya—do we need to rebuild them manually, or is there a migration script/tool?
Any pointers to documentation or sample code would be greatly appreciated.
Thanks in advance for any guidance you can share!

[SASKiwi]

My understanding is that you need to run the SAS Content Assessment tool on your SAS 9.4 installation (it's a free download) and that will migrate your OLAP cube definitions to SAS Viya. Your cubes will need to run on a CAS Viya server as there is no OLAP server in Viya. You should be using the SAS Content Assessment tool anyway for migrating other SAS 9.4 content.

[LinusH · Accepted solution]

Like @SASKiwi says, Content Assessment should always one of first stops when planning for a Viya 4 migration.

Generally speaking, if you have Star Schema based cubes, they will be migrated as Viya Jobs.

Other Cubes will be migrated directly to CAS tables.

Things can get more complicated if you have used a lot of MDX expressions.

Any visualization on top of the cubes must be recreated manually in VA.

If you have Information Maps, they have similar migration paths.