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

Financial Calendar

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Financial Calendar

Hi,

 

We have a financial year running from July to June, with 5,5,4 structure.

 

What can be done to manipulate this in SAS VA 7.3 using periodic functions.

 

Unless I hardcode rawdata, that is only way to enable year to date or if I use a list table to manipulate combined with parameters.

 

I would much rather prefer to have a table which should day, week, month, quarter, year to date and comparison to last year. This table needs to be manipulated with drop downs.

 

Is there is a very simple solution is SAS VA that I should be leveraging to resolve this issue. It almost seems like SAS VA can only deal with calendar year only !

 

Any help you can provide would be appreciated.

 

thks,

 

Sukh


Accepted Solutions
Solution
‎02-21-2017 12:17 PM
Super User
Posts: 1,208

Re: Financial Calendar

Hi Sukh,

 

Unfortunately the periodic calculations within the VA interface is only for calendar year. Discussions and requests to have this for financial year have been had in other threads, see below...

 

Period calculations in VA using Financial Year

I would like to know how to make a fiscal year

 

An alternative would be do use this finanical year calculations using SAS as part of your data preparation prior to loading into VA.

 

Kind Regards,

Michelle

View solution in original post


All Replies
Solution
‎02-21-2017 12:17 PM
Super User
Posts: 1,208

Re: Financial Calendar

Hi Sukh,

 

Unfortunately the periodic calculations within the VA interface is only for calendar year. Discussions and requests to have this for financial year have been had in other threads, see below...

 

Period calculations in VA using Financial Year

I would like to know how to make a fiscal year

 

An alternative would be do use this finanical year calculations using SAS as part of your data preparation prior to loading into VA.

 

Kind Regards,

Michelle

Occasional Contributor
Posts: 14

Re: Financial Calendar

Hi Michelle,

We did this as part of data preparation using SAS Office Analytics (Enterprise Guide). Had to code and partly aggregate. Hope there will be a better solution in long run which enables self service of less technical users.

thks,

Sukhbir
Super User
Posts: 1,208

Re: Financial Calendar

Thanks Sukhbir for posting what you did to achieve this.

 

Agree - hopefully there will be a built-in financial year capability in the future.

 

Kind Regards,

Michelle

SAS Super FREQ
Posts: 275

Re: Financial Calendar

Hi Sukhbir,

Support for fiscal year calendars has been one of the most highly-requested features for VA and we plan to offer it soon.

Thanks,
Sam
Frequent Contributor
Posts: 75

Re: Financial Calendar

Hi Sam,

 

Any details on that functionality? will it be flexible in order to supoprt other calndars such as academic year?

SAS Super FREQ
Posts: 275

Re: Financial Calendar

I can't make any promises about future planned features, but currently the plan is to allow you to start the year on any month, for the cumulativePeriod operator (which is used for YTD calculations.)

Occasional Contributor
Posts: 14

Re: Financial Calendar

Hi Sam,

Yes it needs to work with a 5,4,4 week accounting calendar. So 5 weeks for period 1, 4 weeks for period 2 and 4 weeks for period 3. Then again 5 weeks for period 4, 4 weeks for period 5 and 4 weeks for period 6 etc. etc. .

chrs,

Sukhbir
SAS Super FREQ
Posts: 275

Re: Financial Calendar

Hi Sukhbir,

I will have to check on the 5,4,4 calendar.

Thanks,
Sam
SAS Super FREQ
Posts: 275

Re: Financial Calendar

Support for 4-4-5 type calendars is currently being considered. Hopefully we can offer this in the future.
Post a Question
Discussion Stats
  • 9 replies
  • 256 views
  • 2 likes
  • 4 in conversation