dbTalk Databases Forums  

Virtual cube roles

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Virtual cube roles in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AndyM
 
Posts: n/a

Default Virtual cube roles - 06-10-2005 , 09:53 AM






Dave Wickert (MSFT) documented a known issue in 2003 where virtual cubes
would not provide correct access when used with dimension security unless
they were processed after processing physical cubes on which they were based.
Does this problem still exist. Is there any more information available on
this topic. If it is fixed, is the fix in an SP.

I have seen problems with virtual cubes this week that would suggest that
this problem can stil occur.

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Virtual cube roles - 06-10-2005 , 06:50 PM






I made that observation post-SP3. It was supposed to be fixed in SP4.
I have had the opportunity to verify it.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"AndyM" <AndyM (AT) discussions (DOT) microsoft.com> wrote

Quote:
Dave Wickert (MSFT) documented a known issue in 2003 where virtual cubes
would not provide correct access when used with dimension security unless
they were processed after processing physical cubes on which they were
based.
Does this problem still exist. Is there any more information available on
this topic. If it is fixed, is the fix in an SP.

I have seen problems with virtual cubes this week that would suggest that
this problem can stil occur.



Reply With Quote
  #3  
Old   
AndyM
 
Posts: n/a

Default Re: Virtual cube roles - 06-13-2005 , 02:47 AM



Dave,

Interestingly we have just one server that moved up to SP4 recently to try
and deal with another "fixed" issue. This server is the only one (others on
SP3) that exhibits this behavior. Rather than fixing it it looks to have made
things worse.

I note in your original post you referred to a type of processing you called
processSecurity. Is this an undocumented option or a name given to one of the
usual options?

"Dave Wickert [MSFT]" wrote:

Quote:
I made that observation post-SP3. It was supposed to be fixed in SP4.
I have had the opportunity to verify it.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"AndyM" <AndyM (AT) discussions (DOT) microsoft.com> wrote in message
news:2EF07EAD-BDE5-4BCF-8A33-0540566D43EB (AT) microsoft (DOT) com...
Dave Wickert (MSFT) documented a known issue in 2003 where virtual cubes
would not provide correct access when used with dimension security unless
they were processed after processing physical cubes on which they were
based.
Does this problem still exist. Is there any more information available on
this topic. If it is fixed, is the fix in an SP.

I have seen problems with virtual cubes this week that would suggest that
this problem can stil occur.




Reply With Quote
  #4  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Virtual cube roles - 06-13-2005 , 11:44 AM



I would raise this issue with PSS.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"AndyM" <AndyM (AT) discussions (DOT) microsoft.com> wrote

Quote:
Dave,

Interestingly we have just one server that moved up to SP4 recently to try
and deal with another "fixed" issue. This server is the only one (others
on
SP3) that exhibits this behavior. Rather than fixing it it looks to have
made
things worse.

I note in your original post you referred to a type of processing you
called
processSecurity. Is this an undocumented option or a name given to one of
the
usual options?

"Dave Wickert [MSFT]" wrote:

I made that observation post-SP3. It was supposed to be fixed in SP4.
I have had the opportunity to verify it.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.


"AndyM" <AndyM (AT) discussions (DOT) microsoft.com> wrote in message
news:2EF07EAD-BDE5-4BCF-8A33-0540566D43EB (AT) microsoft (DOT) com...
Dave Wickert (MSFT) documented a known issue in 2003 where virtual
cubes
would not provide correct access when used with dimension security
unless
they were processed after processing physical cubes on which they were
based.
Does this problem still exist. Is there any more information available
on
this topic. If it is fixed, is the fix in an SP.

I have seen problems with virtual cubes this week that would suggest
that
this problem can stil occur.






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.