Looking for some advice here.

I am creating a KPI database which is reported on daily.

For each day we have a MTD & then a YTD.

I have set up 4 dimensions as below

KPI Indicators

Days

Months

Years

Now for the crucial bit. Some of the KPI Indicators are volumes so I can use consilidation & the others are average percentages. I presume I will have to use rules for these.

Is this correct ?

Is there a simple way of creating the rule or will I have to add each day from 1 to 31 ?

Given that I have about 35% of the KPI indicators as % will all these rules slow everything down.

Any advice / help would be greatly appreciated.