Summary
The business layer is the user interface to the physical columns in the data source. The IDT provides four main types of objects to help users differentiate between types of information more easily: folders, measures, dimensions, and attributes. This chapter covered the basics of navigating the business layer and creating different kinds of objects, and highlighted some important design principles:
• Sort dimension objects from biggest to smallest to facilitate drill-down.
• Follow the four Cs in naming objects: be customer-oriented, clear, consistent, and concise.
• Ensure object types and data field types match the type in the physical database.
• Point dimension objects to lookup tables.
• Always use SQL aggregates on measure objects. ...
Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
