Create filters in Universe

[Former Member]

Hi,

I would like to know how to create a Current Fiscal year filter at universe level and use it as a condition in WEBI?. The current FY should change dynamicallay based on the sy-datum.

For ex: Our FY will start from March of each year and end Feb of each year.

Please guide me how to achieve this functionality?

Regards,

Satya

[IngoH]

Hi,

take a look here:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c82062...

Ingo

[Former Member]

Hi Ingo,

I have already gone through that document and it didn't say about creating the conditions on sy-datum. I have seen only creating the conditions by static values not dynamically.

Is it possible to create them at universe level or in query level.

Thanks for your help!!!

Regards,

Satya

[IngoH]

Hi,

it sounds to me that you trying to reference a system date as part of the filter. Unfortunately the universe doesn't provide you that functionality today. You could create an EXIT variable in the BW query and leverage it in that way.

Ingo