please need urgent reply

[#1]

Hi..Can any one help me this issue....Actually i have a dimensions Fiscal year(2010,2011,2012,....) , Fiscal Quarter(Q1,Q2,Q3,Q4,...) ,Fiscal Month (Jan,Feb,March,...) but my case is by using any of those i need to show Fiscal Week like (W1,W2,W3,W4...)...Is it possible....

[er_mohit]

Try this

'W' & Ceil(Week(TempDate)/8) as Fiscalweek

TempDate is my date field

[#3]

where i have to give this condition...

[er_mohit]

in script level where your other fields you make like for fiscal year,and for month there you write this

and you will get fiscalweek fieldname when reload your data

you have to write this in your edit script  for short cut press ctrl+E

where you mentioned your date field there you put this code make sure you chanfe the date field

hope it helps

[#5]

hi ..i am nt getting exact result please find the below attachment , i am sending the dimdate qvd go through that once let me know how to get that exact result like FiscalWeek data should be like W1(for the 1st week),W2(for the second week),W3(for the 3rd week)......please

Regards,

X.

[anandathome]

Hi Shobha,

     Please attache the qvd.

-Anand.

[#7]

  Hi..this the script i have for the dim date

LOAD

Day,
CalendarWeek,
FiscalWeek,
Month,
CalendarQuarter,
FiscalQuarter,
CalendarYear,
FiscalYear
FROM

(qvd

);

[anandathome]

I am assuming that you have one FullDate column in your calendar/date dimension.

Use the below LOAD script

LOAD

Day,

CalendarWeek,

FiscalWeek,

Month,

CalendarQuarter,

FiscalQuarter,

CalendarYear,

FiscalYear,

'W' & Week(Date(FullDate,'YYYY-MM-DD')) as WeekNo1,

'W' & If((Week(Date(FullDate,'YYYY-MM-DD')) - (Week(Date('2013-04-01'))-1))>0,(Week(Date(DOCDATE,'YYYY-MM-DD')) - (Week(Date('2013-04-01'))-1)),52+(Week(Date(DOCDATE,'YYYY-MM-DD')) - (Week(Date('2013-04-01'))-1))) as WeekNo2

FROM

(qvd

);

Note: WeekNo1 is when your calendar year and fiscal year are same.

WeekNo2 is when your fiscal year starts on 1st April.

Let me know in case of any issue.

-Anand