Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Displaying the most recent data

413092Dec 5 2007 — edited Dec 6 2007

I have a situation where there are several columns containing data.

I want to display the most recent data for each of the columns, but the latest date that we have data can vary between each of them.

e.g. For column 1 the latest data we have is from 01-Dec-2007
Column 2 has data from 03-Dec-2007

I would want this to be shown in a table with the various columns and a single row indicating the latest data for the respective columns.

I'm struggling to think how I would do this in Answers.
If everything had the same date then obviously I could simply apply a filter, but it's not quite that simple.
Any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2008

Added on Dec 5 2007

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

6 comments

591 views