Unifier (MOSC)

MOSC Banner

How can I get External reports Data Model in a table

in Unifier (MOSC) 1 commentAnswered

Hi,

I would like to get the data model (SQL query) of all reports in Unifier. (the reports that were already created in BI Publisher and import to unifier as external reports)

It seems that the Crystal report should have the data report, but it's blank.

UNIFIER_SYS_CRYSTAL_REPORT or BP_SYS_CRYSTAL_REPORT

Crystal tables have data_model fields which are clob/XML format. Not sure if that's the reason they are blank in BIP.


select data_model

from "UNIFIER"."UNIFIER_SYS_CRYSTAL_REPORT" "UNIFIER_SYS_CRYSTAL_REPORT" 

where data_model is not null

it retrieves blank column.

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