Hyperion reading book

类别:数据库 点击:0 评论:0 推荐:

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

本文地址:http://com.8s8s.com/it/it19069.htm