| Description |
1 online resource (186 pages) |
| Contents |
Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started; Configuring Framework Manager; Starting Framework Manager; User interface; The Project Viewer pane; The Explorer tab; The Diagram tab; The Dimension Map tab; The Properties pane; The Tools pane; The Summary tab; The Search tab; The Dependencies tab; Toolbars; Summary; Chapter 2: Proven Practice; Modeling layers; Data layer; Logical layer; Presentation layer; Dimensional layer; How to create namespaces; How to create folders |
|
Using the Model AdvisorHow to use the Model Advisor; Facts identified by cardinality; Query subjects that can behave as facts or dimensions; Query subjects with multiple relationships; Query subjects that join to themselves; Determinants that conflict with relationships; Factors that will override the Minimized SQL setting; Embedded calculations that use the calculated aggregation type; Query subjects that can cause a metadata caching conflict; Summary; Chapter 3: Importing Data Sources; Importing relational data; Importing from an existing data source; Importing from a new data source |
|
Importing stored proceduresUsing prompts with a stored procedure; Importing additional database objects; Importing from the same data source; Importing from additional data sources; Importing OLAP data sources; Combining OLAP and relational data sources; After importing your data sources; Summary; Chapter 4: Modeling Relational Data; Cardinality; Detecting cardinality during import; Creating relationships and cardinality; Determinants; How to add determinants; Special purpose joins; Role playing dimensions; Reflexive and recursive joins; Where to model the relationships; Summary |
|
Chapter 5: Modeling Dimensional DataRegular dimensions; Creating a regular dimension; Dimensions with multiple hierarchies; Creating a multiple hierarchy dimension; Measure dimensions; Creating a measure dimension; Creating aggregation rules for measures; Scope relationships; Creating a scope relationship; Summary; Chapter 6: Creating the Business and Presentation Layers; Creating the business layer; Renaming columns; Hiding columns; Specifying attribute types; Adding filters; Embedded filters; Standalone filters; Adding calculations; Embedded calculations; Standalone calculations |
|
Adding promptsCreating prompts with Macros; Adding formatting; Data formatting properties; Using formatting patterns; Adding formatting; Creating the presentation layer; Grouping data items; Using folders and namespaces; Using shortcuts; Summary; Chapter 7: Creating and Publishing Packages; Creating a package; Making changes to a package; Publishing a package; Using package versioning; Using externalized query subjects; Creating externalized queries; Using the Dynamic Query Mode; Using package security; Summary; Chapter 8: Maintaining Projects; Analyzing the impact of changes made to packages |
| Summary |
Presented in a handson style, this guide presents you with real world examples to guide you through every process step by step. This book will be useful for any developer, novice or expert, who uses Framework Manager to build packages, but wants to expand their knowledge even further |
| Notes |
Analyzing publish impact |
|
Print version record |
| Subject |
Business intelligence -- Computer programs
|
|
Business report writing -- Computer programs
|
|
Database management -- Computer programs.
|
|
IBM software.
|
|
Database Management Systems
|
|
Business report writing -- Computer programs
|
|
Database management -- Computer programs
|
|
IBM software
|
| Form |
Electronic book
|
| ISBN |
9781849685771 |
|
1849685770 |
|
