Essbase calculation

Summary

Essbase calculation

Content

We are loading the data into Essbase cubes via rule file with SQL table. Data will be available from starting from Jan 2017 to till date and there is one calc script aggregating entire year even we declared SV for currentperid and current year is Pd11 and FY11. user requirment is only aggregate current period for 2017.(Meaning PD11).

Current period is as dense dimension. year is sparse dimension. as i understand when we use period in fix it will be performance impact. Pls help on this

my calc script is

SET AGGMISSG ON;

SET UPDATECALC OFF;

SET CALCPARALLEL 8;