Blogging about all things SAS

And another great Article from BI Keynotes : http://bikeynotes.blogspot.com/2009/04/plateforme-sas92.html

This one outlines the changes in SAS 9.2 (again translated from French by Google not me!)

Out of interest anybody upgraded to 9.2 BI/DI yet?

Any feedback good or bad?

• Support for Java 5, Support for Java 5,
• Replacement of Apache Tomcat 4.1 in JBoss Application Server 4.2, Replacement of Apache Tomcat 4.1 in JBoss Application Server 4.2,
• Availability of a WebDAV server developed by SAS as a substitute for Apache HTTP Server and Xythos WebFile Server: SAS Content Server, Availability of a WebDAV server developed by SAS as a substitute for Apache HTTP Server and Xythos WebFile Server: SAS Content Server,
• Support for virtual environments (VMware, XenSource ,…), Support for virtual environments (VMware, XenSource ,…),
• Full support for Linux (Red Hat / SuSE ),… Full support for Linux (Red Hat / SuSE ),…

Platform Platform

• Electronic Software Download (ESD) Electronic Software Download (ESD)
• Simplification and automation of deployment, Simplification and automation of deployment,
• Reorganization of metadata repositories, Reorganization of metadata repositories,
• Simplifying the management of safety (abandonment of the “multiple inheritance” in favor of the “single inheritance” based on the records), simplification of security management (abandonment of the “multiple inheritance” in favor of the “single inheritance” based on the records),
• Logging standard with SAS 9.2 Enhanced Logging Facility, Logging standard with SAS 9.2 Enhanced Logging Facility
• Improving the promotion partial (formerly supported by the plugin BI Manager): Improving the promotion partial (formerly supported by the plugin BI Manager)
  • New objects supported (OLAP cubes, SEG projects, invites ,…), New media object (OLAP cubes, SEG projects, invites ,…),
  • Improvement of the interface (filters selection, management of dependencies ,…), Improved interface (filters selection, management of dependencies ,…),
  • Executable in batch mode … Executable in batch mode …
• Management of dynamic prompts and cascading, Management of dynamic and cascading prompts
• Enhanced support roles, Improved support roles,
• Simplification of the centralization and personalization of Web applications, … Simplification and centralization of the personalization of Web applications, …

SAS Data Integration Studio 4.2 SAS Data Integration Studio 4.2

• Redesign of the graphical interface, Redesign of the GUI
  • Layout persistent processes, Layout persistent process,
  • Indicators of progress of implementation, Indicators of progress of implementation,
  • Possibility to use more than once a table in a single process, Possibility to use more than once at the same table in a single process,
  • Undo / Redo at will, Undo / Redo at will,
  • Monitoring the execution order of the process … Control the execution order of the process …

• • Control of mappings and their spread, Control mappings and their propagation
  • Debugging and support the execution step by step and partial, Debugging and support of the execution step by step and partial
  • Detailed logging of processes and objects processing, detailed process of logging and processing objects,
  • Documentation automatic … Automatic documentation, …

SAS SAS 9.2 Business Intelligence Business Intelligence 9.2

• SAS Web Report Studio 4.2 SAS Web Report Studio 4.2
  • Improved GUI (AJAX, drag-n-drop, progressive loading ,…), Improved GUI (AJAX, drag-n-drop, progressive loading ,…),
  • Support improved links between reports (Report Linking) Support improved links between reports (Report Linking)
  • Integrated Scheduling of reports (Built-In Scheduler), Integrated scheduling of reports (Built-In Scheduler)
  • Enhanced support prompts, Improved support prompts,
  • Support for improved management of roles, support for improved management of roles,
  • Management of the comments … Management reviews, …
• SAS OLAP Cube Studio 9.2/SAS OLAP Server OLAP Cube Studio SAS OLAP Server 9.2/SAS
  • Improved GUI: copy / move / rename the cubes, you can view tables and cubes, availability of an interface dedicated to MDX permissions, … GUI Improved: copy / move / rename the cubes, you can view tables and cubes, availability of an interface dedicated to MDX permissions, …
  • Possibility of creating a time dimension from a date column, Possibility of creating a time dimension from a date column,
  • Updated incremental ( “in-place” or “managed”), Updated incrementally ( “in-place” or “managed”)
  • OLAPOPERATE procedure to perform the administrative tasks in batch mode … OLAPOPERATE procedure to perform administrative tasks in batch mode …
• SAS Enterprise Guide 4.2 SAS Enterprise Guide 4.2
  • Simplification of the GUI, Simplification of the GUI
  • New tasks: List Report Wizard (procedure REPORT ),… New tasks: List Report Wizard (REPORT procedure ),…
  • Support for improved management of roles, support for improved management of roles,
  • Support for conditional execution (if-then-else ),… Support for conditional execution (if-then-else ),…
• SAS Add-In for Microsoft Office 4.2 SAS Add-In for Microsoft Office 4.2
  • Support for Microsoft Office 2007, Support for Microsoft Office 2007,
  • Possibility to open (display mode) reports SAS Web Report Studio, … Possibility to open (display mode) reports SAS Web Report Studio, …
• SAS BI Dashboard 4.2 SAS BI Dashboard 4.2
  • Availability of two new dynamic indicators (based on Adobe Fash) Availability of two new dynamic indicators (based on Adobe Fash)
  • Support alerts, support alerts
  • Ability to edit the scales of values, Ability to edit the scales of values,
  • Support for passing parameters to each Web Report Studio, Support for passing parameters to each Web Report Studio,
  • Available in the form of a portlet JSR-168, … Available in a Portlet JSR-168, …
• * SAS Table Server 9.2 (new server IOM) Table 9.2 SAS Server (IOM new server)
  • Management of security for access to relational data sources (SAS or other), Management of security for access to relational data sources (or SAS),
  • Support for transactions (delivered with a new SAS data source based on a “fork” Firebird called Vulcan), Support for transactions (delivered with a new SAS data source based on a “fork” Firebird called Vulcan)
  • Engine optimized access to relational data, … Engine optimized access to relational data, …