Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Navigation confusion

Answered Navigation confusion

  • Friday, February 01, 2013 9:29 AM
     
     
    Sign In to Vote
    0

    Hello all,

        Consider am having a set

    FILTER([Customer].[Customer Geography].[Customer].Members, [Measures].[Internet Order Count] > 10)

    Now i wanna find out the parent members of this set . above level to [Customer].[Customer Geography].[Customer] is [Customer].[Customer Geography].[City].

    So i need to find out all the members whose children are present in the above set.

    Please suggest .

    Regards,

    Bharath

     

All Replies

  • Friday, February 01, 2013 12:06 PM
     
      Has Code
    Sign In to Vote
    0

    Hello Bharath,

    Try something as below

    GENERATE
(
FILTER([Customer].[Customer Geography].[Customer].Members, [Measures].[Internet Order Count] > 10)
, ASCENDANTS([Customer].[Customer Geography].CurrentMember))

    Best Regards Sorna

     
  • Monday, February 04, 2013 8:58 AM
     
     
    Sign In to Vote
    0

    Hello Sorna,

       Can i make it somethin like this

    GENERATE
    (
    FILTER    ([Customer].[Customer Geography].[Customer].Members, [Measures].[Internet Order Count] > 10)
    , Ancestor([Customer].[Customer Geography].CurrentMember,3))

     
  • Monday, February 04, 2013 12:21 PM
    Answerer
     
     Answered Has Code
    Sign In to Vote
    0

    this one should work just fine and you avoid the use of the expensive GENERATE()-function:

    select 
{} ON 0,
Exists(
	[Customer].[City].[City].members,
	FILTER([Customer].[Customer Geography].[Customer].Members, [Measures].[Internet Order Count] > 10))
ON 1
FROM [Adventure Works]
    hth,
    gerhard

    - www.pmOne.com -

    • Marked As Answer by Bharath_RAM Tuesday, February 05, 2013 5:15 AM
    •