Cognos模型设计
0
投票
3
回答
3274
浏览
cognos设置默认日期后在查询中不生效
天蓝佯伶 回复了问题 • 2015-10-19 15:11
0
推荐
2675
浏览
Cognos模型对象命名规则
Cognos模型中的所有对象都有唯一的标识符(unique identifier)。根据对象类型的不同,不同对象标识符的组成也有特定的规则。在设计报表时,我们使用各种对象的唯一标识符来调用他们。如果对模型中的对象名称进行...
hupingzhi 发表了文章 • 2015-09-27 11:46
0
投票
3
已解决
2448
浏览
有谁知道过滤器的使用方法吗
海鲜灬海鲜 回复了问题 • 2015-09-13 21:52
0
投票
1
已解决
2264
浏览
请教大神,cognos删除模型报错
H_Elsker 回复了问题 • 2015-08-21 15:38
0
投票
1
回答
3723
浏览
cognos日期转换
曾力 回复了问题 • 2014-12-29 11:47
0
投票
0
回答
3398
浏览
Cognos点击完成后,日期提示总是跳回设置的默认值
tellhow 发起了问题 • 2014-12-11 17:03
0
投票
0
回答
2201
浏览
各位!怎么在过滤器中添加start with ...connect by prior...
一戮一 发起了问题 • 2014-12-01 16:14
0
投票
2
回答
3526
浏览
Cognos 过滤器中如何使用函数获取上周的周一和周日的时间
RobinChen 回复了问题 • 2014-11-30 11:12
0
投票
1
回答
2594
浏览
关于RS过滤器对底层数据的过滤
hupingzhi 回复了问题 • 2014-09-28 14:15
0
投票
1
回答
2474
浏览
cognos报表禁用过滤器
wengr 回复了问题 • 2014-08-25 10:03
0
投票
2
回答
4548
浏览
2000W大数据量下Cube该如何设计,具体描述如下:
hupingzhi 回复了问题 • 2013-12-05 16:01
Shortcuts are less flexible from a presentation perspective than model objects, but they require much less maintenance because the... 显示全部 »
Shortcuts are less flexible from a presentation perspective than model objects, but they require much less maintenance because they are automatically updated when the target object is updated. If maintenance is a key concern and there is no need to customize the appearance of the query subject, use shortcuts.
Framework Manager has two types of shortcuts:
regular shortcuts, which are a simple reference to the target object.
alias shortcuts, which behave as if they were a copy of the original object with completely independent behavior. Alias shortcuts are available only for query subjects and dimensions.
Regular shortcuts are typically used as conformed dimensions with star schema groups, creating multiple references with the exact same name and appearance in multiple places. In the example below, the shortcuts created for Products and Order Time behave as references. If a query is written that brings Products from both Product Forecast and Sales Target, the query uses the definition of Products based on the original and this definition appears only once in the query.
Alias shortcuts are typically used in role-playing dimensions or shared tables. Because there is already an example in this document for role-playing dimensions, we will look at the case of shared tables. In this example, Sales Staff and Sales Branch can be treated as different hierarchies. From our knowledge of the data, we know that because staff can move between branches, we need to be able to report orders against Sales Branch and Sales Staff independently as well as together. To achieve this, we need to create an alias to Sales Branch that can be used as a level in the Sales Staff hierarchy.
With the new alias shortcut in place, it is possible to create queries that require orders by sales branch and orders by sales staff with their current branch information simultaneously.
copy from cognos installation document~~
http://
Framework Manager has two types of shortcuts:
regular shortcuts, which are a simple reference to the target object.
alias shortcuts, which behave as if they were a copy of the original object with completely independent behavior. Alias shortcuts are available only for query subjects and dimensions.
Regular shortcuts are typically used as conformed dimensions with star schema groups, creating multiple references with the exact same name and appearance in multiple places. In the example below, the shortcuts created for Products and Order Time behave as references. If a query is written that brings Products from both Product Forecast and Sales Target, the query uses the definition of Products based on the original and this definition appears only once in the query.
Alias shortcuts are typically used in role-playing dimensions or shared tables. Because there is already an example in this document for role-playing dimensions, we will look at the case of shared tables. In this example, Sales Staff and Sales Branch can be treated as different hierarchies. From our knowledge of the data, we know that because staff can move between branches, we need to be able to report orders against Sales Branch and Sales Staff independently as well as together. To achieve this, we need to create an alias to Sales Branch that can be used as a level in the Sales Staff hierarchy.
With the new alias shortcut in place, it is possible to create queries that require orders by sales branch and orders by sales staff with their current branch information simultaneously.
copy from cognos installation document~~
http://
曾力 回答了问题 • 2013-07-21 16:48 • 1 个回复
Cognos中建一个cube,增量,每个月的数据增加约1000w,请问,要每月出一张当月的数据表,又要保留历史记录的话,该怎么建cube呢?
提供思路,我们在创建一个cube的时候,我们要对cube进行分组,若每月一张,我就把时间维度中的月当作一个分组的依据。之后一个月会生成一个小cube。
但是如果每月新增数量过大,且客户想把很多个月方在一张报表中,那除了等待比较长的cube生成和更新时间,我目前... 显示全部 »
但是如果每月新增数量过大,且客户想把很多个月方在一张报表中,那除了等待比较长的cube生成和更新时间,我目前... 显示全部 »
提供思路,我们在创建一个cube的时候,我们要对cube进行分组,若每月一张,我就把时间维度中的月当作一个分组的依据。之后一个月会生成一个小cube。
但是如果每月新增数量过大,且客户想把很多个月方在一张报表中,那除了等待比较长的cube生成和更新时间,我目前还没有想到什么好办法.
但是如果每月新增数量过大,且客户想把很多个月方在一张报表中,那除了等待比较长的cube生成和更新时间,我目前还没有想到什么好办法.
这错误还真没有见到过,BmtActionsHelper.cpp(500) 没有见到过。
但是 有人 遇到过,说是 :
Cause:运行FM的操作系统用户对cognos目录树没有足够的权限
Resolving the problem: 针对cognos文件夹目录... 显示全部 »
但是 有人 遇到过,说是 :
Cause:运行FM的操作系统用户对cognos目录树没有足够的权限
Resolving the problem: 针对cognos文件夹目录... 显示全部 »
这错误还真没有见到过,BmtActionsHelper.cpp(500) 没有见到过。
但是 有人 遇到过,说是 :
Cause:运行FM的操作系统用户对cognos目录树没有足够的权限
Resolving the problem: 针对cognos文件夹目录,给予系统用户足够的操作权限或者Administrator一样。
再不行,重启下 服务器,在删除试试。
但是 有人 遇到过,说是 :
Cause:运行FM的操作系统用户对cognos目录树没有足够的权限
Resolving the problem: 针对cognos文件夹目录,给予系统用户足够的操作权限或者Administrator一样。
再不行,重启下 服务器,在删除试试。
过滤器有简单的用过,感觉和sql的where条件差不多~那字段取设置条件 不符合的数据会被过滤
过滤器有简单的用过,感觉和sql的where条件差不多~那字段取设置条件 不符合的数据会被过滤
0
投票
3
回答
3274
浏览
cognos设置默认日期后在查询中不生效
天蓝佯伶 回复了问题 • 2015-10-19 15:11
0
投票
3
已解决
2448
浏览
有谁知道过滤器的使用方法吗
海鲜灬海鲜 回复了问题 • 2015-09-13 21:52
0
投票
1
已解决
2264
浏览
请教大神,cognos删除模型报错
H_Elsker 回复了问题 • 2015-08-21 15:38
0
投票
1
回答
3723
浏览
cognos日期转换
曾力 回复了问题 • 2014-12-29 11:47
0
投票
0
回答
3398
浏览
Cognos点击完成后,日期提示总是跳回设置的默认值
tellhow 发起了问题 • 2014-12-11 17:03
0
投票
0
回答
2201
浏览
各位!怎么在过滤器中添加start with ...connect by prior...
一戮一 发起了问题 • 2014-12-01 16:14
0
投票
2
回答
3526
浏览
Cognos 过滤器中如何使用函数获取上周的周一和周日的时间
RobinChen 回复了问题 • 2014-11-30 11:12
0
投票
1
回答
2594
浏览
关于RS过滤器对底层数据的过滤
hupingzhi 回复了问题 • 2014-09-28 14:15
0
投票
1
回答
2474
浏览
cognos报表禁用过滤器
wengr 回复了问题 • 2014-08-25 10:03
0
投票
2
回答
4548
浏览
2000W大数据量下Cube该如何设计,具体描述如下:
hupingzhi 回复了问题 • 2013-12-05 16:01
0
投票
1
回答
3031
浏览
有人知道report studio中,filter函数可以两层进行过滤吗?
贝克汉姆 回复了问题 • 2013-11-25 18:13
0
推荐
2675
浏览
Cognos模型对象命名规则
Cognos模型中的所有对象都有唯一的标识符(unique identifier)。根据对象类型的不同,不同对象标识符的组成也有特定的规则。在设计报表时,我们使用各种对象的唯一标识符来调用他们。如果对模型中的对象名称进行...
hupingzhi 发表了文章 • 2015-09-27 11:46
cognos常见的模型设计