2011年10月_Balance1781

原创 Transformer info

Transformer infoIf you want to take advantage of Transformer's relative time functionality, do not import the datedimensions from dimensional packages. Instead, use the Insert Data Source option t

2011-10-25 17:15:26 341

原创 FW - Regular Dimensions

Regular Dimensions常规维度 Regular dimensions represent descriptive data that provides context for data modeled in measure dimensions. A regular dimension is broken into groups of information called

2011-10-25 10:52:25 433

原创 FW - Dimensional Modeling Concepts

Dimensional Modeling Concepts维度建模概念 Regular and measure dimensions are used to enable an OLAP presentation of metadata, drilling up and down, and a variety of OLAP functions. You must use star s

2011-10-25 10:32:01 294

原创 FW - Prompt Type Property （need to H）

Prompt Type Property在FW中设置它后，在Query Studio使用Filter时，会依据之前的相关设置提供对应的筛选形式。 Display Item Reference and Use Item Reference Properites该功能

2011-10-18 15:26:25 315

原创 FW - Determinants

DeterminantsDeterminants reflect granularity by representing subsets or groups of data in a query subject and are used to ensure correct a

2011-10-12 23:31:55 487

原创 Oracle 中获取特定日期时间 (need to H)

SELECT TRUNC(SYSDATE-1, 'YEAR')FROM DUAL; -- 得到今年第一天 -- 得到去年第一天SELECT TRUNC(TRUNC(SYSDATE-1, 'YEAR')-1, 'YEAR')FROM DUAL selec

2011-10-12 14:23:13 524

原创 Oracle+Materialized+View+(物化视图) (to H)

1. 当MV不允许其内部SQL语句中带有子查询时，替代方案之一是，先把含有子查询的SQL形成VIEW，然后以VIEW为基础生成MV。

2011-10-12 14:14:42 355

原创 FW - Aggregate rules (need to H)

(Cognos 8.4) Semi-additive measures are not supported for sparse data. Sparse data is multidimensional data inwhich many of the combinat

2011-10-11 23:54:14 757

原创 FW - Semi-Aggregate Property (need to H)

Semi-Aggregate Property (Cognos 8.4)For SAP BW metadata, the Semi-Aggregate property shows the value that is set in the data source,and

2011-10-11 23:24:01 501

人生不设限