神州数码Framework_Manager培训.pptVIP

* Best Practice - 7 As a best practice, specify dimension information for all new dimension model query subjects. Even if there is currently no multiple levels of granularity for different fact tables, you should still specify dimension information to make the model extensible should that scenario arise in the future. * Determinant是Cognos8的特性，设计成提供控制所有粒度。在Determinant对话框中指定的设置给Cognos8充足的信息正确聚合有多粒度层的查询中的事实数据。 Determinant与数据库中的键和索引的概念的关系最密切。在Determinant中没有层次结构的概念，尽管他们被指定的顺序支配他们评估的顺序。 查询BLOB需要附加键/索引类型的信息。如果这个信息在数据源中没有出现，可以用Determinant添加它。 Best Practice - 7 As a best practice, specify dimension information for all new dimension model query subjects. Even if there is currently no multiple levels of granularity for different fact tables, you should still specify dimension information to make the model extensible should that scenario arise in the future. * Best Practice - 7 As a best practice, specify dimension information for all new dimension model query subjects. Even if there is currently no multiple levels of granularity for different fact tables, you should still specify dimension information to make the model extensible should that scenario arise in the future. * Best Practice - 7 As a best practice, specify dimension information for all new dimension model query subjects. Even if there is currently no multiple levels of granularity for different fact tables, you should still specify dimension information to make the model extensible should that scenario arise in the future. Month Key是在数据中为一个特定的年指定月所需要的。如果要从这个时间表查询月，我们要通过Month Key写一个使用select min function语法和分组的查询。这样做是因为值是重复的。这就是为什么我们在Determinant 设置中选Group By。 类似的逻辑应用于Year Determinant。 当用上表的一个列评估一个查询时， Cognos8查询引擎每次寻找一个Determinant列参照，当找到它时就停止。 评估的顺序如下： 当我们用Month Name写一个查询，它是Month Determinant和Day Determinant的一个属性。由于在列表中Month Determinant比Day Determinant定义的早，它将被选中。这就意味着，我们将在查询中很可能看到一个select min function ，在group by语句中将看到Month Key。 * Best Practice - 7 As a best practice, specify dimension information for all new dimensio