BusinessObjects XI - Prompt for Section Headers

BusinessObjects Web Intelligence reports can’t prompt the end users for section headers on a report using its built-in features. However, this can be achieved by using the advanced report creation technique demonstrated below.

• Dynamically section a report based on Prompt response
• Requires new objects in universe

• Create query, using new objects

• Run the query, selecting a different object for each section

• Create a variable for each section

Section 1 Object:
=If([Section 1]="Lines";[Lines];If([Section 1]="State";[State];[Year])
)
Section 2 Object:
=If([Section 2]="Lines";[Lines];If([Section 2]="State";[State];[Year])
)
Section 3 Object:
=If([Section 3]="Lines";[Lines];If([Section 3]="State";[State];[Year])
)

• Finally, section the report on the 3 new variables

Extensibility of Oracle BI Applications

A critical success factor for successful adaptation of Business Intelligence (BI) in organizations is proven results in a relatively short period of time. To maintain executive buy-in and funding it is often required for BI projects to show results in 90-120 days. For solutions with Oracle E-Business Suite, PeopleSoft or Siebel CRM the choice of using Oracle BI applications is a simple one due to the high degree of match to the data from the source systems. These solutions enable rapid return on investment providing comprehensive BI solutions based on best practices in a much quicker timeframe than what could be delivered through custom development. However, can efficiencies also be achieved when the source system is not closely aligned with the BI application? This paper will introduce the Oracle BI Analytic Applications and discuss the benefits of these pre-built analytics applications for projects that are not sourced from the ERP applications. In this paper, we will also follow an example project that used Public Sector Case Analytics without a Siebel ERP source to reduce time to market in delivery of a data warehouse (DW) and BI solution.

The remaining content of this whitepaper can be found on Oracle's site at:

http://www.oracle.com/us/solutions/ent-performance-bi/guident-extensibility-bi-apps-wp-070085.pdf