Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Parallel period on retail 445 calendar

Reply
Occasional Contributor
Posts: 6

Parallel period on retail 445 calendar

Dear all,
Our client needs a VA report with the actual sales and previous year sales based on retail 445 calendar.
He needs to see monday's (4.01.2014) sales (first day of week 1, 2016) in parallel with monday's ( 5.01.2015) sales (first day of week 1, 2015), and so on.
And all must be aggregate on a hierarchy made of Retail Year/Retail month/Retail week/Day of week(Date) . We have build a calendar tabel that have for each day the retail year, retail month, week of the year and the corresponding date of previous year.
Is there any way of calculating previous year sales using ParallelPeriod function or a self join or another formula on frontend? Or the only possibility to give him this numbers is to build the fact table with previous year sales precalculated?
Thank you in advance,

Adelaida

SAS Super FREQ
Posts: 275

Re: Parallel period on retail 445 calendar

Hi Adelaida,

 

The ParallelPeriod operator only uses a standard calendar year (or quarter or month).

 

Possibly in a future release we could add support for more types of time periods. The development team is looking into it.

 

Thanks,

Sam

 

Post a Question
Discussion Stats
  • 1 reply
  • 174 views
  • 0 likes
  • 2 in conversation