Share via

Approaches to create dynamic partition & process without using SSIS its possible.?

bhavani uppala 1 Reputation point
2021-07-01T10:13:34.117+00:00

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

SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,826 Reputation points
    2021-07-02T09:56:31.513+00:00

    Though I have not known much like this sceen, can't say there isn't, but may I know why SSIS is not a choice for you environment ?

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.