Crystal Report from OLAP Data Introduction - Choosing a CUBE

(Page 3 of 4 )

The Server may have many databases, each with their own 'Cubes'. In this case, "Cubes" in the "Tutorial" database will be used, therefore "Tutorial" is chosen:

For the report, the data is obtained from a 'Cube' called 'Sales' and this serves the data for the report

Cross-tab report from OLAP Report Expert

OLAP is closely related to the 'Cross-tab' report used in the financial and accounting fields. The OLAP report generated by Crystal Reports resembles the 'Cross-tab' report and follows similar lines. For example, the dimensions are used in defining rows and columns of the report as follows (make use of the drag and drop features for rows and columns):

Choosing the data to report

This is followed by going into more specifics of the report's requirements. Usually a subset of the data from each of these dimensions may be the only reporting items needed. This is carried out as shown here for the dimension 'Stores' (for example: only Stores in California are needed in the report):

Similar selections are made for the other dimensions.

Next: Choosing a style for the report >>
 

More Database Articles
More By Jayaram Krishnaswamy

Comments On: Crystal Report from OLAP Data Introduction

· I am welcoming you again for a fruitful discussion of this topic. The version of...    · I've created cube In Sql sever.. when i try to attach the report with OLAP...    · Your question is somewhat vague. Could you let me know at what stage of the wizard...    · can I use an Oracle OLAP cube with Crystal REports in the same manner as demostrated...   >>> Post your comment now!