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.
Premier support for Oracle Discoverer is ending in June 2014 and if you're feeling the pressure to migrate to another solution, you're not...
Premier support for Oracle Discoverer is ending in June 2014 and if you're feeling the pressure to migrate to another solution, you're not alone. Moving to Oracle Business Intelligence and Oracle BI Applications, Oracle's newest flagship platform for business intelligence and decision support, is a decision facing many Discoverer customers.
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."
Kusal Swarnakar, Co-Founder of KPI Partners, visits with Joel Borellis, Group Vice President of Partner Enablement at Oracle, on the set...
Kusal Swarnakar, Co-Founder of KPI Partners, visits with Joel Borellis, Group Vice President of Partner Enablement at Oracle, on the set of Oracle PartnerNetwork Live during Oracle OpenWorld 2013.
KPI was offered the unique opportunity to be a featured guest as part of the first keynote presentation at Oracle OpenWorld. The audience...
KPI was offered the unique opportunity to be a featured guest as part of the first keynote presentation at Oracle OpenWorld. The audience included several thousand partners, customers, media members, and industry analysts. KPI is one of over 5,000 Oracle partners around the globe, so we were very appreciative of the invitation to participate.
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.
by Jaime Seagraves
The New York Police Department has developed what they are calling a hi-tech analytical dashboard tool that collects...
by Jaime Seagraves
The New York Police Department has developed what they are calling a hi-tech analytical dashboard tool that collects crime and event data around the city. This Domain Awareness System, known as “The Dashboard,” is helping the NYPD combat crime and terror on the streets.
by Veera Reddy Ramidi
This blog introduces and explains the detailed step by step process for executing the Domain Load to Business...
by Veera Reddy Ramidi
This blog introduces and explains the detailed step by step process for executing the Domain 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. This blog can be used similarly for any other Analytics using OBIA 11g.
by Sharath Venkataranga
The most common question faced by any ETL developer or a Data Warehouse project implementer is always related to...
by Sharath Venkataranga
The most common question faced by any ETL developer or a Data Warehouse project implementer is always related to performance. Whatever the tool may be, and however fast the job may be running, the end user will always desire something which is a little faster and quicker.
by Shiva Molabanti
Version 11.1.1.7.0 of Oracle Business Intelligence Enterprise Edition (OBIEE) Supports Multiple-Source Session Variables
by Shiva Molabanti
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.
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.
Premier support for Oracle Discoverer is ending in June 2014 and if you're feeling the pressure to migrate to another solution, you're not alone. Moving to Oracle Business Intelligence and Oracle BI Applications, Oracle's newest flagship platform for business intelligence and decision support, is a decision facing many Discoverer customers.
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."
Kusal Swarnakar, Co-Founder of KPI Partners, visits with Joel Borellis, Group Vice President of Partner Enablement at Oracle, on the set of Oracle PartnerNetwork Live during Oracle OpenWorld 2013.
KPI was offered the unique opportunity to be a featured guest as part of the first keynote presentation at Oracle OpenWorld. The audience included several thousand partners, customers, media members, and industry analysts. KPI is one of over 5,000 Oracle partners around the globe, so we were very appreciative of the invitation to participate.
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.
by Jaime Seagraves
The New York Police Department has developed what they are calling a hi-tech analytical dashboard tool that collects crime and event data around the city. This Domain Awareness System, known as “The Dashboard,” is helping the NYPD combat crime and terror on the streets.
by Veera Reddy Ramidi
This blog introduces and explains the detailed step by step process for executing the Domain 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. This blog can be used similarly for any other Analytics using OBIA 11g.
by Sharath Venkataranga
The most common question faced by any ETL developer or a Data Warehouse project implementer is always related to performance. Whatever the tool may be, and however fast the job may be running, the end user will always desire something which is a little faster and quicker.
by Shiva Molabanti
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.
