The cloud comes with many advantages and some challenges. Innovations in cloud technology allow businesses to operate more or less exclusively in the cloud, should they want to go that route. Extract-Transform-Load (ETL) technology allows for a seamless integration of information from various sources to be…
Tags: Data Warehousing, Kusal Swarnakar, Cloud Services, Big Data, ETL, Data Integration, Blog
Once the BIAPPS installation is completed, the newly introduced web-based JAVA applications, BI Configuration Manager (BIACM) and Functional Set-up Manager (FSM), are available for administrators to complete the set-up related tasks. As it is a new product, the first thing that most do is, run through the oracle documentation, discuss with experts and fellow colleagues, take part in Oracle webinars etc. After that, we still land up with a long list of new terminologies and jargon.
Tags: Data Warehousing, ODI, Ashwin Pujari, BIACM, FSM, Oracle, Tutorial, ETL, Data Integration, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
Chart of Accounts Hierarchy (COA) is a structure that is used to classify and group accounts for financial reporting purposes. All transactions can be done at the Account Level (lowest), and higher levels are for roll-ups for reporting purposes.
The diagram below shows a Chart of Accounts Hierarchy of Company X:
Tags: Data Warehousing, OBIEE, Oracle E-Business Suite, Ravi Hoskote, Oracle, Business Intelligence, Oracle BI, Oracle BI Applications, Blog
With the political problems hovering around the launch of The Affordable Care Act ("Obamacare") now seemingly left behind, the biggest threat to the Affordable Care Act is now a technical one. Initial problems involving massive traffic surges leading to website unavailability were unfortunate but hardly unexpected. Many other high-demand services such as Twitter have experienced similar issues in their infancy. Far more worrying are the continuing data problems which, if left unchecked, could see people left without insurance.
Tags: Data Warehousing, Vision Workshop, Data Quality, Big Data, Government, Jeremiah Johnson, Data Integration, Blog
Many customers have real-time reporting requirements that are analytic in nature. Essentially, they have a real-time report as a starting point for a more detailed real-time analysis which can go a few levels deep. Shown below is a generic example of one such requirement for Account Analysis.
Tags: Data Warehousing, Oracle E-Business Suite, Real-Time BI, Training, Real-Time Supply Chain and Inventory Analytics, Oracle, Business Intelligence, Tutorial, Puneet Aggarwal, Oracle BI, Oracle BI Applications, Real-Time Financial Analytics, Blog
Another article in Ashok's series where he examines Oracle Data Integrator (ODI) Knowledge Modules (KM). For an basic introductory overview, check out 'What is an ODI Knowledge Module (KM)?'
Tags: Data Warehousing, Ashok Das, Tutorial, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
Providing actionable business intelligence across the enterprise to enable informed decision-making and streamlined business processes is an obtainable goal. Often the challenge is determining where to start, how to select trusted advisors, how to form your team, and how to set user expectations.
Tags: Data Warehousing, Webinar, Sid Goel, Financial Analytics, Oracle, Business Intelligence, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Book, Simon Miller, William Hutchinson, Human Resource Analytics, Blog
Snapshot data is a copy of business data preserved at some point-in-time. In some cases we may not be able to recover older snapshot data from the current data sets because we need to preserve snapshots at regular (scheduled) intervals for historical analysis.
Tags: Data Warehousing, Financial Analytics, Oracle E-Business Suite, Prabu Varatharaju, Informatica, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
A key component to any Business Intelligence (BI) Architecture is the Extract, Translate and Load (ETL) process. The ETL process is typically scheduled on a daily basis and is capable of data movement from legacy systems into a data warehouse. It is also used to facilitate the work of the database administrators who connect different branches of databases as well as integrate or change the existing databases.
Tags: Data Warehousing, Oracle, Informatica, Business Intelligence, Sridhar Kasthuri, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
This blog introduces and explains the detailed step by step process for executing the Data Load to Business Analytics Warehouse. Here, we are illustrating for the Student information Analytics data using the new OBIA 11g which is supported only for PeopleSoft 9.0 Campus Solutions.
Tags: Student Information Analytics, Data Warehousing, OBIEE, Peoplesoft Campus Solutions, Veera Reddy Ramidi, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Peoplesoft, Blog
