Forecast Issue for date and Months

[Anil_Babu_Samineni]

Helo Friends,

I have the Data following in excel. So, here i want to create whole data for each month.

Let' assume

2014 - i have Months Jan, Feb, Mar, June -- Here, I want to add left of months i.e., Apr, May, July, Aug, Sep, Oct, Nov with all dates

2015 - Same

2016 - Should be up to to till date

For ref, Please find attachment of my excel

If i select 2014 i want to show 52 weeks same as 2015 and same as 2016 (But 2016 - I want to associate with only 27 weeks and left of 25 weeks should be hidden - Un associated with grey color)

[Anil_Babu_Samineni]

Max,

Not working. Here, Which field name i need to use for future calendar wither Quarters and all,

I need to use Date / S_CREATED_DATE?

- ANIL

[PrashantSangle · Accepted solution]

Hi,

create association between S_CREATED_DATE and date from master Calendar.

and use date, Quarter,Week from master Calendar.

Please find below test script for your reference.

Facts:

LOAD Num(Floor(S_CREATED_DATE)) as Num_date,

S_CREATED_DATE

FROM

S_Created_Date.xls

(biff, embedded labels, table is Sheet1$);

MinMaxDate:

Load

  Num(Yearstart(Min(S_CREATED_DATE))) as MinDate,

  Num(Max(S_CREATED_DATE)) as MaxDate

  Resident Facts;

Let vMinDate = Peek('MinDate',0,'MinMaxDate');

Let vMaxDate = Peek('MaxDate',0,'MinMaxDate');

Drop Table MinMaxDate;

Temp_calendar:

load $(vMinDate) + RecNo()-1 as Date autogenerate $(vMaxDate)-$(vMinDate) +1;

Master_calender:

Load Num(Date) as Num_date

,MonthName(Date) as MonthYear,

Date(Date) as Date,

Year(Date) as Year,

Day(Date) as Day

Resident Temp_calendar;

drop Table Temp_calendar;

If it wont solve your requirement, then please explain your entire requirement.

Regards,

[Anil_Babu_Samineni]

Max, Thanks. got it. For future level shall i use the same field (S_CREATED_DATE).

If i take two list boxes one for S_CREATED_DATE and another one is Date

If i select Year - The dates are changes from Date field not for the S_CREATED_DATE

So, In future i need to take Date Field as the Date. NP, I got it.

Thanks Max.