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