How i can replace the sql query with mdx

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » How i can replace the sql query with mdx

How i can replace the sql query with mdx

Rate Topic

Display Mode

Topic Options

Author

Message

inampudianil

Posted Thursday, September 06, 2012 2:41 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:24 AM
Points: 55, Visits: 308

Hi

select *
FROM users where user_id not in (select user_id from emp where is_actv=1).

In this Users and Emp both are dimensions and they are have referntial integrity with userid.Could you please help me with MDX script

Thanks in advance
aa

Post #1355120

Henrico Bekker

Posted Thursday, September 06, 2012 2:48 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, June 10, 2013 11:15 PM
Points: 1,878, Visits: 2,704

Example:

select {[Measures].[Amount], [Measures].[Transaction Cost], [Measures].[Transaction Number]} ON COLUMNS,
{ ManualProcessing].[All ManualProcessings].[MANUAL]} ON ROWS
FROM [Transactions]
where
(
except([Product].[All Products].Children,{[Product].[All Products].[Debit}),
except([Set],[Set to exclude])
)

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #1355124

inampudianil

Posted Thursday, September 06, 2012 3:44 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:24 AM
Points: 55, Visits: 308

Hi

Thanks for your answer..based on ur query,i have written like this.

SELECT NON EMPTY { } ON COLUMNS,
NON EMPTY { ([PH_CUST].[CUST].ALLMEMBERS ) } ON ROWS
FROM Ad_CUBE
where except([PH_CUST].[Cust].Children,{[EMP].[PHWEB].[Activce].&[1]})

is it Correct thing i have done?

i am just tryng basic..please let me out..

Thanks in advance
aa

Post #1355161

Raunak Jhawar

Posted Monday, September 17, 2012 12:12 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

You can also re-write as below:

WITH SET SetA as Except([PH_CUST].[Cust].Children,{[EMP].[PHWEB].[Activce].&[1]})

SELECT { } ON COLUMNS,
NON EMPTY { SetA } ON ROWS
FROM Ad_CUBE

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum

Post #1359983

« Prev Topic | Next Topic »

Permissions