尤尼佳34_BEDINGUNGEN2_E.docVIP

Business Information Warehouse BW 3.0December 2001 In Business Information Warehouse, different functions are available for displaying key figure values by using the OLAP processor. This paper will describe how the functions for conditions, ranking lists, and zero suppressions can be used in the different list types (the different drilldown statuses in a query). Among the different output functions for key figure values are dependencies, which influence the result of a query according to the display and drilldown status. For example a query, that displays the top ten customers and their respective top twenty products, delivers another result as a report that displays the top 200-customer/product combinations. On the other hand, one would get another result if one selected the top twenty products and their respective top ten customers. The drilldown of characteristics likewise influences the result in columns, in rows, or in both directions. Again, there are dependencies for additional OLAP functions, such as sorting, suppressing results, or selecting a presentation hierarchy. Also note that a structure from the list can be partially used as a drilldown characteristic, although it differs strongly in its technical aspects and with regard to its contents. Additional, important terms will be explained below. Display Hierarchies. In addition to the already mentioned presentation hierarchies (a single characteristic is displayed along with an external hierarchy as a tree), there are display hierarchies. Several characteristics are drilled down successively here, and a specification for every higher display level is the aggregate for the respective characteristic lines or columns on the lower level. The total result then has level 0. For the following analyses and for processing, it is irrelevant whether the totals are displayed above, below, or on the left-hand side. Frequently, several of the following characteristics that are directly on top of each other are