hi raja,i am tryng to prepare a report that shows the order id of maximum sales ie by showing it in an additional row as i have shown in my previous posting.
I would try defining the Sales object in the universe as a measure with the default Aggregate function “Max”.
Then in the query analyzer, try pulling that object in the where clause and see what happens.
I am not sure if it is gonna work, but give it a try.
I don’t think the “Max” would work, since they are asking for the ORDER_ID associated to the Max Sales. Continue watching this thread where a solution has been discussed for an identical situation.