BookmarkSubscribeRSS Feed
julie2
Calcite | Level 5

Hi,

I have a large SAS data set stored on SAS EG server. How can I let business users without any SAS knowledge to access my data from EXCEL or ACCESS database through linked data source, no programming skill is required?

Please discuss scenario with or without OLAP service on the EG server. Any link or document recommendations?

Thanks

Julia

1 REPLY 1
LinusH
Tourmaline | Level 20

Sounds like a typical job for SAS/Add-in for MS Office (AMO).

If your business users a familiar with pivot tables, using OLAP could work well (if the data is suite for multi dimensional analysis).

A part from that, AMO has pretty much the same task (wizards) as EG, an let's the user browse, filter and query data.

But when you say large, how large?

It could be performance issues with users that are not database aware, query very large tables. You may want to create smaller specialized data/information marts for some users.

You also may want to combine this with the use of information maps, which can cover database logic (such as star schema joins, row level security and caclulated columns.

You can search support.sas.com to find lot of documentation and papers on this topic.

/Linus

Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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