dbTalk Databases Forums  

MDX query without total....

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap MDX query without total....

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


Discuss MDX query without total.... in the microsoft.public.sqlserver.olap forum.



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

Default MDX query without total.... - 04-20-2005 , 02:01 AM





If I have a dimension with [All] and I want to query that cube with that
dimension without it returning the [All] values... can that be done in MDX
without me having to disable the All property for that dimension?

I'm trying not to retrieve the aggregated All values...



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

Default Re: MDX query without total.... - 04-20-2005 , 02:20 AM





anyway... i found out that the Extract function does it... thanks anyway


"Nestor" <n3570r (AT) yahoo (DOT) com> wrote

Quote:
If I have a dimension with [All] and I want to query that cube with that
dimension without it returning the [All] values... can that be done in MDX
without me having to disable the All property for that dimension?

I'm trying not to retrieve the aggregated All values...



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top