How to import/export VA Report in SAS Viya

[mrityunjaya]

Hi

I have created some reports in SAS VA but now I am using Viya. I want to see my all VA Reports in Viya.

So, is there any procedure for that.

Please suggest, How can I do this process?

I am using Viya Version 3.4.

[BeNur]

Hi,

in general, you will need to perform the following steps:

1. load your data sources(tables used in VA report) into CAS

2. export metadata (*.spk file) of your report

3. create a mapping file between tables in LASR(VA 9.4) and CAS (SAS Viya)

4. import report into Viya

In details:

###1. login into SAS Viya Interfaces server and create/initialize profile connection

/opt/sas/viya/home/bin/sas-admin --profile dev profile init

Service Endpoint> http://<hostname of  SAS Viya Interfaces server >

###2. login into profile connection under profile

/opt/sas/viya/home/bin/sas-admin --profile dev auth login

Userid> 

###3. export spk package in SAS MC and copy it into SAS Viya Interfaces server 

###4. create mapping file from exported spk

example of exporting report:

/opt/sas/viya/home/bin/sas-admin transfer --profile dev upload --spk report.spk --mapping my_report.json

example or mapping:

{

"version": 1,

"connectors": {

"Table": [

{

"source": "default",

"target": ""

},

{

"source": "/Shared Data/SAS Visual Analytics/Public/LASR_TABLE_NAME(Table)",

"target": "CA_TABLE_NAME,caslib_name,cas-shared-default"

}

]

}

}

###5. in SAS Viya go to On the Content page in SAS Environment Manager, click import icon, and import using the Import Wizard.

More info can be found in https://documentation.sas.com/api/docsets/calpromotion/3.4/content/calpromotion.pdf?locale=en