BI Apps 财务分析介绍知识讲稿.ppt

Oracle Answers also provides tremendous flexibility in enabling users to create derived calculations directly in the same UI by leveraging an Expression Builder with access to 99 standard ANSI SQL functions, filtering, access to variables, etc. This just increases the value of each Subject Area. One Subject Area, Unlimited Possibilities [the width of the descriptive bars – gray, black, red - correspond to the number of metrics provided at each layer] Logical Layer metrics are derived from Physical Layer measures. Some of the measures are derived or calculated metrics created by re-calculation to add value and make them amenable for use in reporting. As a best practice, the number of metrics used is limited in the Presentation Layer to match the specific needs of users by function and by role. Any additional metrics needed can be easily exposed by a simple drag and drop from the logical to the presentation layer. Pre-built dashboards use a subset of the available metrics in the Presentation Layer – the Presentation Layer is provided as a rich Ad Hoc layer for use with Answers. Trying to create dashboards that use every combination of Presentation Layer metrics would be impossible and overwhelming to end users – again, we employ UI best practices to increase adoption and usability of the BI Applications. We have hundreds of attributes at Physical layer but we dont expose them. For instance, the Product dimension has 100~150 attributes, but we only expose less than 25. Second Example, GL segments - we support all 30 segments including associated attributes, but we dont expose any of them. In working with many customers over the years, we have found that BI Applications are never truly entirely deployed out of the box or completely vanilla. Due to the fact that our customers always configure and / or extend the source application, there will always be a need for customization and configuration of the out of the box product. However, we have found that the magn