TAILIEUCHUNG - Oracle Essbase 9 Implementation Guide- P79

Oracle Essbase 9 Implementation Guide- P79:Essbase is a multidimensional database management system. The name Essbase stands for Extended Spread Sheet dataBASE. Using the custom add-in provides the end-user with near seamless compatibility in the Microsoft Excel spreadsheet program. | Chapter 10 Take a close look at the functions most of them are intuitive as to their function and you will also notice a complete array of functions that are suspiciously similar to the column functions in relational SQL. Again this is because an ASO database does not store the complete set of data like a BSO database does. ASO only physically stores the data at the lowest levels and is a lot like a relational database where you depend heavily on functions such as sum max and abs to massage the data as it is delivered to you. MDX function examples Here we will show you the same data query function twice. One will be in the format used by the Essbase Calculation Script language and the other example will be in the MDX data query language. The reason for this is to illustrate how vastly different each language is. The @ancest function is a very commonly used function. In an Essbase database where the data is stored at all levels you can easily ask for the ancestor member. In an ASO database however the data in most cases is dynamically calculated so you have to ask for it in a different way so Essbase can interpret your request properly. Essbase Calculation Script Syntax @ANCEST dimName genLevNum mbrName Example @ANCEST Product 2 Sales MDX Query Language Ancestor Example Sales Ancestor 2 The command above assumes you are keying off of the member currently selected. What will be returned is the value of Sales from the ancestor of the member in the product dimension and the Generation level 2. 375 Download at Essbase Analytics Option MDX query syntax To make querying an ASO database more relational and SQL like you can actually write your queries like you would in a relational database using SQL. Looking at the following examples you can see that the select statement is almost identical to that of a query written in SQL. Because the data is stored similarly the query language is similar. That way you won t forget .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.