Skip to Main Content

Fiscal year in Hyperion

User_4RWFCAug 9 2019 — edited Aug 9 2019

Hi team,

In our application, we have calendar year at the moment and we need to add fiscal year(Apr till Mar) as well.

What will be the best option to proceed with this ?

Option 1 : Create Dynamic Calc  and Store members in store members in period dimension with formulas, So will have only (19) members

FY - YearTotal,FY -
HF1,
FY -

Q1,
FY -


Jan,
FY -


Feb,
FY -


Mar,
FY -

Q2,
FY -


Apr,
FY -


May,
FY -


Jun,
FY -
HF2,
FY -

Q3,
FY -


Jul,
FY -


Aug,
FY -


Sep,
FY -

Q4,
FY -


Oct,
FY -


Nov,
FY -


Dec,

Option 2: Create  Dynamic calc members with formulas, but the members in period dimensions will increase.

What will be the best way to handle this? or any other approach please ? Thanks

Regards

BV

Comments