dbTalk Databases Forums  

Excel Pivottable connecting to OLAP cubes

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


Discuss Excel Pivottable connecting to OLAP cubes in the microsoft.public.sqlserver.olap forum.



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

Default Excel Pivottable connecting to OLAP cubes - 06-06-2006 , 07:51 PM






Does anyone know how to hide the other cubes in the cubes selection?
I created a virtual cube and only want that to be visible in the cube
selection.

I created a cube role and only gave access to the VC but they can still see
the other cubes in the list.

Reply With Quote
  #2  
Old   
Jeje
 
Posts: n/a

Default Re: Excel Pivottable connecting to OLAP cubes - 06-06-2006 , 07:56 PM






set the visibility option to false in the cubes.

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

Quote:
Does anyone know how to hide the other cubes in the cubes selection?
I created a virtual cube and only want that to be visible in the cube
selection.

I created a cube role and only gave access to the VC but they can still
see
the other cubes in the list.



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

Default Re: Excel Pivottable connecting to OLAP cubes - 06-06-2006 , 09:49 PM



Thanks

"Jeje" wrote:

Quote:
set the visibility option to false in the cubes.

"SAM" <SAM (AT) discussions (DOT) microsoft.com> wrote in message
news:26BA4598-BAF8-4233-8F77-368F6EE7DF70 (AT) microsoft (DOT) com...
Does anyone know how to hide the other cubes in the cubes selection?
I created a virtual cube and only want that to be visible in the cube
selection.

I created a cube role and only gave access to the VC but they can still
see
the other cubes in the list.




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.