Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 help with mdx

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-01-12 : 05:35:30
how i convert it to mdx?

SELECT Count(DISTINCT CustomerNumber)
FROM FACT
GROUP BY YEAR

thanks

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-12 : 06:14:15
This is a cross post (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117616), please post in one forum only and the moderators will move it if necessery.

What do you mean by converting to mdx?

- Lumbago
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-01-12 : 06:24:04
ok,sorry i dont know that is cross post

how i write this as calculated member?
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-12 : 07:13:24
If you need help with something you need to explain your problem a little further. I have no idea whatsoever what you want to know.

Please read this:
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

- Lumbago
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-01-12 : 07:50:47

Lumbago
here the discussion
[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117616[/url]

Go to Top of Page
   

- Advertisement -