没有合适的资源?快使用搜索试试~ 我知道了~
首页cognos 10 framework manager 安装新手手册
资源详情
资源评论
资源推荐
IBM Cognos Framework Manager
Install and Develop
I wrote this document last week, when I was studying the FM, most of the contents are copied form
Handbook. I just make it simpler, and added the description on configuration and segment. Please forgive
me if you find any mistake in this document, I am a rookie. Appreciate if you can correct and share it.
Regretfully I haven't done the Security excise. Anyway, it may help you a little on Cognos FM.
1
Table of Contents
1. Install and configure.............................................................................................................................................4
1. Install and configure.............................................................................................................................................4
1) Install Cognos FM step by step........................................................................................................................4
2) Install Oracle Client...........................................................................................................................................4
3) Configure TNS file.............................................................................................................................................4
4) Copy Oracle JAR file to FM client.....................................................................................................................4
5) Copy CSK folder from Cognos server to FM client...........................................................................................4
6) Open Configuration and set the Environment..................................................................................................4
7) Save your changes...........................................................................................................................................5
2. Interface introduction:...........................................................................................................................................5
2. Interface introduction:...........................................................................................................................................5
1) Projects.............................................................................................................................................................6
2) Models..............................................................................................................................................................6
3) Namespaces.....................................................................................................................................................6
4) Dimensions.......................................................................................................................................................7
5) Query Subjects.................................................................................................................................................7
6) Query Items......................................................................................................................................................7
7) Parameter Map.................................................................................................................................................7
8) Packages..........................................................................................................................................................8
3. Create a project....................................................................................................................................................8
3. Create a project....................................................................................................................................................8
1) Create a project by Model Design Accelerator.................................................................................................8
2) The three Views in the Model.........................................................................................................................14
3) Import additional metadata and create the relationship..................................................................................15
4. Specify Determinants.........................................................................................................................................26
4. Specify Determinants.........................................................................................................................................26
1) Add Determinants for Time.............................................................................................................................26
2) Add Determinants for Product........................................................................................................................27
5. Add business logic to the model.........................................................................................................................28
5. Add business logic to the model.........................................................................................................................28
1) Add filters to the model...................................................................................................................................28
2) Filter Options...................................................................................................................................................29
3) Add calculations to the model.........................................................................................................................29
6. Create dimensional objects for OLAP-style reporting........................................................................................31
6. Create dimensional objects for OLAP-style reporting........................................................................................31
1) Create Regular Dimensions............................................................................................................................32
2) Create Time Regular Dimensions...................................................................................................................32
7. Create and configure a package........................................................................................................................39
7. Create and configure a package........................................................................................................................39
1) Create Namespace Query & Analysis............................................................................................................39
2) Create packages.............................................................................................................................................40
8. Parameter Maps and Macros.............................................................................................................................44
2
8. Parameter Maps and Macros.............................................................................................................................44
1) About Parameter Maps and Macros...............................................................................................................44
2) Cerate Parameter...........................................................................................................................................45
9. Verify the model..................................................................................................................................................50
9. Verify the model..................................................................................................................................................50
10. Security in Framework Manager.......................................................................................................................52
10. Security in Framework Manager.......................................................................................................................52
1) Object level security........................................................................................................................................52
2) Row level security...........................................................................................................................................53
3) Package level security....................................................................................................................................54
11. Other Introduction.............................................................................................................................................54
11. Other Introduction.............................................................................................................................................54
1) Segmenting and Linking Projects...................................................................................................................54
2) Introduce about the items in Metadata Wizard...............................................................................................59
3) Relationships between tables.........................................................................................................................60
4) User-defined function......................................................................................................................................60
3
Environment:
Cognos Server: 172.31.112.136
Database (Oracle 11g): 172.31.112.205
1.Install and configure
1)Install Cognos FM step by step
If you are installing FM client on the Cognos server, you can install FM by default steps.
If you are using this FM client connect to other server, please don't install FM client to the folder
where the server installed.
2)Install Oracle Client
Make sure you have oracle client installed on the Cognos FM client that has the datasource entry.
3)Configure TNS file
The tnsnames.ora file must have the correct configuration for the Oracle server that you are trying to
connect to. Setup TNS in your Oracle Client like below:
Orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.112.205)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XXXX)
)
)
4)Copy Oracle JAR file to FM client
Copy C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc5.jar and paste to C:\Program
Files\IBM\cognos\FM\webapps\p2pd\WEB-INF\lib
5)Copy CSK folder from Cognos server to FM client
Copy the folder configuration/csk from the Cognos server and paste to the same path in FM client.
6)Open Configuration and set the Environment
Change the "Gateway URI" and "Dispatcher URI……" path to your own server address;
4
7)Save your changes
Click the Save button on the toolbar. Ignore the Certificate error.
2.Interface introduction:
Projects, Models, Namespaces, Dimensions, Query Subjects, Query Items, Package.
5
剩余59页未读,继续阅读
lhdren
- 粉丝: 0
- 资源: 12
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 数据结构1800题含完整答案详解.doc
- 医疗企业薪酬系统设计与管理方案.pptx
- 界面与表面技术界面理论与表面技术要点PPT学习教案.pptx
- Java集合排序及java集合类详解(Collection、List、Map、Set)讲解.pdf
- 网页浏览器的开发 (2).pdf
- 路由器原理与设计讲稿6-交换网络.pptx
- 火电厂锅炉过热汽温控制系统设计.doc
- 企业识别CIS系统手册[收集].pdf
- 物业管理基础知识.pptx
- 第4章财务预测.pptx
- 《集成电路工艺设计及器件特性分析》——实验教学计算机仿真系.pptx
- 局域网内共享文件提示没有访问权限的问题借鉴.pdf
- 第5章网络营销策略.pptx
- 固井质量测井原理PPT教案.pptx
- 毕业实习总结6篇.doc
- UGNX建模基础篇草图模块PPT学习教案.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0