Hi,

I can't execue these cmsds in our database since I don't have rights to do that. I was talking about the Cognos Reports where I have to implement this logic...

Hi,

I didn't get any response to my reply? do any one need mpre details?

Thanks

Gopi

Hi,

If I give you starting 5 to 10 rows of the merchandise week table stmts is that enough to test?

Something like below.........

insert into dbo.T_AGGR_MERCHANDISING_WEEK_DIM(MERCHANDISING_WEEK_DIM_ID,MERCHANDISING_WEEK,MERCHANDISING_YEAR,

MERCHANDISING_WEEK_START_DATE,MERCHANDISING_WEEK_END_DATE)

values (186,'wk27',2012,2012-07-01 00:00:00:000,2012-07-07 00:00:00:000),

values (187,'wk28',2012,2012-07-08 00:00:00:000,2012-07-14...

Hi,

Thanks for the details but I don't have access to run these commands in our db. I can access from report end....

Means I need to use whatever tables already there...

Hi,

Here is the merchandise week table structure details from our database

create table dbo.T_AGGR_MERCHANDISING_WEEK_DIM

(MERCHANDISING_WEEK_DIM_ID pk,int,not null,

MERCHANDISING_WEEK char(4),not null,

MERCHANDISING_YEAR char(4), not null

MERCHANDISING_WEEK_START_DATE datetime,not null

MERCHANDISING_WEEK_END_DATE datetime,not null)

PFA doc for the values for above...

Hi,

I have merchandise week table in my package which contains week values wk1,wk2,wk3.....upto wk53 per year.

So using this i need to display current week as 0, for any season like...

Hi,

PFA doc of my report requirement.

Thanks

Gopi

Hi,

I have week number in my table its displaying value as wk1,wk2,wk3.....like that.......

So is it possible to write sql function by using this column on order to display current week...

Hi,

If you consider zero as current week in then i should get previous 0 weeks like -9,-8,-7,-6 and the next 6 weeks from 0 like below .......

2012404142434445464748495051525312

Oct-12Nov-2012Dec-2012Jan-2013

-9-8-7-6-5-4-3-2-10123456

Please help me to...

Hi,

If I have weekstartdate & enddate, week column in my table......can any one tell me how to write sql to display curren week number, previous 9 weeks & next 6...

Hi,

I agree if you don't know cognos......but you can help me writing SQL right.....becasue I need to use sql or any function which validates with the requirement.........then only cognos tool....comes......

I...

Hi,

My report is cross tab & uses relational modelling now tel me how can I get the required week numbers in my cross tab report based on the season which...

Hi,

Then also same error QE-DEF-0459 CCLException pasing error before or near expression....

PFA error.

Thanks

Gopi

Hi,

If I use your function in my report with below expression I am getting parsing error.

datepart(MERCHANDISING_WEEK,getdate())

Thanks

Gopi

Hi,

Can you help me in getting query to display current week number, previous 9 weeks & next 6 weeks for a year......

I have report requirent to display like current week...