Report weekly values

building reports webintelligence
1

Hi
Could some one advise me.
I have three columns Product, Value & Sell date the requirement is weekly(individual weeks in individual columns from 1st Jan 2010 to last week) Value by Product from Monday to Sunday
i.e:
Product–>Value --> Sell Date
AAAA---->101 ----->26/05/2010
BBBB---->120------>31/06/2010
CCCC—>130------>24/05/2010
AAAA—>101------->31/06/2010
AAAA—>101------->02/06/2010
DDDD—>140------>3/06/2010
BBBB—>120------->7/06/2010
AAAA---->101------->9/06/2010

The result should be:
Produst-> 07/06 To 13/06 --> 31/05 To 06/06 -->24/05 To 30/05
AAAA---->101-------------------------->201-------------->101
BBBB---->120-------------------------->120-------------->Nill
CCCC—>Nill ---- ---------------------->Nill--------------->130
DDDD—>Nill---------------------------->140--------------->Nill

Any assist would be appreciated.
Thanks
Megna

megna :uk: (BOB member since 2010-06-09)

2

Hi Megna ,

One of the best ways you can acieve this .

Cretae Universe Objects for the Current week , Current week -1 , Current week -2 .

For the formulas serach Designer forum .

and then use this objects in your report .

Regards
Sapan

swapnil_taz :india: (BOB member since 2006-04-06)

3

Hi
i am sorry for late respond, i was sick

i need current week and previews week sum of the sales value for that i have created like this to_char(sales.selldate, ‘Currentweek’) it parse is ok but to display the value giving error, Error during SQL execution, Exception: DBD, ORA-01821: date format not recognized
State: N/A
could some one assist me what i did wrong.
Thanks
Megna

megna :uk: (BOB member since 2010-06-09)

4

Hi

Trunc(sales.selldate,‘W’) will give you current week date and Trunc(sales.selldate,‘W’)-7 will give you last week date and so on…

Rajubollas :india: (BOB member since 2009-09-04)

5

Hi
i have created one object for current week Trunc(sales.selldate,‘W’)
getting dates like this. but only sum of value in current week
Produst-> 29/06 22/06 15/06 08/06 01/06
AAAA---->101---->201—>101
BBBB---->120---->120---->Nill
CCCC—>Nill ---->Nill----->130
DDDD—>Nill---->140----->Nill

Actual our requirement is sum of value(Customer Flow(CF))in current week where Customer <> null & sum of value(Trader Flow (TF)) in current week where Customer ==null and Total Value of current week

Same thing for last week also, sum of value(Customer Flow(CF)) in Last week where Customer <> null & sum of value(Trader Flow (TF)) in Last week where Customer ==null and Total Value of Last week

Week change: CF current week – CF Last week & TF current week – TF Last week and finally total value of week change.( (CF current week – CF Last week) + (TF current week – TF Last week))

We have table called Users in there 4 columns Item ID, Name, Type(customer & Trade) & country
And assist would be appreciated
Thanks
Megna

megna :uk: (BOB member since 2010-06-09)

6

Create 3 data providers/Queries for each week and link up them in report.

Rajubollas :india: (BOB member since 2009-09-04)