Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71

    Unanswered: Adding Time to Rank

    Using FoodMart, how can i add time to this:

    WITH MEMBER [Measures].[Rank] AS 'Rank ( Product.CurrentMember,Order( {Product.CurrentMember.Parent.Children} ,[Profit], DESC) ) '
    SELECT
    {[Profit] , [Rank]} ON COLUMNS,
    Drink.Children ON ROWS
    FROM Sales

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What platform is this?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    Brett,

    This is an MDX statement for OLAP - Hard as nails to understand ..


    msenoelo - are you wanting to set this up as a calculated measure or do you just want to see if the MDX is valid

    If you want check the MDX then you can open up the sample mdx application from

    Programs > SQL Server > Anaysis Services > Sample MDX Application

    I think??????

    You then get a kind IDE that can use to parse MDX.

    Or you can goto your cube

    New calculated meause > Insert your code

    Not totally sure as I don't have anaylsis services installed on my computer and MDX is total bloody mystery to me. Where did you get the MDX from ???

    Here is a like to a more relevant forum:

    http://www.sql-server-performance.co...sp?FORUM_ID=18

    Cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •