You cannot create calculated fields or calculated items in reports with OLAP source data. With other types of source data, you can change subtotal summary functions and show or hide subtotals for all row and column fields.
For OLAP source data, you can include or exclude hidden items when you calculate subtotals and grand totals.
For other types of source data, you can include hidden report filter field items in subtotals, but hidden items in other fields are excluded by default.
Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Late shipments of raw materials translates into late products and an increasing number of related consumer complaints.
Speed-of-thought analysis is a key component that enables this kind of drill-down investigative work across multiple functional areas. Quick response times are possible because OLAP systems pre-aggregate data.
Pre-aggregation means that there is no need for many time-consuming calculations when an end-user query is processed. In addition, OLAP systems are optimized for business calculations, so calculations take less time to execute. OLAP systems make the analysis process easy for analysts by supporting tools they already use. For example, many OLAP systems support commercial spreadsheet tools such as Microsoft Excel or offer their own spreadsheet interface.
The best report designers and builders usually come from within the business community itself because they know what is needed. Enabling these people to create their own reports is a hallmark of an OLAP system.
OLAP systems enable business users to query data and create reports using tools that are natural for them to use. Providing tools that are familiar to end users means that their learning curve is reduced, so they are more likely to use the system.
In addition to commercial and custom spreadsheet applications, OLAP systems support other front-end reporting tools that are designed with business users in mind. For example, they include user-friendly tools that enable report designers to create and publish web-based dashboards and interactive reports using live OLAP data.
The consumers of interactive reports are often able to customize their view of the data. When business users can build their own reports, it reduces the reliance on IT resources for generating reports. Without an OLAP system, IT departments are often called upon to create a multitude of materialized views and specialized reports for business users on demand. As with any application geared to business users, the front-end tools must be intuitive and flexible enough to be employed by casual users.
That said, as with any new tool, people need to be trained on how to use these reporting facilities effectively. If end users deem the system too hard to use, they will not adopt it. Business users flocked to the flexibility and ease of use. When these variables are tracked on a spreadsheet, they are set on axes x and y where each axis represents a logical grouping of variables in a category. To analyze and report on the health of a business and plan future activity, many variable groups or parameters must be tracked on a continuous basis—which is beyond the scope of any number of linked spreadsheets.
Analysts can take any view, or Slice, of a Cube to produce a worksheet-like view of points of interest. Rather than simply working with two dimensions standard spreadsheet or three dimensions for example, a workbook with tabs of the same report, by one variables , companies have many dimensions to track—-for example, a business that distributes goods from more than a single facility will have at least the following Dimensions to consider: Accounts, Locations, Periods, Salespeople and Products.
The capability to perform the most sophisticated analyses—-specifically, the multidimensional analysis provided by OLAP technology—is an organizational imperative. Analysts need to view and manipulate data along the multiple dimensions that define an enterprise—essentially, the dimensions necessary for the creation of an effective business model.
OLAP technology implementations depend not only on the type of software, but also on underlying data sources and the intended business objective s. What is OLAP? Report a Bug. Previous Prev. Next Continue. Home Testing Expand child menu Expand. SAP Expand child menu Expand. Web Expand child menu Expand. Must Learn Expand child menu Expand. Big Data Expand child menu Expand. Live Project Expand child menu Expand. AI Expand child menu Expand.
0コメント