|
Home > Archive > MS SQL Server OLAP > September 2005 > Dynamic Dimension Security not applied when running DTS package as a job
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Dynamic Dimension Security not applied when running DTS package as a job
|
|
| vulcano 2005-09-23, 7:23 am |
|
I implemented the dynamic dimension security using the virtual cube
approach( cube A + security cube B combined in virtual cube C)
I've made a DTS package with 2 Analysis Services Processing Task:
- one task makes an incremental update of the dimension with the
dynamic security
- the other one process the virtual cube
The system runs with MS SQL SERVER 2000 (SP4) and MS Analysis
Services 2000 (SP4).
If I run the DTS package and then try to connect to the virtual cube
with MS Excel, works fine.
If I run a job that was created from the DTS package and try to
connect to the virtual cube with MS Excel, it doesn't work; the dynamic
dimension security is not applied.
I want to be able to run a job that applies the dynamic security. Can
anybody help me?
If you want more detail information please let me know.
| |
| Darren Gosbell 2005-09-26, 3:23 am |
| Are you saying that when the DTS package is launched from a scheduled
job that it does not work?
Check the SQL Agent logs - are you sure the job ran and completed?
Check that the account that the SQL Agent is running under is a part of
the OLAP Administrators group - otherwise it will not have permission to
do any OLAP processing. (when you run the DTS package manually it is
running under your user account - when you run it as a job it runs under
the SQL Agent's user account)
--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1127468590.798201.115220@o13g2000cwo.googlegroups.com>,
cristianbadet@yahoo.com says...
>
> I implemented the dynamic dimension security using the virtual cube
> approach( cube A + security cube B combined in virtual cube C)
> I've made a DTS package with 2 Analysis Services Processing Task:
> - one task makes an incremental update of the dimension with the
> dynamic security
> - the other one process the virtual cube
>
> The system runs with MS SQL SERVER 2000 (SP4) and MS Analysis
> Services 2000 (SP4).
>
> If I run the DTS package and then try to connect to the virtual cube
> with MS Excel, works fine.
>
> If I run a job that was created from the DTS package and try to
> connect to the virtual cube with MS Excel, it doesn't work; the dynamic
> dimension security is not applied.
>
> I want to be able to run a job that applies the dynamic security. Can
> anybody help me?
>
> If you want more detail information please let me know.
>
>
|
|
|
|
|