What Is A Level-Based Measure?
A level-based measure is a column whose values are always calculated to a specific level of aggregation. Here is an example of a level-based measure using a Products and Revenue table. A level-based hierarchy is created for Products as follows:
By default, when we drill down within the products hierarchy from Brand level to Product level, the corresponding Revenue drills down to Product level.
Read More
Tags:
OBIEE,
Data Discovery,
Business Intelligence,
Tutorial,
Naresh Meda,
Oracle BI,
Blog
Endeca Information Discovery (EID) is a data discovery tool that helps business analysts to rapidly explore relevant data. If you are already using Oracle Business Intelligence Enterprise Edition (OBIEE) and wish to reuse the BI data models from Endeca Information Discovery, here are the options. The primary difference between both tools is that one is used for pre-defined analytics while the other is used for having a conversation with your data (analytics vs information discovery). The overall goal for both approaches is to get the most value out of the data available.
Read More
Tags:
OBIEE,
Endeca,
Data Discovery,
Business Intelligence,
Tutorial,
Oracle BI,
Blog
To see reports with the most up-to-date data from the latest extract-transform-load (ETL) process, we typically purge the Oracle BI Server Cache using a common job called, "Cache Purge."
Read More
Tags:
OBIEE,
Pre-Built Solutions,
Shiva Molabanti,
Cache,
Business Intelligence,
Tutorial,
ETL,
Oracle BI,
Oracle BI Applications,
Blog
Upgrading A Oracle Data Integrator (ODI) Repository from ODI 11g to ODI 12c
Migrating Oracle Data Integrator (ODI) from version 11g to 12c is not straight forward as exporting and importing it into a new repository. An administrator needs to upgrade the 11g version of the repository to the 12c version so the new features can be incorporated into into the code.
Read More
Tags:
ODI,
Raviteja Santosh,
Cloud Services,
Tutorial,
Data Integration,
Examining OBIA 11g,
Oracle Data Integrator (ODI)
Oracle Business Intelligence Enterprise Edition (OBIEE) 11g provides multi-dimensional navigation/analysis support. This multi-dimensional feature is supported for almost any data source including Microsoft SQL Server Analysis Services (SASS). For Microsoft SQL Server Analysis Services 2008/2012, we need to make an initial configuration before getting started with OBIEE.
Read More
Tags:
OBIEE,
Microsoft,
Suman Reddy,
SQL Server,
XML,
Business Intelligence,
Tutorial,
Oracle BI,
Blog
Learn How To Configure, Monitor, and Subscribe To Reports, Views and Workbooks Inside Tableau.
Tableau Subscriptions
The Subscriptions feature is considered to be one among the most important features in Tableau's interactive data visualization product. It is by far the easiest way to ensure that you review the most critical and valuable information on a regular basis. The information is shared via email once you have subscribed to a dashboard. The subscription feature is available from Tableau version 8.0 onwards.
Read More
Tags:
Imtiyaz Basha,
Business Intelligence,
Tutorial,
Tableau,
Blog
This article will help you understand the importance of the MD5 function in Informatica. It will also help you answer questions like:
Read More
Tags:
Data Warehousing,
Informatica,
Tutorial,
ETL,
SK Purushotham,
Data Integration,
Blog
The Standalone Collocated Agent comes as additional feature with Oracle Data Integrator (ODI) 12C, which is the blend of both standalone and Java Platform Enterprise Edition (Java EE) agents in ODI 12C. This can be configured only with an ODI 12C Enterprise Edition Installation.
Read More
Tags:
ODI,
Raviteja Santosh,
Oracle,
Tutorial,
Data Integration,
Oracle Data Integrator (ODI),
Blog
Oracle Business Intelligence Applications 11g : Getting familiar With Oracle's Business Intelligence Applications Configuration Manager (BIACM) & Functional Set-Up Manager (FSM)
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.
Read More
Tags:
Data Warehousing,
ODI,
Ashwin Pujari,
BIACM,
FSM,
Oracle,
Tutorial,
ETL,
Data Integration,
Oracle BI Applications,
Examining OBIA 11g,
Oracle Data Integrator (ODI),
Blog
