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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Discussion stats
  • 1 reply
  • 7246 views
  • 0 likes
  • 2 in conversation