Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Filters in OBIEE

UOOLKNov 21 2011 — edited Nov 21 2011
I am trying to achieve this in _oracle BI 10g Answers_
we have Columns :
Registration date -Regd
Week ( 1,2,3.....52)
week commencing ( the start date of every week)
No of Customers

i want to know the count or total of new customers by week which would be where registration date is between the start and end date of the week. but we only have start date of the week and also that i am not able to use it in the filter .

any ideas of how to do it??

Edited by: UOOLK on 21-Nov-2011 06:56

Edited by: UOOLK on 21-Nov-2011 08:56
This post has been answered by MKKrishna on Nov 21 2011
Jump to Answer

Comments

Rookie_86
Make use of Date Dimension Table - and join with the fact table.
MKKrishna
Answer
to get end date create a logical column using
Timestampadd(sql_tsi_day,7,start_date) you will get week end date.. Use it

Your question is not clear though..
Marked as Answer by UOOLK · Sep 27 2020
868910
Use 'is between'
1 - 3
Locked Post
New comments cannot be posted to this locked post.