question

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 asked IsmailCassiem-3967 answered

Automate Making an Offline copy of Cube for Static Distribution

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

Hi,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 answered

Hi,

Unfortunately not, with no examples its difficult to replicate.

I will continue with the old method of mdx :(

thank you

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.