Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dynamic and Prompted Dates in Central Management Console/BI Launchpad

Hi,

I'm not sure if this is the right forum for this discussion, so please let me know if I should move it.

The reports where I work are currently with an Oracle database, using SQL Commands or stored procedures and temp tables, run through a custom Internet interface or scheduled through Central Management Console or BI Launchpad.

The reports in question that I'm being asked about are desired to have both dynamic and user-entered date parameters.

When they are scheduled on a recurring basis, the user wants to put in a formula or sysdate (see attached) so that can be used to complete the date parameters, BUT if the report is run ad-hoc or through the Internet interface, the user can still enter the date parameters and have it run to those specifications.

Is this possible?  I would normally have two reports - one that runs the desired date range and set that one to recurring and one for ad-hoc with date parameters.

Would anyone happen to know how to do this?  If it's possible?  A work-around?

Thank you,

Erin

SysDate.jpg (14473 B)
Tags:
Former Member
replied

Cool.  Here's what you'll do:

1.  Create a parameter where the user can select which set of dates to use - the automatic ones for scheduling or the actual dates for on-demand reports.  I'll call this {?DateType} and it has two values - "Scheduled" and "User Defined".

2.  Create two Date parameters - {?Start Date} and {?End Date}.  Make both of them Optional in the parameter definition.

3.  Update the formula in the Select Expert.  It should look something like this:

(

({?DateType} = 'User Defined' and HasValue({?Start Date}) and HasValue ({?End Date}) and {MyTable.DateField} >= {?Start Date} and {MyTable.Date Field} <= {?EndDate})

OR

({?DateType} = 'Scheduled' and <whatever date criteria you use for scheduled reports)

OR

false

)

Note that the parentheses are VERY important for getting this to work right.

The "false" value at the end will cause it to return no data if either date parameter has no values.

-Dell

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question