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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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