BI Publisher (MOSC)

MOSC Banner

Execute report variable number of times? to same Excel workbook?

edited Sep 7, 2010 9:31AM in BI Publisher (MOSC) 1 commentAnswered
CURRENT STATE
Discoverer report with 3 parameters:
1. Client ID
2. From Date
3. To Date

The report returns the client's data for the given date range. The report is often run for the same client for multiple, but related date ranges. For example, it is executed 8 times for 8 different quarterly date ranges to get the past 8 quarterly reports for the client. Each report takes several minutes to run.

REQUESTED FUTURE STATE

BI Publisher report with 4 parameters:
1. Client ID
2. From Date
3. To Date
4. Reporting Period (Monthly/Quarterly/Yearly) [NEW]

The customer wants to
-Enter one date range
-Run the report for each reporting period

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center