tag:blogger.com,1999:blog-10944002825942195202024-03-08T16:43:47.464-08:00SIEBEL REVOLUTIONFocus on defining detail solutions with emphasis on gap analysis in order to identify the differences or gaps, between what the out of the box application does by default and what client's organizations need the analytics solution to do. This enable clients to get a return on their investment by eliminating unnecessary development of custom data marts which increase the risks of silos and delay the final delivery of the application to business communityISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-1094400282594219520.post-7996245055513906152008-03-25T23:46:00.001-07:002008-03-25T23:46:18.562-07:00Oracle Business Intelligence SE One<p><span style="font-family: arial;">Small Business Computing Mon, 25 Jun 2007 9:35 AM PDTOracle today rolled out its new Business Intelligence Standard Edition One, a pre-configured BI package targeted at small to medium-sized businesses (SMBs) and workgroups.</span><br /><span style="font-family: arial;"></span><br /><a href="http://www.smallbusinesscomputing.com/news/article.php/3685266"><span style="font-family: arial;">http://www.smallbusinesscomputing.com/news/article.php/3685266</span></a></p>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-20376339713568667932008-03-25T23:45:00.001-07:002008-03-25T23:45:40.300-07:00The MODEL clause of the SELECT statement Oracle 10G<p><span style="font-family: arial;">The MODEL clause of the SELECT statement enables you to treat your relational output like a spreadsheet. The MODEL clause identifies which columns to aggregate (measures), which columns serve as unique array indexes (dimensions), and which formulas calculate the values (rules).</span><br /><span style="font-family: arial;"></span><br /><a href="http://blogs.techrepublic.com.com/datacenter/?p=130&tag=nl.e050"><span style="font-family: arial;">http://blogs.techrepublic.com.com/datacenter/?p=130&tag=nl.e050</span></a><br /><br />The MODEL clause has many options for calculating data beyond what is shown here. For more information on MODEL, see the Oracle Database Data Warehousing Guide, Chapter 22, SQL for Modeling:<br /><a href="http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14223/sqlmodel.htm"><span style="font-family: arial;">http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14223/sqlmodel.htm</span></a></p>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-72809508028211957902008-03-25T23:44:00.001-07:002008-03-25T23:44:51.372-07:00Oracle BI Applications<p><a href="http://bp2.blogger.com/_2u9Z9JoR1jk/RoJw_U-BhYI/AAAAAAAAAGE/fVRnxlec8D8/s1600-h/Siebel+Analytics+Applications+Arch.JPG"><img id="BLOGGER_PHOTO_ID_5080747562890265986" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp2.blogger.com/_2u9Z9JoR1jk/RoJw_U-BhYI/AAAAAAAAAGE/fVRnxlec8D8/s320/Siebel+Analytics+Applications+Arch.JPG" border="0" /></a><br /></p><div><span style="font-family: arial;">"Oracle’s applications have given the company a large, heterogeneous applications and infrastructure installed base. These customers need an integrated way to access, analyze and deliver information and insight from multiple business applications," the trio notes. "[T]he newly branded Business Intelligence Suite Enterprise Edition from the Siebel acquisition—which Gartner previously rated as visionary [in its magic quadrant]—has given Oracle a new opportunity to create a compelling BI platform strategy and become a significant BI platform and applications vendor in 2007 and beyond."</span><br /><span style="font-family: arial;"></span><br /><a href="http://www.tdwi.org/News/display.aspx?ID=8496"><span style="font-family: arial;">http://www.tdwi.org/News/display.aspx?ID=8496</span></a></div>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-36418733476205353142008-03-25T23:43:00.000-07:002008-03-25T23:44:09.645-07:00Business Process Management<p><span style="font-family: arial;">I just completed two tutorial for for Oracle <span class="blsp-spelling-error" id="SPELLING_ERROR_0">JDeveloper</span> which I recommend to every one who consider <span class="blsp-spelling-corrected" id="SPELLING_ERROR_1">themselves</span> a BI resource. They are:</span><br /><br /><span style="font-family: arial;">Defining Business Requirements using <span class="blsp-spelling-error" id="SPELLING_ERROR_2">UML</span> Use Case diagram in <span class="blsp-spelling-error" id="SPELLING_ERROR_3">JDeveloper</span> 10g</span><br /><a href="http://www.oracle.com/technology/obe/obe9051jdev/Modeling/UML_UseCase.htm"><span style="font-family: arial;">http://www.oracle.com/technology/obe/obe9051jdev/Modeling/UML_UseCase.htm</span></a><br /><br /><span style="font-family: arial;">Modeling Activities for E-Business Integration</span><br /><a href="http://www.oracle.com/technology/obe/obe9051jdev/ActivityModelingOBE/ActivityModelingOBE.htm"><span style="font-family: arial;">http://www.oracle.com/technology/obe/obe9051jdev/ActivityModelingOBE/ActivityModelingOBE.htm</span></a><br /><span style="font-family: arial;"></span><br /><span style="font-family: arial;">I could not complete the last one since I do not have the menu option to complete "Step 8 - Setting E-Business Integration Properties"</span><br /><span style="font-family: arial;"></span><br /><span style="font-family: arial;">Now days, everyone that works in the BI field needs to take into account <strong>BUSINESS PERFORMANCE MANAGEMENT</strong>, BPM, why? Because applications like <span class="blsp-spelling-error" id="SPELLING_ERROR_4">Siebel</span> Analytics now Oracle BI set a trend in which drilling into analytics dashboards from the <span class="blsp-spelling-error" id="SPELLING_ERROR_5">OLTP</span> application is a simple technical procedure; nevertheless, not easy to implement effectively. </span><br /><span style="font-family: arial;"></span><br /><span style="font-family: arial;">It is my believe that in order for a BI application to be <span class="blsp-spelling-corrected" id="SPELLING_ERROR_6">truly</span> pervasive. It needs to answer the basic questions who, what and when at the instance the user can pro-actively take action from the information which is being supplied through the interface between <span class="blsp-spelling-error" id="SPELLING_ERROR_7">OLTP</span> and BI applications.</span><br /><span style="font-family: arial;"></span><br /><span style="font-family: arial;">The following quote is from Jim <span class="blsp-spelling-error" id="SPELLING_ERROR_8">Ericson</span> editorial "Step By Step" <strong>BI Review June 2007.</strong></span><br /><span style="font-family: arial;">"I think a casual observer at most companies we study would find that the greatest stumbling block in operational Business Intelligence lie in those neglected, unknown or ad <span class="blsp-spelling-error" id="SPELLING_ERROR_9">hoc</span> business processes. I do catch myself going overboard on this topic, but how many times does it have to be said: Business processes make up the language that is least abstracted from the psyche of the business itself"</span><br /><span style="font-family: arial;"></span><br /><span style="font-family: arial;">Technical people needs to learn how to speak the business language in order to communicate to its pears in the Business team. I also think Business people need to be less resistance to learn new technology and procedures in order to meet its pears in the Technical team half way. Only then we would be successful implementing the next generation of application which Oracle is bringing to the market.</span></p>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-24433903217319175752008-03-25T23:42:00.000-07:002008-03-25T23:43:23.204-07:00Oracle Data Integrator Technical Brief<p><span style="font-family: arial;"><strong>Oracle Data Integrator Technical Brief</strong><br /><br /></span><span style="font-family: arial;">INTRODUCTION<br />Oracle Data Integrator is built on several components all working together around a centralized metadata repository. These components—graphical modules, runtime components, and a Web interface—in conjunction with other advanced features, make Oracle Data Integrator a lightweight, legacy-free, state-of-the-art integration platform. This technical brief describes the Oracle Data Integrator architecture in detail</span><br /><br /><span style="font-family: arial;"><a href="http://bp0.blogger.com/_2u9Z9JoR1jk/RoW4FE-BhZI/AAAAAAAAAGM/D3ywNSP3xVw/s1600-h/New+BI+Architecture+with+new+ETL.JPG"><img id="BLOGGER_PHOTO_ID_5081670151930217874" style="margin: 0px 10px 10px 0px; float: left; width: 388px; height: 235px;" alt="" src="http://bp0.blogger.com/_2u9Z9JoR1jk/RoW4FE-BhZI/AAAAAAAAAGM/D3ywNSP3xVw/s320/New+BI+Architecture+with+new+ETL.JPG" border="0" height="217" width="361" /></a>ARCHITECTURE OVERVIEW<br />The Oracle Data Integrator architecture is organized around a modular repository,<br />which is accessed in client-server mode by components—graphical modules and<br />execution agents—that are written entirely in Java. The architecture also includes a Web application, Metadata Navigator, that enables users to access information through a Web interface.</span> </p><p><br /><br /></p><span style="font-family: arial;"></span><p><span style="font-family: arial;">GRAPHICAL MODULES<br />The four graphical modules are Designer, Operator, Topology Manager, and Security Manager. These modules can be installed on any graphical platform that supports Java Virtual Machine 1.5 (J2SE), including Windows, Linux, HP-UX, Solaris, AIX, and Mac OS, among others.</span><br /><br /></p><ul><li><span style="font-family: arial;">Designer defines declarative rules for data transformation and data integrity. All project development takes place in this module; this is where database and application metadata are imported and defined. The Designer module uses metadata and rules to generate scenarios for production. This is the core module for developers and metadata administrators.<a href="http://bp0.blogger.com/_2u9Z9JoR1jk/RoW7hE-BhbI/AAAAAAAAAGc/ThPk0eIpP8E/s1600-h/ODI1.JPG"><img id="BLOGGER_PHOTO_ID_5081673931501438386" style="margin: 0px 0px 10px 10px; float: right; width: 349px; height: 180px;" alt="" src="http://bp0.blogger.com/_2u9Z9JoR1jk/RoW7hE-BhbI/AAAAAAAAAGc/ThPk0eIpP8E/s320/ODI1.JPG" border="0" height="178" width="384" /></a></span></li><br /><li><span style="font-family: arial;">Operator manages and monitors production. It is designed for production operators and shows execution logs with error counts, the number of rows processed, execution statistics, the actual code that is executed, and so on. At design time, developers can also use the Operator module for debugging purposes.</span></li><br /><li><span style="font-family: arial;">Topology Manager defines the physical and logical architecture of the infrastructure. Servers, schemas, and agents are registered in the master repository through this module, generally by the administrators of the infrastructure or project.</span></li><br /><li><span style="font-family: arial;">Security Manager manages user profiles and their access privileges. Security Manager can also assign access privileges to objects and features. This module is generally used by security administrators. </span><br /><span style="font-family: arial;"></span></li></ul><p><span style="font-family: arial;">All modules store their information in the centralized repository.</span></p><p><a href="http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/htdocs/1013_support.html#docs"><span style="font-family: arial;">http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/htdocs/1013_support.html#docs</span></a></p>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-85099087471346060292008-03-25T23:41:00.000-07:002008-03-25T23:42:13.693-07:00WhereScape RED<p><span style="font-family: arial;"><strong><span class="blsp-spelling-error" id="SPELLING_ERROR_0"><span class="blsp-spelling-error" id="SPELLING_ERROR_0">WhereScape</span></span> RED</strong> provides integrated <span class="blsp-spelling-error" id="SPELLING_ERROR_1"><span class="blsp-spelling-error" id="SPELLING_ERROR_1">DW</span></span> <span class="blsp-spelling-corrected" id="SPELLING_ERROR_2">life cycle</span> management functionality for Microsoft <span class="blsp-spelling-error" id="SPELLING_ERROR_3"><span class="blsp-spelling-error" id="SPELLING_ERROR_2">SQL</span></span> Server, Oracle and <span class="blsp-spelling-error" id="SPELLING_ERROR_4"><span class="blsp-spelling-error" id="SPELLING_ERROR_3">Teradata</span></span> deployments. The company’s go-<span class="blsp-spelling-corrected" id="SPELLING_ERROR_5">to-market</span> approach includes direct sales to clients, <span class="blsp-spelling-error" id="SPELLING_ERROR_6"><span class="blsp-spelling-error" id="SPELLING_ERROR_4">OEM</span></span> relationships with transactional application vendors, and a network of resellers and consulting partners in the geographic regions in which it operates. <span class="blsp-spelling-error" id="SPELLING_ERROR_7"><span class="blsp-spelling-error" id="SPELLING_ERROR_5">WhereScape</span></span> also provides a freely <span class="blsp-spelling-corrected" id="SPELLING_ERROR_8">down loadable</span> working version of its software, which has been an effective method for allowing prospective clients to test-drive the software prior to production deployment,<br />by building fully-functional small-scale warehouses and marts with <span class="blsp-spelling-error" id="SPELLING_ERROR_9"><span class="blsp-spelling-error" id="SPELLING_ERROR_6">WhereScape</span></span> RED<br />prior to purchase.<br /><br /><span class="blsp-spelling-error" id="SPELLING_ERROR_10"><span class="blsp-spelling-error" id="SPELLING_ERROR_7">WhereScape</span></span> RED is a <span class="blsp-spelling-corrected" id="SPELLING_ERROR_11">meta data</span> driven <span class="blsp-spelling-error" id="SPELLING_ERROR_12"><span class="blsp-spelling-error" id="SPELLING_ERROR_8">DW</span></span> <span class="blsp-spelling-corrected" id="SPELLING_ERROR_13">life cycle</span> management environment. <span class="blsp-spelling-error" id="SPELLING_ERROR_14"><span class="blsp-spelling-error" id="SPELLING_ERROR_9">WhereScape</span></span> RED includes 5 integrated components that support all stages of the <span class="blsp-spelling-error" id="SPELLING_ERROR_15"><span class="blsp-spelling-error" id="SPELLING_ERROR_10">DW</span></span> <span class="blsp-spelling-corrected" id="SPELLING_ERROR_16">life cycle</span> process:<br /><br /></span><img id="BLOGGER_PHOTO_ID_5081680554341008834" style="margin: 0px auto 10px; display: block; width: 321px; height: 202px; text-align: center;" alt="" src="http://bp2.blogger.com/_2u9Z9JoR1jk/RoXBik-BhcI/AAAAAAAAAGk/3aPQHmo-qd8/s320/RED1.JPG" border="0" height="299" width="411" /><br /></p><ul><li><span style="font-family: arial;">Source data extraction and loading facilities (native database connectivity, <span class="blsp-spelling-error" id="SPELLING_ERROR_17"><span class="blsp-spelling-error" id="SPELLING_ERROR_11">ODBC</span></span>, XML, flat file)</span></li><br /><li><span style="font-family: arial;"><span class="blsp-spelling-error" id="SPELLING_ERROR_18"><span class="blsp-spelling-error" id="SPELLING_ERROR_12">WhereScape</span></span> RED Applications: <strong>Administrator</strong> is a developer’s interface for creating repositories within the data warehouse and maintaining schedulers. <strong>Integrated development Environment (<span class="blsp-spelling-error" id="SPELLING_ERROR_19"><span class="blsp-spelling-error" id="SPELLING_ERROR_13">IDE</span></span>)</strong> is a desktop interface for designing and managing the data warehouse. <strong>Scheduler</strong> is an optional interface that is used primarily by administrators for job status information.</span></li><br /><li><span style="font-family: arial;">Repository housed within the target <span class="blsp-spelling-error" id="SPELLING_ERROR_20"><span class="blsp-spelling-error" id="SPELLING_ERROR_14">DW</span></span>, the RED Repository is a set of database tables that are installed in each target <span class="blsp-spelling-error" id="SPELLING_ERROR_21"><span class="blsp-spelling-error" id="SPELLING_ERROR_15">DW</span></span> environment. <span class="blsp-spelling-corrected" id="SPELLING_ERROR_22">Meta data</span> tables can be accessed by business intelligence tools for query, reporting and analysis purposes. The data warehouse objects created by <span class="blsp-spelling-error" id="SPELLING_ERROR_23"><span class="blsp-spelling-error" id="SPELLING_ERROR_16">WhereScape</span></span> RED are standard database objects such as tables, views, scripts, procedures and indexes. They are always specific to the details of the target database’s <span class="blsp-spelling-error" id="SPELLING_ERROR_24"><span class="blsp-spelling-error" id="SPELLING_ERROR_17">SQL</span></span> or data manipulation dialect: scripts in <span class="blsp-spelling-error" id="SPELLING_ERROR_25"><span class="blsp-spelling-error" id="SPELLING_ERROR_18">Teradata</span></span> can be <span class="blsp-spelling-corrected" id="SPELLING_ERROR_26">Multi Load</span> or <span class="blsp-spelling-corrected" id="SPELLING_ERROR_27">Fast Load</span>,<br />procedures are PL/<span class="blsp-spelling-error" id="SPELLING_ERROR_28"><span class="blsp-spelling-error" id="SPELLING_ERROR_19">SQL</span></span> in Oracle and Transact <span class="blsp-spelling-error" id="SPELLING_ERROR_29"><span class="blsp-spelling-error" id="SPELLING_ERROR_20">SQL</span></span> in <span class="blsp-spelling-error" id="SPELLING_ERROR_30"><span class="blsp-spelling-error" id="SPELLING_ERROR_21">SQL</span></span> Server. RED uses the database as the data transformation engine and also stores all <span class="blsp-spelling-corrected" id="SPELLING_ERROR_31">meta data</span> about the objects created in the target <span class="blsp-spelling-error" id="SPELLING_ERROR_32"><span class="blsp-spelling-error" id="SPELLING_ERROR_22">DW</span></span> and about the dependent objects within the repository.</span></li><br /><li><span style="font-family: arial;">Scheduler polls <span class="blsp-spelling-corrected" id="SPELLING_ERROR_33">meta data</span> to identify tasks that can be run. It also manages the <span class="blsp-spelling-corrected" id="SPELLING_ERROR_34">work flow</span> of dependencies that may exist among jobs or groups of tasks. Tasks can run in the target database or on a separate scheduler platform and initiate loads or procedures specific to databases being used. The scheduler supports multi-platform scheduling and can be called from an existing enterprise scheduler.</span></li><br /><li><span style="font-family: arial;">Dependent Objects located outside the RED repository, dependent objects include <span class="blsp-spelling-error" id="SPELLING_ERROR_35"><span class="blsp-spelling-error" id="SPELLING_ERROR_23">OLAP</span></span> cubes or exports for other downstream systems whose <span class="blsp-spelling-corrected" id="SPELLING_ERROR_36">meta data</span> is stored within the RED repository. The scheduler also manages these objects.</span></li></ul><p><span style="font-family: arial;">Addressing the <span class="blsp-spelling-error" id="SPELLING_ERROR_37"><span class="blsp-spelling-error" id="SPELLING_ERROR_24">DW</span></span> <span class="blsp-spelling-corrected" id="SPELLING_ERROR_38">Life cycle</span> Management Process with <span class="blsp-spelling-error" id="SPELLING_ERROR_39"><span class="blsp-spelling-error" id="SPELLING_ERROR_25">WhereScape</span></span> RED</span></p><img id="BLOGGER_PHOTO_ID_5081681082621986258" style="margin: 0px auto 10px; display: block; width: 317px; height: 144px; text-align: center;" alt="" src="http://bp1.blogger.com/_2u9Z9JoR1jk/RoXCBU-BhdI/AAAAAAAAAGs/1uYgzz6BJYQ/s320/RED2.JPG" border="0" height="181" width="427" /><br /><p><span style="font-family: arial;"><span class="blsp-spelling-error" id="SPELLING_ERROR_40"><span class="blsp-spelling-error" id="SPELLING_ERROR_26">WhereScape</span></span> RED provides support for all steps of a <span class="blsp-spelling-error" id="SPELLING_ERROR_41"><span class="blsp-spelling-error" id="SPELLING_ERROR_27">DW</span></span> <span class="blsp-spelling-corrected" id="SPELLING_ERROR_42">life cycle</span>. It supports both the developers and business users in their collaborative efforts from the definition stage to deployment stage through a series of iterative steps and feedback loops.</span></p><p><span style="font-family: arial;">Some of the key strengths of the <span class="blsp-spelling-error" id="SPELLING_ERROR_43"><span class="blsp-spelling-error" id="SPELLING_ERROR_28">WhereScape</span></span> RED software include:</span></p><p><span style="font-family: arial;"><strong>Rapid Prototyping</strong><br /><span class="blsp-spelling-error" id="SPELLING_ERROR_44"><span class="blsp-spelling-error" id="SPELLING_ERROR_29">WhereScape</span></span> itself describes its software as enabling developers to "fail fast and fail early." With <span class="blsp-spelling-error" id="SPELLING_ERROR_45"><span class="blsp-spelling-error" id="SPELLING_ERROR_30">WhereScape</span></span> RED, developers can create prototypes of candidate production schema, populate it immediately with source data (familiar to business users), and adjust the schema in response to business users’ feedback as needed during joint design-prototype-iterate sessions . all within days and in some cases hours. This practices allows business users to see, in real time, the translation of their requests into working data warehouses and/or data marts, and helps BI/<span class="blsp-spelling-error" id="SPELLING_ERROR_46"><span class="blsp-spelling-error" id="SPELLING_ERROR_31">DW</span></span><br />practitioners make appropriate accommodations while they themselves get comfortable, incrementally, with those accommodations.</span></p><p><span style="font-family: arial;"><strong>Self-documentation</strong><br />Self-documentation was highlighted as one of the key features of <span class="blsp-spelling-error" id="SPELLING_ERROR_47"><span class="blsp-spelling-error" id="SPELLING_ERROR_32">WhereScape</span></span> RED during interviews with <span class="blsp-spelling-error" id="SPELLING_ERROR_48"><span class="blsp-spelling-error" id="SPELLING_ERROR_33">WhereScape</span></span> customers. Within RED, <span class="blsp-spelling-corrected" id="SPELLING_ERROR_49">meta data</span> is created automatically while an architect interacts with the RED desktop interface during the various stages of the data warehousing process. <span class="blsp-spelling-corrected" id="SPELLING_ERROR_50">Meta data</span> and other documentation can also be edited or added manually on an as needed basis.</span></p><p><span style="font-family: arial;"><strong>Single Source for <span class="blsp-spelling-error" id="SPELLING_ERROR_51"><span class="blsp-spelling-error" id="SPELLING_ERROR_34">Metadata</span></span></strong><br /><span class="blsp-spelling-error" id="SPELLING_ERROR_52"><span class="blsp-spelling-error" id="SPELLING_ERROR_35">WhereScape</span></span> RED stores <span class="blsp-spelling-corrected" id="SPELLING_ERROR_53">meta data</span> not only about source systems and the data warehouse objects, but also about the external dependent objects such as <span class="blsp-spelling-error" id="SPELLING_ERROR_54"><span class="blsp-spelling-error" id="SPELLING_ERROR_36">OLAP</span></span> cubes as well as <span class="blsp-spelling-error" id="SPELLING_ERROR_55"><span class="blsp-spelling-error" id="SPELLING_ERROR_37">ETL</span></span> routines. Having a single source for all <span class="blsp-spelling-corrected" id="SPELLING_ERROR_56">meta data</span> related to the various steps in <span class="blsp-spelling-error" id="SPELLING_ERROR_57"><span class="blsp-spelling-error" id="SPELLING_ERROR_38">DW</span></span> <span class="blsp-spelling-error" id="SPELLING_ERROR_58"><span class="blsp-spelling-corrected" id="SPELLING_ERROR_39">life cycle</span></span> management enables administrators, architects and developers to manage and access this <span class="blsp-spelling-corrected" id="SPELLING_ERROR_59">meta data</span> more efficiently than if it was distributed in individual repositories of the component tools.</span></p><p><span style="font-family: arial;"><strong>Retrofitting<br /></strong>Users of <span class="blsp-spelling-error" id="SPELLING_ERROR_60"><span class="blsp-spelling-error" id="SPELLING_ERROR_40">WhereScape</span></span> RED can also reuse existing tables designed with third party <span class="blsp-spelling-error" id="SPELLING_ERROR_61"><span class="blsp-spelling-error" id="SPELLING_ERROR_41">DW</span></span> modeling tools. In this case the software automatically recognizes that RED was not used as the design tool and retrofits existing <span class="blsp-spelling-error" id="SPELLING_ERROR_62"><span class="blsp-spelling-error" id="SPELLING_ERROR_42">DW</span></span> tables into the RED Repository. This process has been identified as a considerable time saver at organizations, that for various reasons, may chose to work with another modeling tool. This is an example of <span class="blsp-spelling-error" id="SPELLING_ERROR_63"><span class="blsp-spelling-error" id="SPELLING_ERROR_43">WhereScape</span></span> ensuring its product’s compatibility with existing data warehousing tools and environments.</span></p><p><span style="font-family: Arial;">I was given a demo of this product by <span class="blsp-spelling-error" id="SPELLING_ERROR_64"><span class="blsp-spelling-error" id="SPELLING_ERROR_44">WhereScape</span></span> which I called then a framework to build Data Warehouse Application based on industry best practices. I was literally blown away by it. Kind of the same way when I saw <span class="blsp-spelling-error" id="SPELLING_ERROR_65"><span class="blsp-spelling-error" id="SPELLING_ERROR_45">Siebel</span></span> Analytics <span class="blsp-spelling-error" id="SPELLING_ERROR_66"><span class="blsp-spelling-error" id="SPELLING_ERROR_46">SRMW</span></span> model for the first time. The only way I will work on a stand alone implementation of Oracle BI <span class="blsp-spelling-error" id="SPELLING_ERROR_67"><span class="blsp-spelling-error" id="SPELLING_ERROR_47">EE</span></span> would be if client agrees on purchasing this amazing product. Otherwise, they better buy Oracle BI Application since I do not build Data Warehouse from the ground up. Why reinvent the wheel and add <span class="blsp-spelling-corrected" id="SPELLING_ERROR_68">unnecessary</span> risk to project which success rate still below 50% when there are product such as this one and Oracle BI Applications in the market?</span></p><p><span style="font-family: Arial;">I recommend everyone to go for a free demo of this amazing product.</span></p><p><a href="http://www.wherescape.com/">http://www.wherescape.com/</a></p>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-73427453093060570122008-03-25T23:40:00.000-07:002008-03-25T23:41:36.722-07:00Team CollaborationI am a strong believer on the following quote:<br /><br />"When teams work together with a common goal and a passion for success, their projects succeed. When the opposite occurs, everyone loses, including the team, the employer, and their customers.<br /><br />In the course of my normal consulting assignments, I’m often told that there’s something wrong with the data or with the process models being prepared by the team architects, but what I often find is that there is a significant disconnect between what the architects are doing and what the rest of the team expects them to do.<br /><br />In this paper, I will look at some of the problems that data and process architects face in working with other IT roles and seven easy and inexpensive steps they can take to ensure a collaborative team environment."ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-48873379246792539872008-03-25T23:39:00.000-07:002008-03-25T23:40:28.798-07:00Labs Tip Dont Reinvent the Wheel<p><a href="http://bp2.blogger.com/_2u9Z9JoR1jk/Rpj61rjmslI/AAAAAAAAAG0/qqZBcxo3eig/s1600-h/Fact+-+Quote+Item.JPG"><img id="BLOGGER_PHOTO_ID_5087091579247047250" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp2.blogger.com/_2u9Z9JoR1jk/Rpj61rjmslI/AAAAAAAAAG0/qqZBcxo3eig/s320/Fact+-+Quote+Item.JPG" border="0" /></a><br /></p><div>It is amazing how much similarity I found between the subject of this article and common mistake made by most Siebel Analytics professionals in the field. My opinion has always been to improve upon existing ideas or solutions. It is a waist of time and resource to reinvent the wheel.<br /><br />I have clients calling with performance problems of ETL recurring daily jobs that takes more than 34 hours to complete. Just recently, I had a talk with a a fortune 500 with query performance of its application when the OLAP database is not more than 10 GB in size. Whenever I ask if they have built custom stars instead of trying to re utilize the one that come out of the box. I get an excuse that I have proven so many time to be wrong "Our needs were to specific or our OLTP is heavily customize"<br /><br />People, you are dealing with a new paradigm now. It is call service oriented architecture (SOA) Stop looking for programmers to implement these applications. They are all moving to the offshore centers so they can write the reusable code of these wonderful applications. What you need is the collaboration of your business and IT teams in your BI efforts. You will also need architects who understand the new technology and are able to interact with your team.<br /><br />Siebel Analytics Applications answer the who, what, where and when. Who are customers, vendors, employees, partners, etc. What are tangible and intangible products. Where is usually a refer to a geography dimensions or markets where you conduct business. When is your time dimension. It is unreal to believe what this client just told me yesterday "We had to build custom dimension because they were missing from the OOB model" I still thinking what does this client mean by that. I bet you own or have owned a product item from this client. That means that you are or were a customers of it. So why they did not use the W_PRODUCT_D, W_CONTACT_D and W_TIME_D is beyond me. Just take a look on how rich this model is by the picture of the star schema attached to this entry. </div><div> </div>Come on people, be serious, the model provides more than what any company needs. I believe the root of this problem is the lack of understand to dig into the intellectual property that comes with these applications.ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-36582030963022886962008-03-25T23:38:00.000-07:002008-03-25T23:39:23.487-07:00How much is a Siebel Analytics Consultant worth now days?They are a lot of people out there who claim to be a <span class="blsp-spelling-error" id="SPELLING_ERROR_0">Siebel</span> Analytics consultant. Most of them do not have the experience or knowledge they claim in this technology. In order situations I found consulting firms claiming to specialize in it but in reality do not have the <span class="blsp-spelling-corrected" id="SPELLING_ERROR_1">personnel</span> nor the skills to handle the implementation.<br /><br />These people and/or organizations get the contracts because the <span class="blsp-spelling-corrected" id="SPELLING_ERROR_2">underbid</span> us. Then again, having the <span class="blsp-spelling-corrected" id="SPELLING_ERROR_3">knowledge</span> does not guarantee success. Chip Camden in his blog entry "<a title="Permanent Link: Getting beyond the ‘bull’ perception" href="http://blogs.techrepublic.com.com/project-management/?p=128" rel="bookmark">Getting beyond the ‘bull’ perception</a>" <a href="http://blogs.techrepublic.com.com/project-management/?p=128">http://blogs.techrepublic.com.com/project-management/?p=128</a><br />says it all.<br /><br />Clients most often go for the lower bid. It is understandable from the point of view of minimizing cost and bring profits up. Then again it is true what they say "you get what you paid for it".ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com1tag:blogger.com,1999:blog-1094400282594219520.post-25101525851230525532008-03-25T23:37:00.000-07:002008-03-25T23:38:15.118-07:00ETL tool from Talend a member of Open Solutions Alliance<p><span style="font-family: arial;"><span class="blsp-spelling-error" id="SPELLING_ERROR_0">Talend</span> Open Studio <a href="http://www.talend.com/products-data-integration/talend-open-studio.php">http://www.talend.com/products-data-integration/talend-open-studio.php</a> provides advanced capabilities that dramatically improve the productivity of data integration job design; and proven scalability to ensure optimal execution.<br /><span class="blsp-spelling-error" id="SPELLING_ERROR_1"></span></span><br /><span style="font-family: arial;"><span class="blsp-spelling-error">Talend</span> Open Studio key benefits include:<br /></span><a class="linkSelected" id="BusinessLink2" title="Business modeling Graphical Development" onclick="show('Business');" href="http://www.talend.com/products-data-integration/talend-open-studio.php#feature"><span style="font-family: arial;">Business modeling</span></a><br /><a class="" id="GraphicalLink2" onclick="show('Graphical');" href="http://www.talend.com/products-data-integration/talend-open-studio.php#feature"><span style="font-family: arial;">Graphical development</span></a><br /><a class="" id="MetadataLink2" onclick="show('Metadata');" href="http://www.talend.com/products-data-integration/talend-open-studio.php#feature"><span style="font-family: arial;"><span class="blsp-spelling-error" id="SPELLING_ERROR_2">Metadata</span>-driven design</span></a><br /><a class="" id="RealTimeLink2" onclick="show('RealTime');" href="http://www.talend.com/products-data-integration/talend-open-studio.php#feature"><span style="font-family: arial;">Real-time debugging</span></a><br /><a class="" id="RobustLink2" onclick="show('Robust');" href="http://www.talend.com/products-data-integration/talend-open-studio.php#feature"><span style="font-family: arial;">Robust execution</span></a><br /><br />This is an Open Source <span class="blsp-spelling-error" id="SPELLING_ERROR_3">ETL</span> solution from <span class="blsp-spelling-error" id="SPELLING_ERROR_4">Talend</span>, a member of the Open Solution Alliance.<br /><br />The architecture is similar to Oracle Data Integrator and <span class="blsp-spelling-error" id="SPELLING_ERROR_5">WhereScape</span> Red. I recommend all three products to be included in an <span class="blsp-spelling-error" id="SPELLING_ERROR_6">ETL</span> solution selection task when it is required.<br /><br /><span class="blsp-spelling-error" id="SPELLING_ERROR_7">Informatica</span> is the tool of choice for an implementation of <span class="blsp-spelling-error" id="SPELLING_ERROR_8">Siebel</span> Analytics Application/Oracle BI Application. It is the leader in the market and it is a great product reason why <span class="blsp-spelling-error" id="SPELLING_ERROR_9">Siebel</span> <span class="blsp-spelling-corrected" id="SPELLING_ERROR_10">chosen</span> to partner with it. Nevertheless, these new products <span class="blsp-spelling-error" id="SPELLING_ERROR_11">specificall</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_12">WhereScape</span> Red, are offering embedded best practices for <span class="blsp-spelling-corrected" id="SPELLING_ERROR_13">multidimensional</span> modeling and data warehouse design, part of the new paradigm of Service Oriented Architecture <span class="blsp-spelling-corrected" id="SPELLING_ERROR_14">technology</span> of which <span class="blsp-spelling-error" id="SPELLING_ERROR_15">Siebel</span> Analytics Application is a good example of it.<br /><br />Links:<br /><span class="blsp-spelling-error" id="SPELLING_ERROR_16">WhereScape</span> RED <a title="http://www.wherescape.com/" href="http://www.wherescape.com/">http://www.wherescape.com/</a><br />Oracle Data Integrator: <a title="http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/htdocs/1013_support.html#docs" href="http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/htdocs/1013_support.html#docs">http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/htdocs/1013_support.html#docs</a><br /><span class="blsp-spelling-error" id="SPELLING_ERROR_17">Talend</span> Open Studio: <a href="http://www.talend.com/">http://www.talend.com/</a></p>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-12530655377069429282008-03-25T23:36:00.000-07:002008-03-25T23:37:27.631-07:00Oracle Real-Time Decisions<span style="font-family: arial;">Overview</span><br /><br /><span style="font-family: arial;">The Oracle Real-Time Decisions (Oracle RTD) platform allows you to develop enterprise software solutions that analyze business process behavior and make recommendations in real-time, allowing you to identify and address problems and opportunities as soon as they emerge. </span><br /><span style="font-family: arial;"></span><br /><span style="font-family: arial;">Inline Service refers to the configured application that is deployed using the components in the RTD environment. Oracle RTD consists of five components: Decision Studio, Real-Time Decision Server, Decision Center, Administration (JMX), and Load Generator. Inline Services are configured and deployed using Decision Studio and analyzed and updated using Decision Center. Inline Services run on Real-Time Decision Server. An Inline Service can gather data and analyze characteristics of enterprise business processes on a real-time and continuous basis. It also leverages that data and analysis to provide decision-making capability and feedback to key business processes.</span><br /><span style="font-family: arial;"></span><br /><a name="r"></a><span style="font-family: arial;">Related Information<br />To learn more about Oracle RTD you can refer to:</span><br /><a href="http://www.oracle.com/technology/products/bi/rtd.html"><span style="font-family: arial;">http://www.oracle.com/technology/products/bi/rtd.html</span></a><br /><a href="http://www.oracle.com/technology/obe/index.html"><span style="font-family: arial;">http://www.oracle.com/technology/obe/index.html</span></a>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-54205431410620891812008-03-25T23:35:00.000-07:002008-03-25T23:36:17.646-07:00Enterprise Performance Management System<div><a href="http://bp0.blogger.com/_2u9Z9JoR1jk/RrJDMScj1vI/AAAAAAAAAG8/m33j4-blb9c/s1600-h/Enterprise+Performance+Management+System.JPG"><img id="BLOGGER_PHOTO_ID_5094208006898570994" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp0.blogger.com/_2u9Z9JoR1jk/RrJDMScj1vI/AAAAAAAAAG8/m33j4-blb9c/s320/Enterprise+Performance+Management+System.JPG" border="0" /></a><br /><br /><br /><br /><div><span style="font-family: arial;">For those of you that missed today web cast from Oracle, here is the link </span><a title="http://www.oracle.com/pls/ebn/live_viewer.main?p_shows_id=" href="http://www.oracle.com/pls/ebn/live_viewer.main?p_shows_id=5782857"><span style="font-family: arial;">http://www.oracle.com/pls/ebn/live_viewer.main?p_shows_id=5782857</span></a> </div><br /><br /><div><br /></div><span style="font-family: arial;"><img id="BLOGGER_PHOTO_ID_5094208243121772290" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp3.blogger.com/_2u9Z9JoR1jk/RrJDaCcj1wI/AAAAAAAAAHE/o-1mxHUH8Us/s320/OBIEE+Plus.JPG" border="0" /><br />The future is called Oracle BI Suite Enterprise Edition Plus. The past was Siebel Analytics and Hyperion. In order for Siebel Analytics or Hyperion consultants to claim the title of Oracle BI Suite Enterprise Edition Plus consultant. We need to transfer knowledge and increase cooperation between the two groups. Break all barriers and seek a common goal which is to provide value to our customers.</span></div><br /><div><span style="font-family: arial;"><br /><img id="BLOGGER_PHOTO_ID_5094208453575169810" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp0.blogger.com/_2u9Z9JoR1jk/RrJDmScj1xI/AAAAAAAAAHM/I6K0EFcRjmI/s320/OBIEE+Plus+1.JPG" border="0" /> <img id="BLOGGER_PHOTO_ID_5094208732748044066" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp1.blogger.com/_2u9Z9JoR1jk/RrJD2icj1yI/AAAAAAAAAHU/9RCpJlQ1hv4/s320/OBIEE+Plus+2.JPG" border="0" /><br />There is not a better example than the one Oracle and Hyperion are showing us in this web cast. No other product in the world come close to what this suite of tool is capable to deliver. Finally, in terms of BI applications, there is nothing out there able to compete against Oracle BI applications and when the integration with BMP applications from Hyperion is completed; it would take a long time and resources for the Germany to developed something similar organically. This is why Oracle acquired Hyperion, to position itself to delivery an<br />Enterprise Performance Management System</span></div>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-41469941912321945282008-03-25T23:33:00.000-07:002008-03-25T23:34:40.384-07:00Oracle Business Intelligence (BI)<div class="post-body entry-content"> <p><a href="http://bp0.blogger.com/_2u9Z9JoR1jk/Rriucycj10I/AAAAAAAAAHk/46ft9rf--qA/s1600-h/epm-system-graphic%5B1%5D.jpg"><img id="BLOGGER_PHOTO_ID_5096014787970848578" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp0.blogger.com/_2u9Z9JoR1jk/Rriucycj10I/AAAAAAAAAHk/46ft9rf--qA/s320/epm-system-graphic%5B1%5D.jpg" border="0" /></a><br /></p><div>Oracle Business Intelligence (BI) is a portfolio of technology and applications that provides the industry's first integrated, end-to-end Enterprise Performance Management System, including category-leading financial performance management applications, operational BI applications, BI foundation and tools, and data warehousing.</div><br /><br /><div><br /><a href="http://www.oracle.com/appserver/business-intelligence/bi-applications.html">OPERATIONAL BUSINESS INTELLIGENCE APPLICATIONS</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/financial-analytics.html">Oracle Financial Analytics</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/hr-analytics.html">Oracle HR Analytics</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/order-management-fulfillment-analytics.html">Oracle Order Management and Fulfillment Analytics</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/supply-chain-analytics.html">Oracle Supply Chain Analytics</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/sales-analytics.html">Oracle Sales Analytics</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/service-analytics.html">Oracle Service Analytics</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/contact-center-analytics.html">Oracle Contact Center Analytics</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/marketing-analytics.html">Oracle Marketing Analytics</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/usage-accelerator-analytics.html">Oracle Usage Accelerator Analytics for CRM</a></div><br /><br /><div><a href="http://www.oracle.com/appserver/business-intelligence/hyperion-financial-performance-management/hyperion-financial-performance-management.html">FINANCIAL PERFORMANCE MANAGEMENT APPLICATIONS</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/hyperion-financial-performance-management/hyperion-financial-management-system9.html">Hyperion Financial Management—System 9</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/hyperion-financial-performance-management/hyperion-planning-system9.html">Hyperion Planning—System 9</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/hyperion-financial-performance-management/hyperion-performance-scorecard-system9.html">Hyperion Performance Scorecard—System 9</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/hyperion-financial-performance-management/hyperion-strategic-finance.html">Hyperion Strategic Finance</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/hyperion-financial-performance-management/hyperion-capital-expense-planning.html">Hyperion Capital Expense Planning</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/hyperion-financial-performance-management/hyperion-workforce-planning.html">Hyperion Workforce Planning</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/hyperion-financial-performance-management/hyperion-financial-data-quality-management.html">Hyperion Financial Data Quality Management</a> </div><br /><br /><div><a href="http://www.oracle.com/appserver/business-intelligence/index.html">BI FOUNDATION AND TOOLS</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/enterprise-edition.html">Oracle BI Suite Enterprise Edition Plus</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/standard-edition-one.html">Oracle BI Standard Edition One</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/standard-edition.html">Oracle BI Standard Edition</a><br /><a href="http://www.oracle.com/appserver/business-intelligence/docs/hyperion-essbase-datasheet.pdf" target="_blank">Hyperion Essbase</a> </div><br /><br /><div><a href="http://www.oracle.com/appserver/business-intelligence/dw_home.html">DATA WAREHOUSING</a><br /><a href="http://www.oracle.com/solutions/business_intelligence/warehouse-builder.html">Oracle Warehouse Builder</a><br /><a href="http://www.oracle.com/solutions/business_intelligence/partitioning.html">Oracle Partitioning</a><br /><a href="http://www.oracle.com/solutions/business_intelligence/olap.html">Oracle OLAP</a><br /><a href="http://www.oracle.com/solutions/business_intelligence/data-mining.html">Oracle Data Mining</a> </div><br /><br /><div>RELATED PRODUCTS<br /><a href="http://www.oracle.com/products/middleware/oracle-data-integrator.html">Oracle Data Integrator</a><br /><a href="http://www.oracle.com/applications/crm/siebel/business-analytics/real-time-decisions.html">Oracle Real-Time Decisions</a><br /><a href="http://www.oracle.com/appserver/business-activity-monitoring.html">Oracle Business Activity Monitoring</a><br /><a href="http://www.oracle.com/technologies/bpm/index.html">Oracle Business Process Management</a><br /><a href="http://www.oracle.com/database/secure-enterprise-search.html">Oracle Secure Enterprise Search</a> </div> </div> <div class="post-footer"> <div class="post-footer-line post-footer-line-1"> <span class="post-author vcard"> Posted by <span class="fn">Romulo Rios</span> </span> <span class="post-timestamp"> at <a class="timestamp-link" href="http://analyticsdoneright.blogspot.com/2007/08/oracle-business-intelligence-bi.html" rel="bookmark" title="permanent link"><abbr class="published" title="2007-08-07T13:34:00-04:00">1:34 PM</abbr></a> </span> <span class="post-comment-link"> <a class="comment-link" href="comment.g?blogID=6496633459017051154&postID=169135074623354916" onclick="">0 comments</a> </span> <span class="post-backlinks post-comment-link"> </span> <span class="post-icons"> <span class="item-action"> <a href="email-post.g?blogID=6496633459017051154&postID=169135074623354916" title="Email Post"> <img alt="" class="icon-action" src="img/icon18_email.gif" /> </a> </span> <span class="item-control blog-admin pid-846897199"> <a href="post-edit.g?blogID=6496633459017051154&postID=169135074623354916" title="Edit Post"> <img alt="" class="icon-action" src="img/icon18_edit_allbkg.gif" /> </a> </span> </span> </div> <div class="post-footer-line post-footer-line-2"> <span class="post-labels"> Labels: <a href="http://analyticsdoneright.blogspot.com/search/label/Oracle%20Bi%20Solutions%20and%20Products" rel="tag">Oracle Bi Solutions and Products</a> </span> </div> </div> <a name="3625461429094260541"></a> <h3 class="post-title entry-title"> <a href="http://analyticsdoneright.blogspot.com/2007/08/oracle-business-intelligence.html">Oracle Business Intelligence Suite—Enterprise Edition Plus</a> </h3> <p><a href="http://bp2.blogger.com/_2u9Z9JoR1jk/Rrio-Scj1zI/AAAAAAAAAHc/1pYKWgQuDTg/s1600-h/OBIEE+Plus+1.JPG"><img id="BLOGGER_PHOTO_ID_5096008766426699570" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp2.blogger.com/_2u9Z9JoR1jk/Rrio-Scj1zI/AAAAAAAAAHc/1pYKWgQuDTg/s320/OBIEE+Plus+1.JPG" border="0" /></a><br /></p><div>Oracle Business Intelligence Suite Enterprise Edition Plus (<span class="blsp-spelling-error" id="SPELLING_ERROR_0">EE</span>) is a comprehensive BI platform that provides the best foundation for building enterprise BI solutions. Featuring a unified, highly scalable, modern architecture, BI <span class="blsp-spelling-error" id="SPELLING_ERROR_1">EE</span> provides intelligence and analytics from data spanning enterprise sources and applications, empowering the largest communities with complete and relevant insight. It includes a full range of easy-to-use and intuitive end user tools such as:</div><br /><br /><div>Oracle Business Intelligence Suite Enterprise Edition Components:</div><br /><ul><br /><li>Oracle Interactive Dashboards</li><br /><li>Oracle Answers</li><br /><li>Oracle BI Reporting and Publishing </li><br /><li>Oracle Disconnected Analytics</li><br /><li>Oracle Office Plug-in</li><br /><li>Oracle BI Server</li></ul><br /><p><a href="http://www.oracle.com/appserver/business-intelligence/docs/OracleBIEEDataSheet.pdf">http://www.oracle.com/appserver/business-intelligence/docs/OracleBIEEDataSheet.pdf</a></p><br /><p>Hyperion <span class="blsp-spelling-error" id="SPELLING_ERROR_2">Essbase</span>:</p><br /><ul><br /><li>Hyperion Interactive Reporting - System 9</li><br /><li>Hyperion <span class="blsp-spelling-error" id="SPELLING_ERROR_3">SQR</span> Production Reporting - System 9</li><br /><li>Hyperion Financial Reporting - System 9</li><br /><li>Hyperion Web Analysis - System 9 </li></ul><br /><p><a href="http://www.oracle.com/appserver/business-intelligence/docs/hyperion-essbase-datasheet.pdf">http://www.oracle.com/appserver/business-intelligence/docs/hyperion-essbase-datasheet.pdf</a></p>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-52467514507974885652008-03-25T23:31:00.000-07:002008-03-25T23:32:53.938-07:00Oracle's Vision for an EMP system<p><a href="http://bp0.blogger.com/_2u9Z9JoR1jk/Rri9bycj12I/AAAAAAAAAH0/DuvTjn6I2yI/s1600-h/epm-system-graphic%5B3%5D.jpg"><img id="BLOGGER_PHOTO_ID_5096031263465396066" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp0.blogger.com/_2u9Z9JoR1jk/Rri9bycj12I/AAAAAAAAAH0/DuvTjn6I2yI/s320/epm-system-graphic%5B3%5D.jpg" border="0" /></a><br /></p><div><div>This is a demo of Oracle's vision for Industry First Enterprise Performance Management <span class="blsp-spelling-corrected" id="SPELLING_ERROR_0">System</span>, from the <span class="blsp-spelling-error" id="SPELLING_ERROR_1">EMP</span> view of the world.</div><br /><div><a href="http://www.oracle.com/pls/ebn/swf_viewer.load?p_shows_id=5801530&p_referred=undefined&p_width=800&p_height=600">http://www.oracle.com/pls/ebn/swf_viewer.load?p_shows_id=5801530&p_referred=undefined&p_width=800&p_height=600</a></div></div>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-88175634269787776202008-03-25T23:30:00.000-07:002008-03-25T23:31:27.458-07:00Operational Analytics<p><a href="http://bp0.blogger.com/_2u9Z9JoR1jk/RrjKgycj13I/AAAAAAAAAH8/EHwQJhHa8SM/s1600-h/epm-system-graphic%5B3%5D.jpg"><img id="BLOGGER_PHOTO_ID_5096045643015903090" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp0.blogger.com/_2u9Z9JoR1jk/RrjKgycj13I/AAAAAAAAAH8/EHwQJhHa8SM/s320/epm-system-graphic%5B3%5D.jpg" border="0" /></a> </p><div>In Fall of 2003, <span class="blsp-spelling-error" id="SPELLING_ERROR_0"><span class="blsp-spelling-error" id="SPELLING_ERROR_0">Siebel</span></span> Systems conducted a test in which user of <span class="blsp-spelling-error" id="SPELLING_ERROR_1"><span class="blsp-spelling-error" id="SPELLING_ERROR_1">Siebel</span></span> <span class="blsp-spelling-error" id="SPELLING_ERROR_2"><span class="blsp-spelling-error" id="SPELLING_ERROR_2">eBusiness</span></span> Applications could drill down to an Analytics Dashboard. The test was a success. The ability to drill down from an operational system to an analytics application was first <span class="blsp-spelling-corrected" id="SPELLING_ERROR_3">announced</span> with release of <span class="blsp-spelling-error" id="SPELLING_ERROR_4"><span class="blsp-spelling-error" id="SPELLING_ERROR_3">Siebel</span></span> Analytics application 7.7.</div><div> </div><div>By mid 2004, the sells of <span class="blsp-spelling-error" id="SPELLING_ERROR_5"><span class="blsp-spelling-error" id="SPELLING_ERROR_4">Siebel</span></span> Analytics applications <span class="blsp-spelling-corrected" id="SPELLING_ERROR_6">surpassed</span> the Sales of <span class="blsp-spelling-error" id="SPELLING_ERROR_7"><span class="blsp-spelling-error" id="SPELLING_ERROR_5">Siebel</span></span> Analytics Platform ~ BI Suite of Tools. By the end of the same year, <span class="blsp-spelling-error" id="SPELLING_ERROR_8"><span class="blsp-spelling-error" id="SPELLING_ERROR_6">Siebel</span></span> Analytics (application and tools) sales revenue was second to revenue in sales of <span class="blsp-spelling-error" id="SPELLING_ERROR_9"><span class="blsp-spelling-error" id="SPELLING_ERROR_7">Siebel</span></span> <span class="blsp-spelling-error" id="SPELLING_ERROR_10"><span class="blsp-spelling-error" id="SPELLING_ERROR_8">eBusiness</span></span> Application or <span class="blsp-spelling-error" id="SPELLING_ERROR_11"><span class="blsp-spelling-error" id="SPELLING_ERROR_9">CRM</span></span> offering. At the time <span class="blsp-spelling-error" id="SPELLING_ERROR_12"><span class="blsp-spelling-error" id="SPELLING_ERROR_10">Siebel</span></span> Systems was acquired by Oracle, it was considering the industry leader in <span class="blsp-spelling-error" id="SPELLING_ERROR_14"><span class="blsp-spelling-error" id="SPELLING_ERROR_11">CRM</span></span> applications. Nevertheless, it was not known by its BI offering.</div><div> </div><div>Last week Oracle <span class="blsp-spelling-corrected" id="SPELLING_ERROR_15">announced</span> Industry's First Enterprise Performance Management System which is the integration of Transactional Systems, Financial Performance Management and Operational BI Systems. </div><br /><div> </div><div>I am a <span class="blsp-spelling-error" id="SPELLING_ERROR_16"><span class="blsp-spelling-error" id="SPELLING_ERROR_12">Siebel</span></span> Analytics Certified Master <span class="blsp-spelling-corrected" id="SPELLING_ERROR_17">Consultant</span>. I have clients who had integrated <span class="blsp-spelling-error" id="SPELLING_ERROR_18"><span class="blsp-spelling-error" id="SPELLING_ERROR_13">Siebel</span></span> <span class="blsp-spelling-error" id="SPELLING_ERROR_19"><span class="blsp-spelling-error" id="SPELLING_ERROR_14">CRM</span></span> and Analytics applications in order to provide true <span class="blsp-spelling-corrected" id="SPELLING_ERROR_20">pervasive</span> capability. <a href="http://analyticsdoneright.blogspot.com/2007/08/oracles-vision-for-emp-system.html">Oracle's Vision for an <span class="blsp-spelling-error" id="SPELLING_ERROR_21"><span class="blsp-spelling-error" id="SPELLING_ERROR_15">EMP</span></span> system</a> is a reality. Just asked any organization that is able to drill from a <span class="blsp-spelling-error" id="SPELLING_ERROR_22"><span class="blsp-spelling-error" id="SPELLING_ERROR_16">Siebel</span></span> <span class="blsp-spelling-error" id="SPELLING_ERROR_23"><span class="blsp-spelling-error" id="SPELLING_ERROR_17">CRM</span></span> application into <span class="blsp-spelling-error" id="SPELLING_ERROR_24"><span class="blsp-spelling-error" id="SPELLING_ERROR_18">Siebel</span></span> Analytics application. </div><br /><div> </div><div>Oracle BI <span class="blsp-spelling-error" id="SPELLING_ERROR_25"><span class="blsp-spelling-error" id="SPELLING_ERROR_19">EE</span></span> = <span class="blsp-spelling-error" id="SPELLING_ERROR_26"><span class="blsp-spelling-error" id="SPELLING_ERROR_20">Siebel</span></span> Analytics Platform</div><div>Oracle BI Applications = <span class="blsp-spelling-error" id="SPELLING_ERROR_27"><span class="blsp-spelling-error" id="SPELLING_ERROR_21">Siebel</span></span> Relationship Management Warehouse (<span class="blsp-spelling-error" id="SPELLING_ERROR_28"><span class="blsp-spelling-error" id="SPELLING_ERROR_22">RMW</span></span>) and Customer Centric Warehouse</div><br /><div><a href="http://streaming.oracle.com/ebn/podcasts/middleware/5059682.mp3" s_oid="http://streaming.oracle.com/ebn/podcasts/middleware/5059682.mp3" s_oidt="0">Hear Paul <span class="blsp-spelling-error" id="SPELLING_ERROR_29"><span class="blsp-spelling-error" id="SPELLING_ERROR_23">Rodwick</span></span>, VP of Oracle BI Products, discuss the trend toward pervasive BI</a> (MP3) </div>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-82022650865647628152008-03-25T23:28:00.000-07:002008-03-25T23:29:33.522-07:00How much a Siebel Analytics/Oracle BI Consultant is worth these days?<p><a href="http://bp3.blogger.com/_2u9Z9JoR1jk/Rrskeycj14I/AAAAAAAAAIE/v7Re3N8iMBU/s1600-h/OBIEE+Billing+Rates.JPG"><img id="BLOGGER_PHOTO_ID_5096707514656085890" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp3.blogger.com/_2u9Z9JoR1jk/Rrskeycj14I/AAAAAAAAAIE/v7Re3N8iMBU/s320/OBIEE+Billing+Rates.JPG" border="0" /></a><br /><br /></p><div>HotGigs collects and aggregates hourly bill rate data from the thousands of consultants on their Staffing Exchange and provides rate research summary data as a free service to their visitors. </div><br /><br /><br /><br /><div>According to HotGigs the average hourly bill rate for a Oracle BI Consultant is 137.50. I recommend using this service to plan for contract resources and to compare bill rates against the market.</div><br /><br /><br /><br /><a href="http://www.hotgigs.com/rates/skill/Oracle-Business-Intelligence-hourly-consultant-bill-rates/">http://www.hotgigs.com/rates/skill/Oracle-Business-Intelligence-hourly-consultant-bill-rates/</a>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com1tag:blogger.com,1999:blog-1094400282594219520.post-23235893747634112912008-03-25T23:22:00.000-07:002008-03-25T23:24:16.012-07:00Oracle BI EE Plus and Hyperion products available for download<p><a href="http://bp1.blogger.com/_2u9Z9JoR1jk/RryqOCcj1-I/AAAAAAAAAI0/g1k30AMszjc/s1600-h/OBIEE+Plus+1.JPG"><img id="BLOGGER_PHOTO_ID_5097136036428109794" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp1.blogger.com/_2u9Z9JoR1jk/RryqOCcj1-I/AAAAAAAAAI0/g1k30AMszjc/s320/OBIEE+Plus+1.JPG" border="0" /></a><br /></p><div>A week ago Oracle <span class="blsp-spelling-corrected" id="SPELLING_ERROR_0">announced</span> a new version of its flagship BI suite of tool "Oracle BI Enterprise Edition Plus" </div><br /><div>It includes four products from Hyperion:</div><ul><br /><li>Hyperion Interactive Reporting </li><br /><li>Hyperion <span class="blsp-spelling-error" id="SPELLING_ERROR_1">SQR</span> Production Reporting Hyperion <span class="blsp-spelling-error" id="SPELLING_ERROR_2">SQR</span> Production Reporting</li><br /><li>Hyperion Financial <span class="blsp-spelling-corrected" id="SPELLING_ERROR_3">Reporting</span> g Hyperion Financial <span class="blsp-spelling-corrected" id="SPELLING_ERROR_4">Reporting</span></li><br /><li>Hyperion Web Analysis Hyperion Web Analysis </li></ul><br /><p>Oracle BI <span class="blsp-spelling-error" id="SPELLING_ERROR_5">EE</span> Plus goes for 1,700 instead of 1,500 - Oracle BI <span class="blsp-spelling-error" id="SPELLING_ERROR_6">EE</span>.</p><p>For a brief description of Oracle Business Intelligence Suite Enterprise Edition Plus Components can be found <a href="http://www.oracle.com/technology/products/bi/enterprise-edition-platform-components.html">here</a></p><p>Finally, Hyperion products are available for download. I recommend all certified <span class="blsp-spelling-error" id="SPELLING_ERROR_7">Siebel</span> Analytics ~ Oracle BI consultants to take advantage of this opportunity. </p><p>The <span class="blsp-spelling-error" id="SPELLING_ERROR_8">Essbase</span> cubes will be a data source for the <span class="blsp-spelling-error" id="SPELLING_ERROR_9">Siebel</span> Analytics/Oracle BI Server. Oracle has the connectivity built but has to get it in a release, most likely the end of the year. </p><p><a href="http://oraclebi.blogspot.com/2007/07/hyperion-products-now-available-for.html">http://oraclebi.blogspot.com/2007/07/hyperion-products-now-available-for.html</a></p><br /><p><br /></p>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0tag:blogger.com,1999:blog-1094400282594219520.post-84513379252161420432008-03-25T23:20:00.000-07:002008-03-25T23:21:54.797-07:00Hyperion System 9 and Oracle BI EE Plus<p>Basic Definitions before we dive into Hyperion System 9 and Oracle BI Enterprise Edition (OBIEE) Plus<br /><br /><strong>What is a data warehouse?</strong><br /><br />A data warehouse is a collection of data marts representing historical data from different operations in the company. This data is stored in a structure optimized for querying and data analysis as a data warehouse. Table design, dimensions and organization should be consistent throughout a data warehouse so that reports or queries across the data warehouse are consistent. A data warehouse can also be viewed as a database for historical data from different functions within a company.<br /><br /><strong>What is a data mart?</strong><br />A data mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes complete individual data warehouses which are usually smaller than the corporate data warehouse.<br /><br /><br /><strong>What are the benefits of data warehousing?</strong><br />Data warehouses are designed to perform well with aggregate queries running on large amounts of data.The structure of data warehouses is easier for end users to navigate, understand and query against unlike the relational databases primarily designed to handle lots of transactions.Data warehouses enable queries that cut across different segments of a company's operation. E.g. production data could be compared against inventory data even if they were originally stored in different databases with different structures.<br /><br /><br />Queries that would be complex in very normalized databases could be easier to build and maintain in data warehouses, decreasing the workload on transaction systems. Data warehousing is an efficient way to manage and report on data that is from a variety of sources, non uniform and scattered throughout a company. Data warehousing is an efficient way to manage demand for lots of information from lots of users. Data warehousing provides the capability to analyze large amounts of historical data for nuggets of wisdom that can provide an organization with competitive advantage.<br /><br /><br /><strong>OLAP - Online Analytics Processing</strong><br />OLAP tools typically provide multi-dimensional functionalities, such as slicing and dicing, and pivoting query results, which require the underlying database to be designed in a multi-dimensional schema. Furthermore, some OLAP tools have specific preference for either star schemas or snowflake schemas (ROLAP), and some tools(MOLAP) even provide their own proprietary DBMS engine (e.g Hyperion System 9) Using the wrong database design could prevent the OLAP tool from functioning properly – or at all.<br /><br /><br /><strong>Hyperion System 9</strong> is a comprehensive Business Performance Management system that<br />integrates modular suites of financial management applications with the most comprehensive<br />business intelligence (BI) capabilities for reporting and analysis.<br /><br /><br /><img id="BLOGGER_PHOTO_ID_5097901910701365298" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp3.blogger.com/_2u9Z9JoR1jk/Rr9ixycj2DI/AAAAAAAAAJc/ew7TO-lCCWQ/s400/Hyperion+System+9_1.JPG" border="0" /><br /><br /><br /></p><div><strong>Major components of Hyperion System 9:</strong><br />Hyperion System 9 Foundation Services<br />Hyperion System 9 BI+ Analytics<br />BI+<br />Hyperion System 9 Applications+<br />Hyperion System 9 Data Management Services</div><br /><div>To download System 9 Components, read my previous entry <a href="http://analyticsdoneright.blogspot.com/2007/08/oracle-bi-ee-plus-and-hyperion-products.html">Oracle BI EE Plus and Hyperion products available for download</a> </div><br /><div><strong></strong></div><div><strong>Foundation Services:<br /></strong>Hyperion License Server<br />Hyperion System 9 Shared Services<br />Hyperion System 9 Smart View for Office<br /><strong></strong></div><div><strong>BI+ Analytics:</strong><br />Hyperion System 9 BI+ Analytic Services<br />Hyperion System 9 BI+ Analytic Administration Services<br />Hyperion System 9 BI+ Analytic Integration Services<br />Hyperion System 9 BI+ Analytic Provider Services<br /><strong></strong></div><div><strong>BI+ :<br /></strong><span style="color: rgb(255, 0, 0);">Hyperion System 9 BI+ Interactive Reporting - OBIEE Plus<br />Hyperion System 9 BI+ Financial Reporting - OBIEE Plus<br />Hyperion System 9 BI+ Production Reporting - OBIEE Plus<br />Hyperion System 9 BI+ Web Analysis - OBIEE Plus<br /></span>Hyperion System 9 BI+ Enterprise Metrics<br /><strong></strong></div><div><strong>Applications+:</strong><br />Hyperion System 9 Planning<br />Hyperion System 9 Financial Management<br />Hyperion System 9 Performance Scorecard<br />Hyperion System 9 Strategic Finance<br />Hyperion System 9 Translation Manager </div><div><strong>Data Management Services:</strong><br />Hyperion System 9 Master Data Management<br />Hyperion System 9 Data Integration Management<br />Hyperion System 9 Financial Data Quality Management<br /><br />Note:<br />Hyperion System 9 Workspace is the Web client for BI+, Planning, and Financial<br />Management and is part of the BI+ installation. Hyperion System 9 BPM Architect is part<br />of the Financial Management and Planning installations.</div><br /><div><strong></strong></div><div><strong>System 9 OLAP Data Sources:</strong></div><br /><br /><img id="BLOGGER_PHOTO_ID_5097902056730253378" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp1.blogger.com/_2u9Z9JoR1jk/Rr9i6Scj2EI/AAAAAAAAAJk/gKOWSGux66U/s400/Hyperion+System+9_2.JPG" border="0" /><br /><br /><div><strong></strong></div><p><span style="font-family: arial;"><strong>System 9 Relational Data Repositories</strong>:</span><span style="font-family: arial;"><br />Some relational databases are supported as both data repositories and data sources.<br />Products that require a dedicated data repository: </span></p><ul><li><span style="font-family: arial;">Analytic Administration Services—A dedicated database repository is required for Analytic Administration Services only if Log Analyzer is used.</span></li><li><span style="font-family: arial;">Analytic Integration Services</span></li><li><span style="font-family: arial;">BI+</span></li><li><span style="font-family: arial;">BPM Architect—Oracle client must be installed on the Dimension server.</span></li><li><span style="font-family: arial;">Data Integration Management</span></li><li><span style="font-family: arial;">FDM</span></li><li><span style="font-family: arial;">Financial Management</span></li><li><span style="font-family: arial;">Hyperion MDM</span></li><li><span style="font-family: arial;">Performance Scorecard</span></li><li><span style="font-family: arial;">Planning</span></li><li><span style="font-family: arial;">Shared Services</span></li><li><span style="font-family: arial;">Translation Manager<br /></span></li></ul><br /><p><span style="font-family: arial;">Products on which Oracle 10g-10.2.0.2 is supported:<br /></span></p><span style="font-family: arial;"><li><span style="font-family: arial;">Analytic Administration Services</span></li><li><span style="font-family: arial;">BI+</span></li><li><span style="font-family: arial;">BPM Architect</span></li><li><span style="font-family: arial;">Data Integration Management</span></li><li><span style="font-family: arial;">Financial Management</span></li><li><span style="font-family: arial;">Planning</span></li><li><span style="font-family: arial;">Shared Services</span></li><li><span style="font-family: arial;">Translation Manager</span></li><br /><p><span style="font-family: arial;"><strong>Siebel Analytics Platform ~ OBIEE</strong></span></p><br /><p><strong>Supported Databases:</strong></p><img id="BLOGGER_PHOTO_ID_5097902232823912530" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp2.blogger.com/_2u9Z9JoR1jk/Rr9jEicj2FI/AAAAAAAAAJs/VQRNJ4SlrdI/s400/OBIEE+source1.JPG" border="0" /><br /><br /><p><strong>Certified Multidimensional Data Source:</strong></p><img id="BLOGGER_PHOTO_ID_5097902357377964130" style="margin: 0px auto 10px; display: block; text-align: center;" alt="" src="http://bp3.blogger.com/_2u9Z9JoR1jk/Rr9jLycj2GI/AAAAAAAAAJ0/gkCWJw8hgMA/s400/OBIEE+source2.JPG" border="0" /><br /><br /><br /><span style="font-family: arial;">The Essbase cubes will be a data source for the Siebel Analytics/Oracle BI Server. Oracle has the connectivity built but has to get it in a release, most likely the end of the year.<br /><br />Support for ODBC Data Sources<br /><br />Oracle Business Intelligence support for ODBC allows Oracle Business Intelligence Server, when operating on Windows, to query any relational database management system—either as a data warehouse, an operational data store or as a transactional system—that supports the ODBC 2.0, 2.1 or 3.5 standards.</span></span>ISAAC HEBERhttp://www.blogger.com/profile/05460036664062800557noreply@blogger.com0