Scenario is below:
I have SSAS multidimensional cube. Need to create partitions dynamically for each quarter and should process only current quarter data.
Gone through many searches can see using SSIS tool with using AMO or store procedures using different tasks inside SSIS.
Is there any other approach without using SSIS tool for dynamic partitions and process?
Any suggestions please.
Regards,
Bhavani