please need urgent reply

[#1]

Hi ...please help me this issue...Actually i have a dimension Fiscal week (please find below attachment) with data 1,2,3,4,5,6,7,......but in my case i need to show data like W1,W2,W3,W4...is this possible?

[kumarnatarajan]

Hi,

Just concate W string in your Fiscal week field

Ex: ='W'&Fiscal_week

[#3]

hi ..i am nt getting exact result please find the below attachment , i am sending the script for 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,

LOAD

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

(qvd

);