TAILIEUCHUNG - Oracle Essbase 9 Implementation Guide- P49

Oracle Essbase 9 Implementation Guide- P49: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 6 Example ROW Total Vehicles Model Year This example will place members from the Total Vehicles and Model Year dimensions into the report output as row members. PAGE Syntax PAGE comma separated dimension list Example PAGE Market This example will place members from the Market dimension into the report output as page members. Data range commands The data range commands are a good example of the limitations in data selection we mentioned earlier. As of this writing there are only three commands available to you. After you look at the coding examples you will see why we spoke of limitations. BOTTOM Syntax BOTTOM rowgroupDimension rows column Example BOTTOM 100 @DATACOL 2 With the BOTTOM command the returned data is sorted in descending order by the data values and the bottom number of rows as specified by parameter two for the column specified in parameter three is returned. In the example the bottom 100 rows of data would be sorted according to the values in data column number two. The TOP command is identical but returns the top number of rows specified. 225 Download at Using your Essbase Cube Data ordering command Yes it says data ordering command because there is only one command. Although this command has a name similar to a command used in relational databases the difference and to some a limitation is that the data returned by the Essbase report script is ordered by data value columns only. Columns that contain metadata or member names cannot be sorted using this command since only columns containing numeric data values are considered for ordering. ORDERBY Syntax ORDERBY rowgroupDimension column direction column direction Example ORDERBY Sales @DATACOL 1 DESC This example will sort the rows of data returned with the member name of Sales on data column one in descending order data value order DECEMBER 2009 UNITED STATES MYR 2009 2 DOOR SEDAN SALES 120 NOVEMBER 2009 UNITED STATES MYR 20092 DOOR SEDAN SALES 1150 OCTOBER 2009 UNITED STATES MYR .

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.