dbTalk Databases Forums  

help on count method in mdx

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


Discuss help on count method in mdx in the microsoft.public.sqlserver.olap forum.



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

Default help on count method in mdx - 07-07-2003 , 04:14 AM






hi i would like to use the count method with mdx to know how many data
there is in my cube. I haven't been able to do so.

Is it possible or os there an other way to do it?

if it is possible thanks to give me a clue to do it.

Lydie

Reply With Quote
  #2  
Old   
Marin Bezic [MSFT]
 
Posts: n/a

Default Re: help on count method in mdx - 07-07-2003 , 12:53 PM






Hi Lydie,

you can create a new measure in your cube, set its Source Column = 1, and
set its Aggregation Function to Count.

Marin Bezic

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.


"lydie" <lsoler (AT) caramail (DOT) com> wrote

Quote:
hi i would like to use the count method with mdx to know how many data
there is in my cube. I haven't been able to do so.

Is it possible or os there an other way to do it?

if it is possible thanks to give me a clue to do it.

Lydie



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.