- 博客(3)
- 资源 (1)
- 收藏
- 关注
转载 HSP_MEMBER(第3部分–全部维度信息)
--获取全部维度SELECT o.OBJECT_NAME AS MEMBER_NAME ,op.OBJECT_NAME AS PARENT_NAME ,a1.ALIAS_NAME AS ALIAS_DEFAULT ,a2.ALIAS_NAME AS ALIAS_ENGLISH ,( SELECT LISTAGG(UDA_VALUE,', ') WITHIN GROUP (ORDER BY UDA_VALUE) "UDA_LIST" FROM (SELECT UDA_V
2020-12-21 11:40:57 250
转载 HSP_MEMBER(第2分-UDA Attribute)
--获取UDASELECT o.OBJECT_NAME AS MEMBER_NAME ,op.OBJECT_NAME AS PARENT_NAME ,od.OBJECT_NAME AS DIMENSION_NAME ,LISTAGG(UDA_VALUE,', ') WITHIN GROUP (ORDER BY UDA_VALUE) "UDA LIST"FROM HSP_MEMBER mINNER JOIN HSP_OBJECT o ON m.MEMBER_ID = o..
2020-12-21 11:38:25 196 1
转载 HSP_MEMBER(第1部分–表)
提示:Hyperion planning 维度信息通过SQL提取转载国外博主的,经过自己验证,希望你们能用到哦哈哈哈QQ 1121622088开始正文吧,骚年,心之所向,所向披靡文章目录规划资料库:HSP_MEMBER(第1部分–表)一、表结构Field Name SQL Server Type Oracle Type Description 描述 MEMBER_ID int NUMBER(38,0) The OBJECT_ID.
2020-12-20 00:52:24 461 2
Twisted-21.2.0-py3-none-any.whl
2021-05-11
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人