system
September 20, 2016, 1:10pm
#1
Hi
Does BOXI allow me to schedule reports and then allow the parameters to automatically amended. for example : each month the start and end date gets amended automatically via a calculation or preset parameters or another method.
Is this possible ? many thanks
Many thanks
zahed
Sims786 (BOB member since 2006-04-04)
MarkP
September 20, 2016, 3:18pm
#2
What are you looking at with your start and end date?
Are you looking at relative dates?
If so, create relative dates in your universe and then use them within your query conditions rather than actual dates or prompts.
system
September 20, 2016, 10:02pm
#3
Hi
I am primarily looking to run it on preset dates based on a calender so it would last day of the month. So I would look to use Report run date.
How would I do this. Would I create a Today dimension which would feed into the Report itself…
Many thanks
Zahed
Sims786 (BOB member since 2006-04-04)
MarkP
September 21, 2016, 11:36am
#4
Have a look at this topic:
As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server.
Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8.
Yesterday
cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime)
Today
cast(convert(char(10),getdate(),23) as datetime)
The following also works for today:
dateadd(dd, datediff(dd,0,getdate()), 0)
Start of Current Month
cast(convert(char(7),getdate(),23)+'-01' as datetime)
End of Current Month
dateadd(d,-1…
It explains how to create these objects. You can then use them in query conditions instead of prompts or hard-coded dates.