reply urgent please

[#1]

Hi ...Can any one help me this ....Actually i have a dimension FiscalWeek (please find the below attachment for better understand) consisting data 1,2,3,4,5....but my issue is i need to disply it like W1 For the 1st week ,W2 For the 2nd week ,W3 For the 3rd week........please help me this.

[vikasmahajan]

Find Solution

vikas

[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

[#4]

Hi Anand...i am not getting the result

please what i want to show is ...just go throuh the attache qvd load that and select the FiscalWeek in that we will get the data like 1,2,3,4,5..

rather than that i want to show for the 1st week W1 ,for the 2nd week W2.... it is possible pls let me know...

[calvindk]

Just do

='W' & FiscalWeek

or in script

'W' & FiscalWeek as WFiscalWeek

[er_mohit]

you only have to write in dimension where your fiscalWeek value comes

'W' & FiscalWeek

or if you want to create fiscal Week in backend then try this in edit script

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

here TempDate is my Date Field

hope it helps you

[#7]

If i use that means will get the result like W1,W2,W3,W4......................W50,W51......just W will add to all right , but my case is for the 1st week W1 and for the second week W2....like that , need to reduce the data...please give me helpful answer

[#8]

I tried this but getting error while reloading the script...like TempDate is nt found ..and in charts itself data is not coming , please check my attached qvd and let me know how to do it ...

[er_mohit]

hiii

load your qvd then do it like mine only field  does not change anything

only this' 'W' &  FiscalWeek as FiscalWeek'

  try this

LOAD Day,

     CalendarWeek,

   'W' &  FiscalWeek as FiscalWeek,

     Month,

     CalendarQuarter,

     FiscalQuarter,

     CalendarYear,

     FiscalYear

FROM

C:\Users\Mohit\Downloads\DimDate.QVD

(qvd);

[anandathome]

Hi Shobha,

      this is what you are exactly looking for, I guess. If there is any other requirement combined with this please tell us.

When you say first week, we understand that it is the first week of financial year.

OR

If you could explain your actual requirement with example, people here may be able to help in right direction