中国IT动力,最新最全的IT技术教程
最新100篇 | 推荐100篇 | 专题100篇 | 排行榜 | 搜索 | 在线API文档
首 页 | 程序开发 | 操作系统 | 软件应用 | 图形图象 | 网络应用 | 精文荟萃 | 教育认证 | 硬件维护 | 未整理篇 | 站长教程
ASP JS PHP工程 ASP.NET 网站建设 UML J2EESUN .NET VC VB VFP 网络维护 数据库 DB2 SQL2000 Oracle Mysql
服务器 Win2000 Office C DreamWeaver FireWorks Flash PhotoShop 上网宝典 CorelDraw 协议大全 网络安全 微软认证
硬件维护  CPU  主板  硬盘  内存  显卡  显示器  键盘鼠标  声卡音箱  打印机  机箱电源  BIOS  网卡  C#  Java  Delphi  vs.net2005
  当前位置:> 程序开发 > 数据库开发 > 数据库综合
Hyperion reading book
作者:未知 时间:2005-07-27 23:40 出处:CSDN 责编:chinaitpower
              摘要:Hyperion reading book

index driven types
  Label Only and Shared Member are index based, Members whith these storage types,When
incorporate dimension defined as sparse. Are actually index pointers to other members stored
in the Analytic services Page file in the form of data blocks
    Label Only Member  have an index to the first child with an Add(+) consolidation operator
,or the first child if all children have an Ignore(~) consolidation operator,There may be some v-
ariability in this defined behavior in actual situations
    Share member members have an index to main member whose name it bears,Shared
Members generally follow the main member in the outline they point to through the index
Share Member
    the share member assumers attributes of the main member(its value,aliases,time balance
flags and so forth)except the member's consolidation operator.
    share member have their consolidation operation independent from the main member's
value they share,This facilitates building complex models with computation dependencies
between members

Formulas in Outlines Versus in calc scripts
Use formulats in outlines where :
    The member calculations are straightforward without complex order of calculation dependencies
    The member requires a Two Pass Calc operation and is  flagged as such,and not other
back caculation of other members is required to be performed in a calc script after the main
calc All of Calc Dim statement
    The member requires a Two Pass Calc operation and is flagged as such ,and the conditions
are otherwise met for accomplishing a two For The Price of One Calculation
    The member's data storage type is Dynamic Calc or Dynamic Calc And Store

note: Formlas For Dynamic Calc members cannot be executed within a calc scripts

User Defined Attributes(UDAs)
    Use UDAs is a way to avoid setting up additional dimensions where member identification
is not hierarchical

Attribute Dimensions
    Attribute dimensions is help further assign characteristics to give members in an outline
    Attribute dimensions add no overhead in terms of database size. They are dynamic
dimensions with no storage requirements
    Calculation of the Attribute dimensions is deferred until they are requested in a report
    Attribute Dimensions are drillable so that a report can show the specified attribute dimension
across all the other dimensions in the model.
    Attribute dimensions  can be of different types ,-- text ,numeric,boolean and date
    A given member within a  dimension may be assigned one or more attributes ,or no attributes
at all.
    attribute dimensions may be created and loaded to specificmembers using load rules


Ground Rules
    Follow these general when creating attribute attribute dimensions
1. Base dimensions must be sparse. Base dimensions are the dimensions associated with
the attribute dimension.
2. Attribute dimensions don't have consolidation symbols of formulas attached to them.All
calculations are done across the base dimensions
3. Although Attribute dimensions can have multi-tiered hierarchy,you must associate the level 0
members(bottom level members)of attribute dimensions with base dimensions members.
4. Base dimension members associated with attribute dimensions must be at the same level.
this can be any level but it must be the same across the base dimension.
5. Do not tag shared members in the base dimension with attribute dimension members,
Shared members automatically inherit their respective stored member attributes


关闭本页
 
首页 | 投资与合作 | 服务条款 | 隐私政策 | 收藏本站 | 设为首页 | 新用户注册 | 免责声明 | 使用帮助
Copyright ©2005-2008 chinaitpower.com All rights reserved. www.chinaitpower.com 版权所有