资 源 简 介
hyperion planning metadata plsql interface.
http://essbase.ru/archives/category/hyperion-planning-plsql-interface
Released functions
getSQLOpenPeriods,
getSQLDimensions,
getSQLScenarioPeriods,
getSQLMetaData,
getSQLSecurityMetaDatav,
getSQLSecurityUsers,
getSqlOpenWorkFlow,
getUsersList,
getDimensionHierarshi,
getUserSecurityShort,
getUserSecurityFull
U can use this functins like this example
SELECT Parent_NAME , Child_name , max(Alias_name) Alias_name, max(ATRR_NAME) ATRR_NAME
FROM ( TABLE( PLN_GETMETA_PCKG.getDimensionHierarshi( "%ApplicationName%","%ParentName%")) )
GROUP by Child_name,Parent_NAME
