Hi friends,
I am very new in sas va, i just start learning about sas by registering a account sas va on cloud that contains some apps like SAS vApp Data Manager, Sas management console, SAS Visual Analytic Hub and SaS vApp Ledger. i tried many times to find a way to connect to my data warehouse on oracle db from sas va cloud but i can not see any guide on that, so could anyone help me to draff a fastest way by listing preparation steps (including tools handled this tasks) to generate reports in sas va:
1. Connect to data source( my data warehouse)
2. Preparing data ( join, custom, append...ect.)
3. Design data model
4. Degisn report/dashboard
5. show report
I dont know exactly way that sas sa work, these steps a lot of tool approachs to build step by step for starting.
i am so sorry for poor question.!
regards,
J.
vachickenboy,
I too am new to SAS and I have been struggling to get my arms around this beast. I am not using the cloud, but it sounds as if the same tools are available. So, let me explain the steps that I have taken to connect to my Oracle db.
In Management Console (assuming that you have your account setup with the appropriate privileges for doing the following):
I hope this helps. Good luck!
vachickenboy,
I too am new to SAS and I have been struggling to get my arms around this beast. I am not using the cloud, but it sounds as if the same tools are available. So, let me explain the steps that I have taken to connect to my Oracle db.
In Management Console (assuming that you have your account setup with the appropriate privileges for doing the following):
I hope this helps. Good luck!
@rgreen33
I really thank for your tutorial, its very clear and helpfull! I know i need to start with management console firstly, i am practicing SAS VA, its harder than other tools.
I have experienced with IBM cognos, it requires to build some OLAP cubes before pushing a package to the web portal, Is SAS requires like that? Did you evaluate the SAS OLAP cubes?
Once, thank you so much!.
Regards,
J.
No, we are not using SAS OLAP Cube Studio and SAS OLAP Server. Our environment is setup with SAS (with Hadoop). We are using the VA tools, Data Integration Studio, and Enterprise Guide (that's more than enough for us now ). In learning this system, I have found that the thing that helped me most was to simply get a couple tables registered and then play with the tools...using the few table that I had loaded.
I have found that when using VA Designer, you need to spend a good bit of time planning your data as a first step. In other dashboard/reporting systems that I have used, I was able to do joins at the dashboard/report level. With VA Designer, it seems that the data needs to be joined and flattened already. It seems that the more time spent on data preparation, the easier the dashboard/reporting development will be.
Oh...and then there is scheduling. You have to plan your schedules so that your data will be loaded and refreshed appropriately.
Good luck!
Hi Vachichkenboy
Can you be more specific on what you want to do with OLAP cubes. In SAS we do have the OLAP cube studio, where you can visually design your OLAP cube, and then use it as is on the web tools or generate the corresponding MDX code and schedule it for a batch run.
Regards,
Keane76
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.