BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: No events within the next 45 days.

Data 6 months prior to current date


 
Search this topic... | Search WebIntelligence XI... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Author Message
bvolles00
Forum Member
Forum Member



Joined: 26 Jun 2013

Posts: 8



PostPosted: Fri Jul 05, 2013 11:04 am 
Post subject: Data 6 months prior to current date

Hello all,
I am trying to retrieve data 6 months prior to the current date. I have read through the date section on here and attempted to use that however I am returned a error. I am quering on iseries.
Back to top
praveenmaddi
Principal Member
Principal Member



Joined: 10 May 2011

Posts: 267



PostPosted: Fri Jul 05, 2013 1:51 pm 
Post subject: Re: Data 6 months prior to current date

Can you tell what you have tried? Where you have tried ( universe or report level)? What BO version you are using?
Back to top
bvolles00
Forum Member
Forum Member



Joined: 26 Jun 2013

Posts: 8



PostPosted: Mon Jul 08, 2013 9:35 am 
Post subject: Re: Data 6 months prior to current date

I have tried all of this at the report level and I mainly have tried ="RelativeDate(CurrentDate();-180)" however it does not matter the number of days I use to subtract it returns the same data banghead.gif
Back to top
shivendrashukla
Forum Member
Forum Member



Joined: 28 Feb 2013

Posts: 4
Location: Sweden


flag
PostPosted: Tue Jul 09, 2013 7:41 am 
Post subject: Re: Data 6 months prior to current date

You just create a variable at report level with formula as follows:

=(MonthNumberOfYear([your date dimension]) between ((MonthNumberOfYear(CurrentDate())-6);(MonthNumberOfYear(CurrentDate())-1)))And (Year([your date dimension])=Year(CurrentDate()))

This will give you values as 1 and 0. Then use this object as a block level filter for values equal to 1. This will give you values for last six months.

Note: As it is July now so it will give values from Jan to June. if you want values from Feb to July then you can modify above formula as per your need seeya.gif

I hope this will solve your issue.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0447 seconds using 17 queries. (SQL 0.0029 Parse 0.0347 Other 0.0072)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo