Balance1781-CSDN博客

原创 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 323

原创 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 356

原创 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 274

原创 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 297

原创 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 461

原创 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 503

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

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

2011-10-12 14:14:42 340

原创 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 730

原创 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 480

原创 Create a link from SQL SERVER to Nortel CCM7 （InterSystems Cache DB）

Nortel CCM7 use InterSystems Cache DB. Create a link from SQL SERVER to Nortel CCM7 as below: 1. Install InterSystems ODBC driver for SQL SERVER host. 2. Create a ODBC UserDSN for SQL SERVER host. 3. Add a link serve

2011-03-10 23:12:00 562

原创 C# 语言规范 & Language Sample Code

C# 语言规范, Get it from your local host as below. In Visual Studio 2008: C:/Program Files/Microsoft Visual Studio 9.0/VC#/Specifications/2052/CSharp Language Specification.doc VB / C# /VC Language Sample Code, get it from your loca

2011-03-01 00:05:00 420

人生不设限