ECC Admin - Metadata Attributes

Description
Categories: Application, DBA, Enginatics
Repository: Github Columns: Application, Data Set Key, Data Set, Attribute Key, Source Data Type, Profile, Display Name, Custom Display Name, Text Searchable, Refinable ...
Enterprise Command Centers metadata attributes
select
(
select distinct
listagg(eat.application_name,', ') within group (order by eat.application_name) over (partition by eadr.dataset_id) application 
from
ecc.ecc_app_ds_relationships eadr,
ecc.ecc_application_tl eat
where
edb.dataset_id=eadr.dataset_id and
eadr.application_id=eat.application_id and
eat.language='en'
) application,
edb.dataset_key data_set_key,
edt.display_name data_set,
edab.attribute_key,
initcap(edab.attr_source_datatype) source_data_type,
edab.attr_profile_key profile,
edat.display_name,
edat.custom_display_name,
xxen_util.meaning(decode(edab.text_searchable_flag,'Y','Y'),'YES_NO',0) text_searchable,
xxen_util.meaning(decode(edab.dim_enable_refinements_flag,'Y','Y'),'YES_NO',0) refinable,
xxen_util.meaning(decode(edab.translation_flag,'Y','Y'),'YES_NO',0) translatable,
edab.select_type_code refinement_behavior,
edab.ranking_type_code refinement_order,
xxen_util.meaning(decode(edab.show_in_guided_discovery_flag,'Y','Y'),'YES_NO',0) show_in_guided_discovery,
xxen_util.meaning(decode(edab.show_record_counts_flag,'Y','Y'),'YES_NO',0) show_