Automate Making an Offline copy of Cube for Static Distribution

Ismail Cassiem 226 Reputation points
2021-06-21T11:25:10.927+00:00

Good day,

I need help please, i have a cube that i smiluate to offline version using MDX to a static file.

its tough keeping the cube and file in sync, is there no way to automate taking the cube offline for the stic file via ssis or powershell etc?

regards

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.
1,242 questions
0 comments No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-06-22T06:53:34.76+00:00

    Hi,

    I think for this we can use Invoke-ASCmd in Powershell, to run a CREATE GLOBAL CUBE MDX code in order to create a local cube.

    I am not good at powershell, but I think it should be possible to use powershell to run this daily and delete/archive the old local cube.

    I found no existing code, you may need to work a little bit yourself here or seek help from some PowerShell experts.

    Regards,
    Lukas

    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Ismail Cassiem 226 Reputation points
    2021-06-22T16:42:41.98+00:00

    Thank You very much, i will give a try:)

    0 comments No comments

  2. Lukas Yu -MSFT 5,816 Reputation points
    2021-06-28T02:17:53.19+00:00

    Hi,

    Did you make any success of this ? Any follow up could be shared?

    0 comments No comments

  3. Ismail Cassiem 226 Reputation points
    2021-06-28T08:09:50.44+00:00

    Hi,

    Unfortunately not, with no examples its difficult to replicate.

    I will continue with the old method of mdx :(

    thank you

    0 comments No comments