Hyperion Financial Reporting Products (MOSC)

MOSC Banner

Report usage missing for deleted report objects. Version 11.1.1.3 Interavtive reporting

edited Jan 10, 2013 7:49AM in Hyperion Financial Reporting Products (MOSC) 2 commentsAnswered ✓
When the HYPNPRPT.V8_USAGE_EVENT is joined to HYPNPRPT.V8_CONTAINER data the once matched no longer finds a match. I think it has to do with objects the have been deleted. Is the a way to force the data in HYPNPRPT.V8_CONTAINER to presist after the report object is deleted from workspace?

Sample SQL
SELECT AL3.NAME, AL3.EXPIRATION_DATE, AL3.CONTAINER_UUID, AL1.OBJECT_UUID, AL5.NAME, AL4.SEQUENCE_NUMBER, AL3.LAST_MODIFIED_DATE, AL3.CREATION_DATE, AL3.AUTO_DELETE, AL3.DELETED FROM HYPNPRPT.V8_USAGE_EVENT AL1, HYPNPRPT.V8_CONTAINER AL3, HYPNPRPT.V8_USAGE_ATTRIBUTES AL4, HYPNPRPT.V8_USAGE_EVENT_KEYVAL AL5 WHERE ( AL1.OBJECT_UUID = AL3.CONTAINER_UUID (+) AND AL1.EVENT_UUID=AL5.EVENT_UUID AND AL4.ATTRIBUTE_UUID=AL5.ATTRIBUTE_UUID)  AND (((AL5.NAME='usageobjectpath' OR AL5.NAME IS NULL) AND AL1.STARTTIME BETWEEN {ts '2013-01-03 10:33:00.000'} AND {ts '2013-01-03 10:35:00.000'}))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center