没有合适的资源?快使用搜索试试~ 我知道了~
首页Cognos 8 MDX-OLAP Functions
资源详情
资源评论
资源推荐
Tip or Technique
OLAP Functions
Product(s): Cognos 8 BI
Area of Interest: Report Design
OLAP Functions 2
Cognos
Proprietary Information
Copyright
Your use of this document is subject to the Terms of Use governing the
Cognos software products and related services which you have licensed or
purchased from Cognos. The information contained in this document is
proprietary information of Cognos Incorporated and/or its licensors and is
protected under copyright and other applicable laws. You may use the
information and methodologies described in this document 'as is' or you may
modify them, however Cognos will not be responsible for any deficiencies or
errors that result from modifications which you make. Copyright 2006 (c)
Cognos Incorporated. All Rights Reserved.
You can print selected pages, a section, or the whole book. Cognos grants
you a non-exclusive, non-transferable license to use, copy, and reproduce the
copyright materials, in printed or electronic format, solely for the purpose of
providing internal training on, operating, and maintaining the Cognos
software.
This document is maintained by the Best Practices, Product and Technology
team. You can send comments, suggestions, and additions to Best Practices,
Product and Technologies.
OLAP Functions 3
Cognos
Proprietary Information
Contents
1 INTRODUCTION ............................................................................................ 5
1.1 P
URPOSE
.............................................................................................................. 5
1.2 A
PPLICABILITY
....................................................................................................... 5
2 BACKGROUND INFORMATION...................................................................... 5
3 FUNCTION DEFINITIONS.............................................................................. 6
3.1 _
FIRST
F
ROM
S
ET
..................................................................................................... 6
3.2 _
REMAINDER
S
ET
.................................................................................................... 6
3.3
ANCESTOR
............................................................................................................. 7
3.4
ANCESTORS
........................................................................................................... 7
3.5
BOTTOM
C
OUNT
...................................................................................................... 8
3.6
BOTTOM
P
ERCENT
.................................................................................................... 8
3.7
BOTTOM
S
UM
......................................................................................................... 9
3.8
CAPTION
............................................................................................................. 10
3.9
CHILDREN
........................................................................................................... 10
3.10
CLOSING
P
ERIOD
................................................................................................... 10
3.11
COMPLETE
T
UPLE
................................................................................................... 11
3.12
COUSIN
.............................................................................................................. 12
3.13
CURRENT
M
EMBER
................................................................................................. 12
3.14
DEFAULT
M
EMBER
.................................................................................................. 13
3.15
DESCENDANTS
...................................................................................................... 14
3.16
EMPTY
S
ET
........................................................................................................... 16
3.17
EXCEPT
.............................................................................................................. 16
3.18
FILTER
............................................................................................................... 16
3.19
FIRST
C
HILD
......................................................................................................... 17
3.20
FIRST
S
IBLING
...................................................................................................... 17
3.21
GENERATE
........................................................................................................... 18
3.22
HEAD
................................................................................................................. 18
3.23
HIERARCHIZE
....................................................................................................... 19
3.24
HIERARCHY
......................................................................................................... 19
3.25
ITEM
................................................................................................................. 20
3.26
INTERSECT
.......................................................................................................... 20
3.27
LAG
................................................................................................................... 21
3.28
LAST
C
HILD
.......................................................................................................... 21
3.29
LAST
P
ERIODS
....................................................................................................... 21
3.30
LAST
S
IBLING
....................................................................................................... 22
3.31
LEAD
................................................................................................................. 22
3.32
LEVEL
................................................................................................................ 22
3.33
LEVELS
............................................................................................................... 22
3.34
MEMBER
............................................................................................................. 23
3.35
MEMBERS
............................................................................................................ 24
3.36
NESTED
S
ET
......................................................................................................... 24
3.37
NEXT
M
EMBER
...................................................................................................... 25
3.38
OPENING
P
ERIOD
................................................................................................... 25
3.39
ORDER
............................................................................................................... 25
3.40
ORDINAL
............................................................................................................ 26
3.41
PARALLEL
P
ERIOD
.................................................................................................. 27
3.42
PARENT
.............................................................................................................. 27
3.43
PERIODS
T
O
D
ATE
.................................................................................................. 27
3.44
PREV
M
EMBER
....................................................................................................... 28
3.45
ROLE
V
ALUE
......................................................................................................... 28
3.46
ROOT
M
EMEBERS
................................................................................................... 29
3.47
SET
................................................................................................................... 29
OLAP Functions 4
Cognos
Proprietary Information
3.48
SIBLINGS
............................................................................................................ 29
3.49
SUBSET
.............................................................................................................. 29
3.50
TAIL
.................................................................................................................. 30
3.51
TOP
C
OUNT
.......................................................................................................... 30
3.52
TOP
P
ERCENT
....................................................................................................... 31
3.53
TOP
S
UM
............................................................................................................. 32
3.54
TUPLE
................................................................................................................ 32
3.55
UNION
............................................................................................................... 32
3.56
VALUE
................................................................................................................ 33
4 APPENDIX A – FUNCTION GROUPING........................................................ 34
4.1 B
LOCK
............................................................................................................... 34
4.2 D
ATE
................................................................................................................. 34
4.3 F
AMILY
.............................................................................................................. 34
4.4 H
IERARCHY
......................................................................................................... 34
4.5 M
EMBER
............................................................................................................. 34
4.6 S
ET
................................................................................................................... 34
4.7 T
OP AND
B
OTTOM
................................................................................................. 35
4.8 V
ALUE
............................................................................................................... 35
5 DEPLOYMENT OF FUNCTION SAMPLES ...................................................... 35
OLAP Functions 5
Cognos
Proprietary Information
1 Introduction
1.1 Purpose
This document provides additional detail and examples of the OLAP functions
provided within Report Studio for Cognos 8.
1.2 Applicability
The functions and sample data listed below apply to Cognos 8, Report Studio.
The PowerCube and deployment package for “Great Outdoors Company” are
provided with the product samples. Please see the Administration and
Security Guide for Cognos 8 regarding the steps to restore these samples.
The provided deployment of sample reports can be found at the end of this
document. This deployment file is valid for Cognos 8 MR1.
2 Background Information
Below is an example hierarchy from the Product Dimension of the Great Outdoors
Company PowerCube showing the members below the Camping Equipment Product
Line. This dimension will be the basis of many of the subsequent examples.
剩余34页未读,继续阅读
lzq198491
- 粉丝: 1
- 资源: 37
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 27页智慧街道信息化建设综合解决方案.pptx
- 计算机二级Ms-Office选择题汇总.doc
- 单链表的插入和删除实验报告 (2).docx
- 单链表的插入和删除实验报告.pdf
- 物联网智能终端项目设备管理方案.pdf
- 如何打造品牌的模式.doc
- 样式控制与页面布局.pdf
- 武汉理工Java实验报告(二).docx
- 2021线上新品消费趋势报告.pdf
- 第3章 Matlab中的矩阵及其运算.docx
- 基于Web的人力资源管理系统的必要性和可行性.doc
- 基于一阶倒立摆的matlab仿真实验.doc
- 速运公司物流管理模式研究教材
- 大数据与管理.pptx
- 单片机课程设计之步进电机.doc
- 大数据与数据挖掘.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论1