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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

[Webi 4.x] first day of last quarter

Goto page 1, 2  Next
 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
businessuniverse
Forum Member
Forum Member



Joined: 12 Feb 2019

Posts: 12



PostPosted: Tue Feb 12, 2019 11:08 am 
Post subject: first day of last quarter

Hi
i am new to BO, Can some please help me how to calculate the firstday of the last quarter.

Example:
Current date: 2-12-2019
Last Quarter - Q4'2018
First day of Last Quarter: Oct-1st-2018

Which process in good to implement the changes?

universe or webi report?

Thank you in advance.
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14213
Location: England


flag
PostPosted: Tue Feb 12, 2019 12:57 pm 
Post subject: Re: first day of last quarter

Welcome to Bicon_mrgreen.gifB!
Universe is best...what database?
Back to top
businessuniverse
Forum Member
Forum Member



Joined: 12 Feb 2019

Posts: 12



PostPosted: Tue Feb 12, 2019 1:05 pm 
Post subject: Re: first day of last quarter

Hi

May i know why its not possible in WeBi ?

i created last quarter logic in report but how can i create the first day of last quarter, i am able to see only last day of month and last day of year.

can you please help me on this?

Thank yu
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14213
Location: England


flag
PostPosted: Tue Feb 12, 2019 2:20 pm 
Post subject: Re: first day of last quarter

It is possible in Webi, but you only have to do it once in the universe.
Back to top
businessuniverse
Forum Member
Forum Member



Joined: 12 Feb 2019

Posts: 12



PostPosted: Tue Feb 12, 2019 3:50 pm 
Post subject: Re: first day of last quarter

Hi

i am using hadoop database. can you please let me know the logic for that.

Thank you
Back to top
businessuniverse
Forum Member
Forum Member



Joined: 12 Feb 2019

Posts: 12



PostPosted: Tue Feb 12, 2019 9:31 pm 
Post subject: Re: first day of last quarter

HI

Can you please help with logic?

Thank you
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Wed Feb 13, 2019 3:30 am 
Post subject: Re: first day of last quarter

There we go, nice and messy but it should work. I've not got access to Webi to test it though:

Code:
=If(MonthNumberOfYear([Your Date]) >3; ToDate(Year([Your Date])*10000+((Floor(MonthNumberOfYear([Your Date])/3)-1)*3+1)*100+1;"yyyyMMdd");ToDate((Year([Your Date])-1)*10000+1001;"yyyyMMdd"))

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
businessuniverse
Forum Member
Forum Member



Joined: 12 Feb 2019

Posts: 12



PostPosted: Wed Feb 13, 2019 10:22 am 
Post subject: Re: first day of last quarter

Hi Mark,

Thank you very much for your help, but this logic is not working when i applied to report, formula is correct but results showing error, can you please check and let me know the other options.

Thank you very much for your time.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Wed Feb 13, 2019 10:38 am 
Post subject: Re: first day of last quarter

OK, let's take a step back. What are you trying to achieve?
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
businessuniverse
Forum Member
Forum Member



Joined: 12 Feb 2019

Posts: 12



PostPosted: Wed Feb 13, 2019 11:09 am 
Post subject: Re: first day of last quarter

Hi Mark,

My goal is to get first day of the previous quarter and there i have to get before 2 years data, please let me know if my question is not clear.

Thank you
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Wed Feb 13, 2019 11:31 am 
Post subject: Re: first day of last quarter

For example, if we're in 2019 Q1 now, what data do you need in terms of full quarters?
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
businessuniverse
Forum Member
Forum Member



Joined: 12 Feb 2019

Posts: 12



PostPosted: Wed Feb 13, 2019 11:37 am 
Post subject: Re: first day of last quarter

Hi

i need to get 2 years data from first day of previous quarter
Example:
Current date: 2-12-2019
Previous Quarter - Q4'2018
First day of Previous Quarter: Oct-1st-2018

before 2 years data
Oct-2016 to Oct-2018

Thank you in advance.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11364
Location: Manchester, UK


flag
PostPosted: Thu Feb 14, 2019 3:09 am 
Post subject: Re: first day of last quarter

So you want 8 quarters of data?

If so, does that include Oct 2018's quarter?

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
businessuniverse
Forum Member
Forum Member



Joined: 12 Feb 2019

Posts: 12



PostPosted: Thu Feb 14, 2019 10:18 am 
Post subject: Re: first day of last quarter

Hi Mark,

it should not include 2018, Q4 data..

Thank you
Back to top
businessuniverse
Forum Member
Forum Member



Joined: 12 Feb 2019

Posts: 12



PostPosted: Thu Feb 14, 2019 9:57 pm 
Post subject: Re: first day of last quarter

Hi Mark,

Can you please reply.

Thank you
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  Next
 
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.0333 seconds using 17 queries. (SQL 0.0039 Parse 0.0010 Other 0.0283)
CCBot/2.0 (https://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