dbTalk Databases Forums  

how to list ALL cubes (processed and not) using ADOMD.NET?

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


Discuss how to list ALL cubes (processed and not) using ADOMD.NET? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default how to list ALL cubes (processed and not) using ADOMD.NET? - 11-11-2004 , 03:31 PM






Hi,

I want to display the list of cubes and their status.
but I've only the list of processed cubes!
non-processed doesn't appeared.

does it possible in ADOMD.NET?

thanks.

Jerome.



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

Default Re: how to list ALL cubes (processed and not) using ADOMD.NET? - 11-11-2004 , 03:37 PM






For unprocessed cubes, you need to use DSO (the administrative API for
SSAS).
The query interfaces (ADOMD.NET, ADOMD, schema rowsets, etc.) only expose
those objects which you can actually query :-)
--
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.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Quote:
Hi,

I want to display the list of cubes and their status.
but I've only the list of processed cubes!
non-processed doesn't appeared.

does it possible in ADOMD.NET?

thanks.

Jerome.





Reply With Quote
  #3  
Old   
Jéjé
 
Posts: n/a

Default Re: how to list ALL cubes (processed and not) using ADOMD.NET? - 11-11-2004 , 03:52 PM



ok
thanks.


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Quote:
For unprocessed cubes, you need to use DSO (the administrative API for
SSAS).
The query interfaces (ADOMD.NET, ADOMD, schema rowsets, etc.) only expose
those objects which you can actually query :-)
--
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.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:uIrw%23VDyEHA.2348 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi,

I want to display the list of cubes and their status.
but I've only the list of processed cubes!
non-processed doesn't appeared.

does it possible in ADOMD.NET?

thanks.

Jerome.







Reply With Quote
  #4  
Old   
Jéjé
 
Posts: n/a

Default Re: how to list ALL cubes (processed and not) using ADOMD.NET? - 11-14-2004 , 02:14 PM



just a new question, does the DSO apply the user security to display only
authorized cubes?

to make sure that the user see only the status of its accessibles cubes.

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> a écrit dans le
message de news: uYMNdaDyEHA.2804 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
Quote:
For unprocessed cubes, you need to use DSO (the administrative API for
SSAS).
The query interfaces (ADOMD.NET, ADOMD, schema rowsets, etc.) only expose
those objects which you can actually query :-)
--
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.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:uIrw%23VDyEHA.2348 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi,

I want to display the list of cubes and their status.
but I've only the list of processed cubes!
non-processed doesn't appeared.

does it possible in ADOMD.NET?

thanks.

Jerome.







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

Default Re: how to list ALL cubes (processed and not) using ADOMD.NET? - 11-16-2004 , 12:45 AM



DSO can only be used by an OLAP administrator -- and as an OLAP
administrator they can see all cubes.
--
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.

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

Quote:
just a new question, does the DSO apply the user security to display only
authorized cubes?

to make sure that the user see only the status of its accessibles cubes.

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> a écrit dans le
message de news: uYMNdaDyEHA.2804 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
For unprocessed cubes, you need to use DSO (the administrative API for
SSAS).
The query interfaces (ADOMD.NET, ADOMD, schema rowsets, etc.) only
expose
those objects which you can actually query :-)
--
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.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:uIrw%23VDyEHA.2348 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi,

I want to display the list of cubes and their status.
but I've only the list of processed cubes!
non-processed doesn't appeared.

does it possible in ADOMD.NET?

thanks.

Jerome.









Reply With Quote
  #6  
Old   
Jéjé
 
Posts: n/a

Default Re: how to list ALL cubes (processed and not) using ADOMD.NET? - 11-16-2004 , 07:27 AM



ok
thanks.

so... I'll keep ADOMD.Net and my users will see only processed cubes.


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Quote:
DSO can only be used by an OLAP administrator -- and as an OLAP
administrator they can see all cubes.
--
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.

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote in message
news:eTA0IZoyEHA.2572 (AT) tk2msftngp13 (DOT) phx.gbl...
just a new question, does the DSO apply the user security to display only
authorized cubes?

to make sure that the user see only the status of its accessibles cubes.

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> a écrit dans le
message de news: uYMNdaDyEHA.2804 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
For unprocessed cubes, you need to use DSO (the administrative API for
SSAS).
The query interfaces (ADOMD.NET, ADOMD, schema rowsets, etc.) only
expose
those objects which you can actually query :-)
--
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.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:uIrw%23VDyEHA.2348 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi,

I want to display the list of cubes and their status.
but I've only the list of processed cubes!
non-processed doesn't appeared.

does it possible in ADOMD.NET?

thanks.

Jerome.











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.