Balance1781-CSDN博客

原创 Transformer info

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

2011-10-25 17:15:26 343

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

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

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

原创 FW - Determinants

Determinants Determinants 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 491

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

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

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

2011-10-12 14:14:42 360

原创 FW - Aggregate rules (need to H)

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

2011-10-11 23:54:14 762

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

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

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

人生不设限