TAILIEUCHUNG - Oracle Essbase 9 Implementation Guide- P17

Oracle Essbase 9 Implementation Guide- P17: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 3 The screenshot below shows the listing of the parent dimensions. The parent dimensions can be considered the root dimension members as there are no higher members in the hierarchical structure. The parent dimensions only have descendent or children members. Look closely the number in the braces like the 4 indicates the number of children under that dimension. Outline Properties Modifications Outline Esscar Active Alias Table Default 1 CALENDER PERIODS Time 2 TOTAL VEHICLES 4 TOTAL MARKET 3 J MODEL YEAR 2 Take a look as we expand the TOTAL VEHICLE dimension. In the following screenshot we see the TOTAL VEHICLE dimension expanded to reveal its four child members Outline Properties Modifications Outline Esscar Active Allas Table Default J CALENDER PERIODS Time 2 TOTAL VEHICLES 4 1 2 DOOR SEDAN 2 1 4 DOOR SEDAN 2 1 4X2 PICKUP 2 J TOTAL MARKET 3 J MODEL YEAR 2 Now you can clearly see the child members of the TOTAL VEHICLE dimension. Notice how each child member has two of its own children as evidenced by the 2 next to each member name. In the following screenshot you can see the TOTAL VEHICLE dimension expanded completely 65 Download at Building the Essbase Outline With the Total Vehicles dimension completely expanded we see all of the child or descendent members. We now know that we have reached the bottom level of the dimension because there is no child indicator n next to the member names. An Essbase outline dimension is the upper-most member in the multidimensional hierarchical database structure. The dimension member can have unlimited child members but has no parent member. The child member can be a child member of the dimension parent and can also be a parent or child to other members. Members those of which are not at the top level as dimension members can have virtually unlimited child members while at the same time being a child member themselves. Outline members that share the same parent are called siblings. Essbase is just one big happy

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.