How to export and import visual analyzer xlsx data — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to export and import visual analyzer xlsx data

Received Response
11
Views
2
Comments
Jack Lu
Jack Lu Rank 4 - Community Specialist

Hello gurus,

I have uploaded some xls to visual analyzer,  then we migrate biee12c to another environment ,

we do exportServiceInstance and importServiceInstance,  but on the new environment, we lose the xls data source .

Do someone know how to export and import visual analyzer xlsx data?

Answers

  • Jack Lu
    Jack Lu Rank 4 - Community Specialist

    Any idea? Pls

  • Jack Lu
    Jack Lu Rank 4 - Community Specialist

    I found an stupid method. For example you export from an source biee12c system and import to the target biee12c system.

    1、Export xlsx file from the source biee va

    2、Import xlsx file to the target biee va, then set the xlsx permission properly, share to others. If you use the xlsx to create analytics in the source system, then in the target biee system, you need to save the analytics and confirm to set apply analytics permission to the data set.