Skip to Content
author's profile photo Former Member
Former Member

Selecting Max Value of KF for a date range

Hi All,

I have an ODS with details of Trips to different Hotels.

One of The Key figures is Hotel Rate. The Contract start date is a Key in the ODS.

for a particular range of dates if I have 2 different rates for a Hotel..How do I display the MAX Rate for the Hotel ?? Coz If there are 10 records for that particular hotel all these rates get aggregated..I can`t use he avg..as I need only the Max Rate in that date range..

Thanks in Advance,

Ashish.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2005 at 06:03 PM

    Hi Ashish,

    what is this particular range of dates ? you have FROM date in your ODS as key field, but you have also TO date ?

    You can obtain what you want by aggregation properties on your KF (in RSA1)...set aggregation on 'Maximum'...

    let me know !

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.