Friday, April 26, 2013

OPB backend query to get names of mapping with a table as lookup source

select DISTINCT opb_subject.subj_name "Folder Name"
,opb_mapping.mapping_name "Mapping Name"
from
opb_widget_inst,
opb_widget_attr,
opb_mapping,
opb_subject
where opb_widget_inst.widget_type=11
and opb_widget_attr.attr_id=2
and opb_widget_inst.widget_id=opb_widget_attr.widget_id
and opb_mapping.mapping_id=opb_widget_inst.mapping_id
and opb_mapping.subject_id=opb_subject.subj_id
and UPPER(attr_value) like '%<<Source Name>>%';

No comments:

Post a Comment

Oracle analytics - Different pricing schems

OBIEE on premise Licensing: Component based licensing: The pricing is based on the user base or volume(COGS/revenue). It is a buy as ...