External Data Cube Refresh

Greetings,

Has anyone come up with a way to refresh a data cube externally? Like from a SQL Server Agent job?

Cheers,

Mark

Hi Mark,

You can refresh a cube by doing a REST call to the cube object. By looking at the network trace, Dundas BI does a call like this:

The circled area is the GUID of my data cube.

An easy way to do this might be to create a PowerShell script to emulates the REST calls being made to Dundas BI. The network tab in the chrome debugger should give you everything that you need and can even create PowerShell scripts.

Thanks Jeff! I’ll post if/when I get it working.

Here’s the API docs for that REST call: https://www.dundas.com/support/api-docs/rest/#Dundas%20BI%20REST%20API%20Reference/DataCube/Warehouse/{id}/POST.html%3FTocPath%3DDundas%20BI%20REST%20API%20Reference|DataCube|_____29

Or via python and pydundas: https://pypi.org/project/pydundas/

Hi all,

I stumbled upon this topic and was wondering, has anyone been able to externally refresh using C#? If so do you have any example script you can share?

Thanks!

@patrick Hi Patrick, there are no example scripts, but as previous posters mentioned, you can make a Rest API call to build the warehouse storage. Please note in the new version there are changes in the api, warehouse storage build is now using POST /DataCube/BuildStorage/{id}/
https://www.dundas.com/support/api-docs/rest/#Dundas%20BI%20REST%20API%20Reference/DataCube/BuildStorage/{id}/POST.html%3FTocPath%3DDundas%20BI%20REST%20API%20Reference|DataCube|_____4