dbTalk Databases Forums  

Browsing dimension data not associated with a cube...

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


Discuss Browsing dimension data not associated with a cube... in the microsoft.public.sqlserver.olap forum.



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

Default Browsing dimension data not associated with a cube... - 08-25-2003 , 03:06 PM






Is there any MDX syntax that will allow me to browse a
dimensions data without having to build a cube for the
dimension? I'm looking for functionality similar to what
you get in Analysis Manager when you browse a dimensions
data in the Dimension Editor.

Thanks in advance.
Chris Smith

Reply With Quote
  #2  
Old   
Irina Gorbach
 
Posts: n/a

Default Re: Browsing dimension data not associated with a cube... - 08-26-2003 , 12:59 AM






Hello Chris,
Unfortunatly there is no syntax to browse a dimension in the current version
of Analysis Services. Analysis Manager has pretty complex code, that bulds
local cube with single dimension based on the real dimension and setting
connection string property to generate Sample data.

Hope this helps,
Irina

This posting is provided "AS IS" with no warranties, and confers no rights.
-----------------------------------------------------------------

"Chris Smith" <csmith (AT) huttig (DOT) com> wrote

Quote:
Is there any MDX syntax that will allow me to browse a
dimensions data without having to build a cube for the
dimension? I'm looking for functionality similar to what
you get in Analysis Manager when you browse a dimensions
data in the Dimension Editor.

Thanks in advance.
Chris Smith



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.