none
MDX Query RRS feed

  • Question

  • Hai Friends,

    Please help me to get result from the query

    1.I need result from the cube , after who have take the first travel in bus

    with Member[Measures].[FirstTravelDate]
    as filter([TravelStartDate].[Date].[Date],[Measures].[TravelerCount]).Item(0).Name

    Select non empty ( ([Customer].[Customer].[Customer]) on columns
    ,non empty ([TravelStartDate].[Date].[Date]) on rows
     from
     [BookingCube]
     where 
     ([Supplier].[SupplierType].[SupplierType].[Bus] , [Measures].[FirstTravelDate] > [TravelStartDate].[Date].[Date])

    Plsease lead me how can i use sub Query to get the result

    Thanks,


    Thanks, Vasantha Prabakaran


    Monday, October 8, 2012 2:03 PM

All replies

  • Hello Vasantha,

     Could you please provide some functional details of this query to suggest you a solution ? I am bit confused with the First travel date and travel start date logic here. Please provide more details on what you are trying to achieve here.

    Best Regards

    Sorna

    Monday, October 8, 2012 2:51 PM
  • Thanks Sorna,

    I have a cube Namly [BookingCube]. It has the following Diamensions and measures,

    Diamensions: [Supplier].[SupplierType].[SupplierType],[Customer].[Customer].[Customer],[TravelStartDate].[Date].[Date]

    Measures: [Measures].[TravelerCount]

    Supplier Type nothing but how the customer traveled (ie) bus,flight,train,ship,taxi....

    My requirement is : I Need the user's list who are all traveled in (bus) and what are all other types Type they are traveled after travels in (bus) . Which means  no need to consider types  before he first travel in (bus)

    Thanks


    Thanks, Vasantha Prabakaran

    Friday, October 19, 2012 1:31 PM