BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Archive by Tags

Articles tagged with: SAS Management Console

SAS Visual Analytics: Modern Theme Vs Classic Theme

2016-05-08 – 1:03 PM
admin_cvm_thumb

At the SAS Global Forum 2016 the SAS Viya platform was announced and part of the platform was SAS Visual Analytics and SAS Visual Statistics converting to the HTML5 interface. Noticeable changes were that the Designer and the Explorer have merged into one interface and there is a spiffy new color Modern theme. Dr. Goodnight said the expected release of the tool was projected to …

Web Report Studio: Switch Report Sections to Tabs in a Snap!

2013-05-28 – 7:18 AM
web report studio tabs management console

One of my gripes with Web Report Studio is that it is not always obvious that a report contains more sections. When demonstrating a report with sections, I find myself placing extra emphasis on the feature to ensure the user understands how it works.  Recently, Amit Kumar Pattnaik, a SAS BI manager, asked if I knew of a way to change the section so they were …

Admins – Need to Restore One Metadata Object from a Backup?

2013-03-11 – 10:48 AM
metadata_backup_01

When I think of corruption, it usually is more about government.  Certainly, I don’t picture myself slipping a C-Note to the metadata server for favors, such as giving me special access or maybe ensuing my jobs have priority (wink). Stig Eide, a SAS BI administrator, reminds me that corruption does occur in the metadata – but not exactly  what I was picturing.  When metadata corruption occurs, …

SAS Administration: Process Data Faster in RDBMS by Buffering the Data in Memory

2012-10-03 – 8:37 AM
SMC libname ODBC buffering

By default, accessing third party relational databases can be very slow if not configured properly.  I recently started using PostgreSQL 9.1, an open source database, to store high volumes of data for my SAS Global Forum 2013 paper.  In this example I am using an ODBC connection to connect to a database I defined in Postgres.  Native SAS/ACCESS engines to databases such as Oracle or …

SAS BI: Easy Customizations for SAS Portal and SAS Web Report Studio

2012-08-01 – 7:00 AM
wrs_banners_02

Last week I talked about how you could customize the style sheet for Web Report Studio.  One reader,  Kushal Ramani, a SAS consultant from Epoch Research India, suggested that I list some other items that you can easily change in Web Report Studio and SAS Portal.  All of these changes require access to SAS Management Console – so if you don’t have that access you …