Skip to Content
0
Former Member
Apr 18, 2008 at 09:12 AM

KPI Monitor in VC

23 Views

Dear all,

I'm trying to create a KPI monitor using BEx queries as the source, the output via a VC model.

Within the BEx Query Designer, how can I:

1. Get a query to run, without the user required to enter a variable, to show this month's data only (from beginning of current month to current day) ?

2. Get a query to run, without the user required to enter a variable, to show the whole of last months data only ?

I think both issues are to do with the restrictions I put on the time characteristic in the query designer, but I don't know which ones to use.

Many Thanks,

Richard.