Thursday 20 October 2011

IN Which Tables the Hyperion Financial reporting objects are stored in the relational database


You can get the list of all FR-related objects created by running the below SQL statements against the BI database:

Financial Reporting Report:
select * from v8_container where meta_type_uuid = 'ID200'


Financial Reporting Snapshot Report:
select * from v8_container where meta_type_uuid = 'ID201'


Financial Reporting Batch:
select * from v8_container where meta_type_uuid = 'ID204'


Financial Reporting Book:
select * from v8_container where meta_type_uuid = 'ID202'

No comments:

Post a Comment