- 博客(11)
- 收藏
- 关注
原创 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 436
原创 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 295
原创 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 316
原创 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 488
原创 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 525
原创 Oracle+Materialized+View+(物化视图) (to H)
1. 当MV不允许其内部SQL语句中带有子查询时,替代方案之一是,先把含有子查询的SQL形成VIEW,然后以VIEW为基础生成MV。
2011-10-12 14:14:42 356
原创 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 758
原创 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 502
原创 Create a link from SQL SERVER to Nortel CCM7 (InterSystems Cache DB)
<br />Nortel CCM7 use InterSystems Cache DB.<br /> <br />Create a link from SQL SERVER to Nortel CCM7 as below:<br /> <br />1. Install InterSystems ODBC driver for SQL SERVER host.<br />2. Create a ODBC UserDSN for SQL SERVER host.<br />3. Add a link serve
2011-03-10 23:12:00 592
原创 C# 语言规范 & Language Sample Code
<br />C# 语言规范, Get it from your local host as below.<br />In Visual Studio 2008:<br />C:/Program Files/Microsoft Visual Studio 9.0/VC#/Specifications/2052/CSharp Language Specification.doc<br /> <br />VB / C# /VC Language Sample Code, get it from your loca
2011-03-01 00:05:00 439
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人