essbase+BIEE__学习笔记.ppt

* It is important to understand how Analytic Services calculates members with different consolidation operators. When you are using just addition and subtraction operators the order of members in the outline is irrelevant. However, when you use any other operator, you need to consider the member order and its impact on the consolidation. When siblings have different operators, Analytic Services calculates data in top-down order. The following example illustrates a top-down calculation: Sample Roll-up Parent1Member1 (+) 10Member2 (+) 20Member3 (-) 25Member4 (*) 40Member5 (%) 50Member6 (/) 60Member7 (~) 70 Analytic Services calculates Member1 through Member4 as follows: (((Member1 + Member2) + (-1)Member3) * Member4) = X(((10 + 20) + (-25)) * 40) = 200 If the result from Members 1-4 is X, then Member5 consolidates as follows: (X/Member5) * 100 = Y(200/50) * 100 = 400 If the result of Member5 is Y, then Member6 consolidates as follows: Y/Member6 = Z400/60 = 66.67 Analytic Services ignores Member7 in the consolidation. * * * While BI is an increasing priority, BI has also been around for some time, and the use of BI is evolving to meet a broader set of needs than traditional “reporting” solutions, or business analyst tools. First, BI is moving beyond the business analyst or “power user” to use by virtually everyone – from the CEO to the front-line users, people like call center agents or managers, field service engineers, sales people, and even extending beyond the firewall to business partners and customers. Second, BI is moving beyond just analysis of historical information to a state where organizations want to understand what has happened in the past, what is happening now, and predicting what will likely happen in the future, and using that information to drive action. Third, BI in organizations is moving from a fragmented to a unified enterprise view. BI has grown up in a siloed way across different departments in most organizations, causing a