Los Angeles, CA – November 5, 2014. KPI recently announced the launch of an internal expert services team for Oracle BI Cloud Services...
Los Angeles, CA – November 5, 2014. KPI recently announced the launch of an internal expert services team for Oracle BI Cloud Services (BICS) that acts as a specialized advisory group for projects focused on this new technology. The KPI Partners Oracle BICS Task Force can demonstrate real-world use case scenarios and an accelerated value-driven approach to cloud-based analytics.
by Myles Gilsenan
Financial managers in all industries need to be aware of the health of their organization as well as the health of the...
by Myles Gilsenan
Financial managers in all industries need to be aware of the health of their organization as well as the health of the processes that enable sound financial management. In this article, I will outline some basic metrics that can be used to identify and evaluate the health and efficiency of the accounting and finance function as well as the financial health of the organization.
While it is true that specific metrics can vary across industries, in this article we will address metrics and concepts that can be applied across most industries.
The metrics to be discussed will be broken up into the following categories:
by Naresh Meda
What Is A Level-Based Measure?
A level-based measure is a column whose values are always calculated to a specific level of...
by Naresh Meda
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.
by Shiva Molabanti
Oracle Business Intelligence Cloud Service (BICS) - Every organization should carefully evaluate the tool, as well as...
by Shiva Molabanti
Oracle Business Intelligence Cloud Service (BICS) - Every organization should carefully evaluate the tool, as well as its potential for end-user adoption.
In today’s technological landscape there’s an ever-accelerating demand for increased efficiency and effectiveness. An organization, before evaluating a new solution, must consider end-user adoption for every technology prior to implementation, particularly when the cost of deployment and training are often driven by the rate of user adoption.
_1-resized-600.gif)
by Madan Thota
Endeca Information Discovery (EID) is a data discovery tool that helps business analysts to rapidly explore relevant data....
by Madan Thota
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.
by Puneet Aggarwal
Many customers have real-time reporting requirements that are analytic in nature. Essentially, they have a real-time...
by Puneet Aggarwal
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.
by Shiva Molabanti
Prerequisites:
- OBIEE 11.1.1.7.1 (If your version of Oracle BI EE is not 11.1.1.7.1, download Patch 16556157: OBIEE...
by Shiva Molabanti
Prerequisites:
- OBIEE 11.1.1.7.1 (If your version of Oracle BI EE is not 11.1.1.7.1, download Patch 16556157: OBIEE BUNDLE PATCH 11.1.1.7.1 from My Oracle Support).
- To support Oracle BI Mobile App Designer with Oracle BI Web Catalog, Apply OBIEE 11.1.1.7.1 MLR Patch 17004920.
- Download Oracle BI Mobile App Designer Patch 17220944 from My Oracle Support.
Installation Steps:
- Stop All OBIEE 11G services (Weblogic Admin Server, Managed Server and OPMN services).
- Apply OBIEE 11.1.1.7.1 MLR Patch 17004920 using OPatch Utility.
- Apply Oracle BI Mobile App designer Patch 17220944 using OPatch Utility.
- Deploy the Oracle BI Mobile App Designer (MAD) manually using Weblogic Configuration Assistant as shown below.
- Open Command prompt window and Navigate to: <MW_HOME>\Oracle_BI1\common\bin
- Run "config.bat" to start the WebLogic Configuration Assistant Tool.
On welcome screen, select ‘"Extend an existing WebLogic domain" and click "Next."
by Sridhar Kasthuri
A key component to any Business Intelligence (BI) Architecture is the Extract, Translate and Load (ETL) process. The...
by Sridhar Kasthuri
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.
Los Angeles, CA – November 5, 2014. KPI recently announced the launch of an internal expert services team for Oracle BI Cloud Services (BICS) that acts as a specialized advisory group for projects focused on this new technology. The KPI Partners Oracle BICS Task Force can demonstrate real-world use case scenarios and an accelerated value-driven approach to cloud-based analytics.
by Myles Gilsenan
Financial managers in all industries need to be aware of the health of their organization as well as the health of the processes that enable sound financial management. In this article, I will outline some basic metrics that can be used to identify and evaluate the health and efficiency of the accounting and finance function as well as the financial health of the organization.
While it is true that specific metrics can vary across industries, in this article we will address metrics and concepts that can be applied across most industries.
The metrics to be discussed will be broken up into the following categories:
by Naresh Meda
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.
by Shiva Molabanti
Oracle Business Intelligence Cloud Service (BICS) - Every organization should carefully evaluate the tool, as well as its potential for end-user adoption.
In today’s technological landscape there’s an ever-accelerating demand for increased efficiency and effectiveness. An organization, before evaluating a new solution, must consider end-user adoption for every technology prior to implementation, particularly when the cost of deployment and training are often driven by the rate of user adoption.
by Madan Thota
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.
by Puneet Aggarwal
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.
by Shiva Molabanti
Prerequisites:
- OBIEE 11.1.1.7.1 (If your version of Oracle BI EE is not 11.1.1.7.1, download Patch 16556157: OBIEE BUNDLE PATCH 11.1.1.7.1 from My Oracle Support).
- To support Oracle BI Mobile App Designer with Oracle BI Web Catalog, Apply OBIEE 11.1.1.7.1 MLR Patch 17004920.
- Download Oracle BI Mobile App Designer Patch 17220944 from My Oracle Support.
Installation Steps:
- Stop All OBIEE 11G services (Weblogic Admin Server, Managed Server and OPMN services).
- Apply OBIEE 11.1.1.7.1 MLR Patch 17004920 using OPatch Utility.
- Apply Oracle BI Mobile App designer Patch 17220944 using OPatch Utility.
- Deploy the Oracle BI Mobile App Designer (MAD) manually using Weblogic Configuration Assistant as shown below.
- Open Command prompt window and Navigate to: <MW_HOME>\Oracle_BI1\common\bin
- Run "config.bat" to start the WebLogic Configuration Assistant Tool.
On welcome screen, select ‘"Extend an existing WebLogic domain" and click "Next."
by Sridhar Kasthuri
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.
