How to solve the matrix kind of scenarios with multiple Dimensions and KeyFigures.?.

Hello HANA Gurus,

Please explain me to how to achieve the following scenarios,

We are having 10-12 different dates dimenions like effective date, effective year, effective period, period/year and 10-15 calculated Key figures.. How to calculate the KF's with each the date dimension columns. Is therea way that we could able to achieve without doing the repititive calculation for each of the KF's with date dimensions?.

For eg,

Date Dimension 1 with KF 1

...... Date dimenion 1 with KF 10 and so on...

same way the loop continues. for different KF's with date dimension.

Appreciate your response.

Regards

Suresh