BookmarkSubscribeRSS Feed
mrityunjaya
Obsidian | Level 7

 

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.

1 REPLY 1
BeNur
Obsidian | Level 7

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

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!

Discussion stats
  • 1 reply
  • 6953 views
  • 0 likes
  • 2 in conversation