on 08-03-2010 9:24 PM
I am trying to create filters, which give current year, or current fiscal year, current month etc...
If source is a RDBMS, we can get from the system date, etc... but acheiving the same from BW source is becoming a nightmare.
Did anyone implemented, these filters in Universe from BW.
Thanks,
Sri
Hi,
you would do those items already in the BW query using EXIT Variables because as of right now the MDX does not allow you to reference something like a system date which is something you need as a starting point.
Ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"Exit Variables", sounds Interesting I have one doubt before trying to implement it, (As I am new to the SAP BW part)
Will the exit Variables. implement the filter only when we drag the filter in the WebI, or is it a custom filter on the BEX when ever the Query runs it will filter of the whole set.
Thanks Ingo and Sree for Quick Response,
Will try the approach, Our BW box is stressed out to run the loads, as now we are filtering it out on the WebI's
Sri
I believe the recommended solution for this is to use the SAP User Exit variables.
Thanks & Regards,
Sree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
26 | |
10 | |
10 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.