Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Placing minus in query builder

Unanswered Placing minus in query builder

  • Tuesday, February 26, 2013 6:25 PM
     
      Has Code
    Sign In to Vote
    0
     
    CREATE MEMBER CURRENTCUBE.[Measures].[Non Trad FTEE OPC]
 AS ([Measures].[FTEE]+
([Locsrv].[Clinc Or Ts Type].&[Mental Health],[Locsrv].[Category].&[OPC],[Measures].[FTEE])*
(([CCC].[CCC Key].&[8203],[Measures].[FTEE])+([CCC].[CCC Key].&[203],[Measures].[FTEE])+([CCC].[CCC Key].&[7203],[Measures].[FTEE])+
([CCC].[CCC Key].&[8227],[Measures].[FTEE])+([CCC].[CCC Key].&[227],[Measures].[FTEE])+([CCC].[CCC Key].&[7227],[Measures].[FTEE])+
([ALB].[ALB3].CurrentMember,[Measures].[FTEE]) +
([CCC].[CCC Hierarchy].CurrentMember,[Measures].[FTEE])+
([ALB].[ALB3].&[203],[Measures].[FTEE])+([ALB].[ALB3].&[227],[Measures].[FTEE]))
 -
((([CCC].[CCC Key].&[8203],[Measures].[FTEE])+([CCC].[CCC Key].&[203],[Measures].[FTEE])+
([CCC].[CCC Key].&[7203],[Measures].[FTEE])+([CCC].[CCC Key].&[8227],[Measures].[FTEE])+
([CCC].[CCC Key].&[227],[Measures].[FTEE])+([CCC].[CCC Key].&[7227],[Measures].[FTEE])+
([ALB].[ALB3].&[203],[Measures].[FTEE]))+
(([CCC].[CCC Key].&[7203],[Measures].[FTEE])+([CCC].[CCC Key].&[8203],[Measures].[FTEE])+
([CCC].[CCC Key].&[203],[Measures].[FTEE])+([CCC].[CCC Key].&[8227],[Measures].[FTEE])+
([CCC].[CCC Key].&[7227],[Measures].[FTEE])+([CCC].[CCC Key].&[227],[Measures].[FTEE])+
([ALB].[ALB3].&[227],[Measures].[FTEE]))))

    I am trying above query in ssrs2005 query builder but i am not getting where to place minus which is in this query .any suggestions would be help full.

    Thanks

    Madhavi

    Madhavi Pasapula

     

All Replies

  • Tuesday, February 26, 2013 11:00 PM
     
     
    Sign In to Vote
    0

    Basically Minus (Except) performing the set operation between the two sets and returning the difference between two sets. So you have to place the Minus operator between the two sets.

    so according to your above query you have to make the two set first and then place the minus operator between them  like:

    {Set_Expression } - { Set_Expression }

    Thanks,

    Zaim Raza.