| Author |
Refresh data via a SQL stored procedure
|
|
|
| Is it possible to refresh cube data via a stored procedure in SQL Server.
I wish to create a procedure that uses the xp_readmail command so that users
can send SQL a refresh request mail message that will refresh the cube data
(mainly following writeback data changes). At present users have to wait
for the job to run on it's scheduled time.
If such is possible, I would be grateful for the syntax as books online do
not seem to cover this aspect.
Regards
Daz
| |
|
| You could make a DTS that has an Analysis task in it. Then you would need to
run that DTS from sp or run a job that calls DTS.
MC
"Dazza" <Post2Group@Only.com> wrote in message
news:eBFk$HN9FHA.1248@TK2MSFTNGP14.phx.gbl...
> Is it possible to refresh cube data via a stored procedure in SQL Server.
>
> I wish to create a procedure that uses the xp_readmail command so that
> users can send SQL a refresh request mail message that will refresh the
> cube data (mainly following writeback data changes). At present users
> have to wait for the job to run on it's scheduled time.
>
> If such is possible, I would be grateful for the syntax as books online do
> not seem to cover this aspect.
>
> Regards
> Daz
>
| |
|
| I have considered this but there are practicle issues. We have many cubes
that will then require multiple jobs/DTS packages to be created. This is my
main reason asking for syntax in SQL
"MC" <marko_culo#@#yahoo#.#com#> wrote in message
news:%23PVldHO9FHA.1188@TK2MSFTNGP12.phx.gbl...
> You could make a DTS that has an Analysis task in it. Then you would need
> to run that DTS from sp or run a job that calls DTS.
>
> MC
>
> "Dazza" <Post2Group@Only.com> wrote in message
> news:eBFk$HN9FHA.1248@TK2MSFTNGP14.phx.gbl...
>
>
| |
|
| Did you try setting dynamic property task? Then you supply cube/database
name to dts. I've never tried this particular case but I dont see why it
wouldnt work. In this case you would have one dts that refreshes data on the
database/cube you tell it to refresh. Is this something that could help you?
MC
"Dazza" <Post2Group@Only.com> wrote in message
news:OUK32BP9FHA.808@TK2MSFTNGP09.phx.gbl...
>I have considered this but there are practicle issues. We have many cubes
>that will then require multiple jobs/DTS packages to be created. This is
>my main reason asking for syntax in SQL
>
>
> "MC" <marko_culo#@#yahoo#.#com#> wrote in message
> news:%23PVldHO9FHA.1188@TK2MSFTNGP12.phx.gbl...
>
>
| |
|
| Sound like a promising idea. I will give it a try.
many thanks
Daz
"MC" <marko_culo#@#yahoo#.#com#> wrote in message
news:OiGftNP9FHA.1248@TK2MSFTNGP14.phx.gbl...
> Did you try setting dynamic property task? Then you supply cube/database
> name to dts. I've never tried this particular case but I dont see why it
> wouldnt work. In this case you would have one dts that refreshes data on
> the database/cube you tell it to refresh. Is this something that could
> help you?
>
>
> MC
>
>
> "Dazza" <Post2Group@Only.com> wrote in message
> news:OUK32BP9FHA.808@TK2MSFTNGP09.phx.gbl...
>
>
|
|
|
|