When run anytime in August 2013, it returns “201307”
I would like to use this variable a filter in my report - i.e. DimYearMonth = DynamicDate
I want to do this for report scheduling purposes - we always schedule our production reports to run on the first or second of the month - with an “as of” date for the previous month.
In this example, when this scheduled report runs on August 2, 2013 the filter for DimYearMonth will be equal to “201307”
Any ideas on how to make something like this work?
P.S. I’m aware of how to do this at the Universe level by using SQL in a pre-defined condition. My issue is that this is a multi-source Universe and that solution does not work in 4x… SAP has confirmed this.
In webi, as far as I know, you can´t use a user object as a query filter. So your solution will have to be at query side with your Universe objects.
If your last dimension object for the yyyyMM dimension , at 08/02/2013, is 201307 , please take a look at pic1, if is 201308, see pic2. If you have future values for your
Otherwise we´ll have to discuss it further.
I´m on 3.1 but think that works for 4.x
Assume that [dat base] is your DimYearMonth
Thanks for the reply and I do appreciate your assistance. Unfortunately by the time the report is run, the YYYYMM dimension is already populated with 201308 in the database - hence the need to filter on 201307… (i.e. previous year/month)
Hi , sorry for the delay. I cannot generate a .wid with the solution for this. But I wrote a ppt trying to explain my solution. Any doubts, please contact me on the e-mail.
Cheers,