Tag: Web Report Studio

Web Report Studio: Chops off the columns and rows …

By default, Web Report Studio only shows the first 12 columns and 40 rows of a report.  You can change the default in the Table Properties to allow as many columns or rows to display as desired.

Here is a before and after shot of the changes:

Ugly Web Report Studio Reports?

If you only use the default settings when building Web Report Studio report, the results may not be very attractive.   For instance in the following report the graphs are different sizes and the spacing between them is awkward.

To change the image s…

Web Report Studio: Yellow Icons with !

When you start a new report in Web Report Studio, you may notice that yellow icons with an exclamation point (!) appear in the work area.  This happens when you have not added any data to the objects.  In the example below, the first capture shows th…

Enabling OLAP drill-through to detail for web reports

I mentioned back in 2008 that Web Reports with OLAP source can drill-through to detail (or display the raw data records for the corresponding cross tabular cell) only after the source information map has drill-through to detail enabled. Well, there are…

Create, Access, and View Data – All the tools you need!

SAS EBI is comprised of several applications.  Here is a quick overview: Make Data SAS OLAP Cube Studio Build OLAP cube using SAS datasets. SAS Information Map Studio Build information maps from SAS datasets and OLAP cubes. SAS Enterprise Guide Connect to SAS datasets, RDBMS, and even Excel spreadsheets SAS Add-In for Microsoft Office Possible to create data in MS Excel that you can save to the server and then use in other BI Tools.  This would be an option for smaller datasets that are updated infrequently and not centrally stored, for instance, an department organization structure. Use Data Web Report Studio Create reports from OLAP Cubes, Info Maps, or SAS datasets. SAS Enterprise Guide Create reports and more from OLAP Cubes, Info Maps, or SAS datasets. Also create reports that can be shared as a stored process for the other SAS SAS Add-In for Microsoft Office In MS Excel – Create reports from OLAP Cubes, information maps, or SAS datasets.  Mix SAS data with the data from Excel spreadsheets. In MS Office/PowerPoint – create reports from cubes, information maps, or datasets.  Not as much flexibility as with MS Excel, but you can easily create report that you can share […]

Sample Data Sources

As you start to learn the SAS Information Map Studio and SAS Web Report Studio, you may want some sample data to play with or otherwise explore.  Here is a list of free sources that I have found that can help as you learn and want to challenge yourself. Simple Data Tables Here are some sources for simple data tables.  These are datasets with all of the data contained in one table and do not need to join to anything else. SASHELP This listing of data may be most familiar to BASE SAS users. This library has several ready made data sets (i.e. SHOES, CLASS, and CARS). If you do not see a SASHELP library in your list, then ask your SAS Administrator to add it. SAS Enterprise Guide Data EG 4.3 shipped with some fun ready-made simple datasets:  Bullets,  Drugs, and TotArrests.  [Hmmm …. ] This data was located in this path on my EG 4.3  installation: C:\Program Files\SAS\EnterpriseGuide\4.3\Sample\Data DATA.GOV http://www.data.gov/ has a ton of simple raw data tables on a variety of topics: earthquake activity, income data by county for 2007, and unemployment statistics.  It is actually just fun to poke around to see what is available. This site also has links to other […]