Current Year, Current Month...Default Values from BW source in BO Universe

[Former Member]

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

[IngoH · Accepted solution]

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

[Former Member · Accepted solution]

"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

[IngoH · Accepted solution]

Hi,

thats up to you to decide as part of the BW query design. you can have it as optional or as mandatory in the BW query

ingo

[Former Member · Accepted solution]

ingo,

how to schedule report by always filter current month - default value from BW source ?

is there any way to pass current month variable to filter condition?

i dont want to create 2 unverse where 1st one have exit variable, but 2nd one done have for ad hoc query.

[IngoH · Accepted solution]

Hi,

you create a BW query with EXIT variables. if you don't want that you can also create a range variable and ask the user for a time range

ingo

[Former Member]

I believe the recommended solution for this is to use the SAP User Exit variables.

Thanks & Regards,

Sree