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!

Filter analysis so that only the latest version of a record is shown...

feddingaFeb 5 2014 — edited Feb 9 2014

Hi,

Can anyone tell me how I can filter an OBIEE analysis so that only the latest version of a record is shown (using the ID column and the Version column)? Take the below as an example data set:

ID	Version	Country	Value
TS33	1	GB	3433565
TS44	1	USA	34124
TS51	1	Japan	4563506
TS33	2	GB	3443365
TS33	3	GB	546654
TS51	2	Japan	995647

The OBIEE report should filter this data set and show an analysis like the following:

ID	Version	Country	Value
TS33	3	GB	546654
TS44	1	USA	34124
TS51	2	Japan	995647

Any help that anyone can offer is appreciated.

Thanks,

Feddinga

This post has been answered by MDixit on Feb 9 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 9 2014

Added on Feb 5 2014

#11g, #answers, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dashboard, #data, #obiee, #obiee11g, #oracle, #report, #reporting, #reports, #table

8 comments

4,170 views