BIEE培训课件.pptVIP

* * * * * Primary Message: * Primary Message: * * * Siebel Analytics Administration Tool The basic function of the Siebel Analytics Administration Tool is to create the mapping of physical data schemas (tables joins) to a logical business model. The logical business model stores a simplified mapping to one or more physical data sources. It also contains a shared library or default drill paths, complex derived calculations, aggregate navigation, etc. Most administrative tasks are edited/modified through the Siebel Analytics Administration Tool. The Siebel Analytics Administration Tool is broken out into three separate layers (Physical, Business Model Presentation). The Physical layer is an exact depiction of the target physical database(s). To create a new Physical layer simply select from the File Menu – Import feature. This allows the administrator to read in a system catalog from a relational, XML or Host-based systems or all three. The Siebel Analytics platform is 100% data agnostic and has no preconceived notion of how the data is modeled. The Key Point here is that the Analytics platform should not dictate the data design. Some BI tools require the data to modeled in a particular way, such as a star or snowflake schema. The bottom-line is the Siebel Analytics Administration Tool maps in the data, the exact same way in which the customer designed that data to support their business processes. No data is moved. Siebel Analytics simply references the way the data looks from the db system catalog. Siebel Analytics Function Shipping: The Siebel Analytics platform was designed with the notion that not all databases were created equally. For example, some databases are efficient at certain processes (like aggregations) while terrible at calculations (like time-series analysis). The Siebel Database Adapters are intelligent enough to dynamically determine whether or not a specific database function is supported. If the database supports a function S