SAS Suite Eip / BAF Business Analytics Framework

SAS Suite Eip / BAF Business Analytics Framework -

SAS components, : http://support.sas.com/resources/papers/proceedings10/276-2010.pdf Global Design SAS SAS Components: • Metadata • Clients • Services SAS Implemented on: Data access : By a service running SAS somewhere Source: http://support.sas.com/resources/papers/proceedings10/276-2010.pdf - 2

Another Suite supplier , Same Design Many subproducts AdaytumPlanning 3.0 This was the last release before the acqusition by Cognos CognosPlanning 7.1 This was the initial rebranding by Cognos of Adaytum Cognos 10 With subproducts IBM SPSS Statistics19 Many ore subproducts (more) InpromptuCognos 7 Is out of date, see: http://www-01.ibm.com/software/data/cognos/products/series7/impromptu/ ftp://public.dhe.ibm.com/common/ssi/ecm/en/zsd03012usen/ZSD03012USEN.PDF http://en.wikipedia.org/wiki/Cognos -

Another Suite supplier , Same Design Many subproducts BI AdminTool to construct repositories consisting: Physical Layer, Business Model & Mapping Layer. Abstracted end-user Presentation Layer BI Answers ad-hoc query pivot tables, reports, and dashboards Hyperion Interactive Reporting BI Office Plug-In (more) 2001: nQuire courted by Siebel 2002: Siebel purchases nQuire 2005: Oracle purchases Siebel 2007: Hyperion Integration http://www.oracle.com/us/industries/040114.pdf http://en.wikipedia.org/wiki/Oracle_Business_Intelligence_Suite_Enterprise_Edition -

Business Intelligence - Analytics Technical view The battle: IT standards and support staffing and historical grown knowledge • Data integration • Common blocking by requiring to copy the data to own maintained systems • Security officers • Common blocking issue by the approach: when not understood not allowed. • DBMS– DBA’s • Blocking the free way (DDL) of data creation • Just knowing SQL approach • DTAP • Commonly not in place or even blocking by conflicting technologies • Scheduling, Publishing Channels & More http://en.wikipedia.org/wiki/Data_integration http://en.wikipedia.org/wiki/IT_Security http://en.wikipedia.org/wiki/Database -

Business Intelligence - Analytics Business view Struggling arround with IT as not knowing to translate their MIS requirements to BI Solutions. • CPM • Corporate Performance Management • BSC • Balance Score Card Dashboarding • Olap • Online Analytical Processing, Pivot-tables (cube) is just a part of it. • CI • Customer Intelligence • Datamining Text mining • Customer Intelligence http://en.wikipedia.org/wiki/Business_Intelligence http://nl.wikipedia.org/wiki/Business_Intelligence http://nl.wikipedia.org/wiki/OLAP -

Global Design Modern Bi with Analytics He know to access his data Access in a direct way Putting Server based access in between. Giving centralized power & control Putting Web based access in between. Giving easily more clients & no software needed at clients Someone want’s to do some advanced analytics on data. The results must go to a device. Presented in a modern way Web based access Mobile & Lap-top Web server Metadata Webdav Logging Load manager More dedicated tools on local computers (lap-top) Data processing Data processing WEB tier Client tier Data tier Server tier -

Global Design SAS eip / baf Web Report Studio Information Delivery Portal Bi Dashboard Web Olap viewer (java) XML Metadata srv Web server Logging srv Webdav srv ARM Enterprise Miner Text Miner … ABM (7 and up) … RMI / Ap srv Object Spawn Workspace srv Management Console Data Integration Studio Information Map Studio Olap Cube Studio … Op risk var … Stored proces Olap srv Other Servers Office Addin Enterprise Guide Classic usage Foundation …. Interfaces to eip baf technical support … Windows screen based Terminal Access to X11 and/or 3270 Mainframe … WEB tier Client tier Data tier Server tier -

Global Design SAS eip / baf • Web interfaces • Software at webserver instead of desktop. • User profile-settings at web-server & metadata server Web Report Studio Information Delivery Portal Bi Dashboard Web Olap viewer (java) Enterprise Miner Text Miner … ABM (7 and up) … • Java based clients • Dependent of JVM version & host behavior • User Profile-settings at desktop Management Console Data Integration Studio Information Map Studio Olap Cube Studio … Op risk var … • .Net , Com, (..) based clients • Highly dependent of Office Version and other Microsoft tools releases • User Profile-settings at desktop Office Addin Enterprise Guide Classic usage Foundation …. Interfaces to eip baf technical support … Windows screen based Terminal Access to X11 and/or 3270 Mainframe … Client tier -

Details Server tier SAS eip / baf Meta Memory cached database. 64-bit OS recommended AIX is a good Unix choice Metadata srv Logging srv Central registration point of all related servers users and data-descriptions May be combined with other server parts data / web Server tier -

Details Server tier SAS eip / baf Data Data processing services. Object Spawner is leading the WS en SP services Batch/schedule and Olap server are running dedicated Classic Spawner can be used to old fashioned machines Object Spawn Workspace srv Can be spread over many machines Stored proces Olap srv Other Servers May be combined with other server parts data / web Server tier -

Details WEB tier, SAS eip / baf Common Web access https en authentication layers possible Web-server Apache, Unix based good choice Web-sphere with Java container Web-dav, Jboss (oracle) or other contentserver Web server Webdav srv Direct communication interface to Web-service layer RMI is not using the http data transport interfaces RMI / Ap srv May be combined with other server parts data / web WEB tier -

Global Design SAS eip / baf Classic approach with no Web or metadata involved. Mostly local data / processing. Server access is posssible Office Addin Enterprise Guide Classic usage Foundation …. Interfaces to eip baf technical support … Windows screen based Terminal Access to X11 and/or 3270 Mainframe … Client tier Data tier Server tier -

SAS Suite Eip / BAF Business Analytics Framework