How can I get External reports Data Model in a table
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.