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!

How to get worksheet IDs

puppethead-OracleMay 24 2006 — edited Jan 16 2007

I want to get the worksheet IDs for a workbook. I know the ID will show up in EUL5_BATCH_SHEETS and EUL5_QPP_STATS, but if a sheet has never been scheduled or "run", it will not be in those 2 tables.

I am creating a portlet to access workbooks/worksheets and have the workbook and worksheet IDs stored in a separate table. If I could query the eul or some other Disco table, maintenance would be simplified. One thought is that the info I need is stored in EUL5_DOCUMENTS.DOC_DOCUMENT, but I have not had success "decoding" that column.

Thanks in advance,
-D-

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2007

Added on May 24 2006

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

34 comments

3,637 views