E-L-T vs. E-T-L
Oracle Data Integrator, or ODI, provides a new declarative design approach to defining data transformation and integration processes based on a unique Extract-Load-Transform (ELT) architecture. The declarative design approach separates the declarative rules from the implementation details. ODI architecture eliminates the need for a standalone ETL (Extract-Transform-Load) server and proprietary engine while leveraging the inherent power of RDBMS engines.
Read More
Tags:
Data Warehousing,
Training,
Varun Reddy,
Oracle,
Oracle BI,
Oracle BI Applications,
Examining OBIA 11g,
Oracle Data Integrator (ODI),
Blog
FSG is a report-building tool for Oracle E-Business Suite used for creating financial statements such as the income statement, trial balance, balance sheet, and cash flow statement. FSG reports typically are complex to build, difficult to maintain, and do not provide the modern analytical capabilities that exist with the Oracle Business Intelligence platform.
Read More
Tags:
Webinar,
Financial Analytics,
Pre-Built Solutions,
Oracle BI,
Oracle BI Applications,
Kumar Krishnaswamy,
Pavan Nanjundaiah,
FSG Reporting for Financial Analytics,
Blog
The BI Apps from Oracle present customers with a nice head start to getting their BI environment up and running. But for many customers, their user community demands lighting-fast speeds while running dashboards, reports and ad-hoc queries.
Read More
Tags:
Data Warehousing,
Webinar,
OBIEE,
Performance Layer,
Oracle BI,
Oracle BI Applications,
Jeff McQuigg,
Blog
With the release of the new version of Oracle's BI Applications, we've published some introductory articles such as 'Under The Hood Of The New Oracle BI Apps' and 'The ALL-NEW Oracle BI Apps... now with ODI (11.1.1.7.1)'. I thought I would take a deeper look into the steps involved with configuring this new version of the BI Apps.
Read More
Tags:
Vision Workshop,
Ashwin Pujari,
Oracle,
Business Intelligence,
Tutorial,
Oracle BI,
Oracle BI Applications,
Examining OBIA 11g,
Oracle Data Integrator (ODI),
Indirect Spend Planning,
Blog
Version 11.1.1.7.0 of Oracle Business Intelligence Enterprise Edition (OBIEE) Supports Multiple-Source Session Variables
In addition to supporting regular session variables that are populated from one data source, Oracle Business Intelligence 11.1.1.7.0 also supports session variables that can be populated from multiple data sources. These multi-source session variables can be used in logical queries or in repository data filters and contain the union of values from the different data sources. There is no restriction on the number of values that the multi-source session variable can hold. To create a multi-source session variable, you first create row-wise initialization blocks for each source.
Read More
Tags:
OBIEE,
Shiva Molabanti,
Business Intelligence,
Oracle BI,
Blog
In OBIEE 11.1.1.7.0 there is new BI Server utility called obieerpdpwdchg to change the RPD password from command line.
Read More
Tags:
OBIEE,
Shiva Molabanti,
Oracle,
Oracle BI,
Blog
OBIEE and SmartView integration – A Great Oracle BI / MS-Office Add-in
Oracle Hyperion SmartView for Office Integration.
SmartView is much more powerful than its well-known predecessor, the Hyperion Excel Add-In. It not only connects to Essbase, Hyperion Planning, and now to Oracle BI EE. The Smart View 11.1.2.2 Add-in replaces the Oracle BI Office Add-in as the primary Office application for Oracle BI Foundation. For benefit of the users, both are still available with OBI 11.1.1.7.
Read More
Tags:
OBIEE,
Shiva Molabanti,
MS Office,
Oracle,
Business Intelligence,
Oracle EPM,
MS Excel,
SmartView,
Oracle BI,
Hyperion,
Blog
Organizations do not have the ability to wait for a data refresh during critical business times like the financial close process & the management of an enterprise's supply chain. The innovators at KPI Partners have extended the Oracle BI Applications to support real-time analytics.
Read More
Tags:
Data Warehousing,
Webinar,
Sid Goel,
OBIEE,
Financial Analytics,
Pre-Built Solutions,
Oracle E-Business Suite,
Real-Time BI,
Bruce Wroughton,
Oracle Discoverer,
Real-Time Supply Chain and Inventory Analytics,
Oracle,
Business Intelligence,
Oracle BI,
Oracle BI Applications,
Kumar Krishnaswamy,
Real-Time Financial Analytics,
Exalytics,
Fixed Asset Analytics,
Blog
I thought I’d post my presentation on QA (testing) that I delivered at the BIWA Summit near Oracle HQ in California. The presentation is based off of the recent QA posts I did on my personal blog, with a bit more silly graphics on top of it. The one take away from the presentation is that some people prefer the term "testing" as opposed to QA. Good to know. Anyway, enjoy!
Read More
Tags:
Seminar,
OBIEE,
Endeca,
Essbase,
Big Data,
Oracle,
Oracle BI,
Jeff McQuigg,
BIWA Summit,
KScope,
Blog
While business intelligence (BI) is meant to serve the purpose of managing the analysis of day-to-day transactional activity, enterprise performance management (EPM) is summary analysis that provides forward-thinking predictive and what-if analysis.
Read More
Tags:
Webinar,
Sid Goel,
OBIEE,
Case Study,
EPM,
Essbase,
Mark Joslin,
Oracle,
Business Intelligence,
Oracle EPM,
Oracle BI,
Oracle BI Applications,
Hyperion