Practical Business Intelligence with SQL Server 2005
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z] ranges, grouping numbers into RDL (Report Definition Language) files read access to data warehouses real-time business intelligence backing up dimensional modeling for importing data into data warehouse loading data directly Notification Services proactive caching enabling notification methods operational overview snapshot isolation 2nd tuning problems with multidimensional databases and data warehouses proactive caching as solution rolling partitions rebuilding dimension tables recovery model setting, changing referential integrity (RI) in data warehouses Relational OLAP (ROLAP) MOLAP versus relational tables, Analysis Services databases versus relationships between attributes between cubes and dimensions between dimension and fact views between dimensions many-to-many setup one-to-many renaming clusters (data mining) repeatable packages replication Report Builder 2nd report caching Report Definition Language (RDL) files Report Explorer web part Report Manager 2nd report models Report Viewer web part Reporting Services 2nd [See also reports.] accessing reports 2nd adding calculations to reports code to reports new reports parameters to reports architecture of as server-based backing up canceling long-running reports changes to reports charts database access datasets deploying reports to server dimensional modeling for drilling down reports drilling through reports end-user reporting interactive reports localization managing Report Builder report design 2nd report subscriptions reports in scorecard applications adding charts adding KPIs parameters for Analysis Services queries security 2nd snapshots subscribing to reports summary information types of reports web parts for adding reports to scorecard portal site Reporting Services Configuration Manager reports [See also Reporting Services ; scorecard applications.] accessing 2nd adding calculations to code to new reports parameters to to scorecard portal site against OLTP databases backing up building on relational tables versus Analysis Services databases canceling long-running reports changes to charts in database access deploying to server designing 2nd dimensional modeling for drilling down drilling through in scorecard applications adding charts adding KPIs parameters for Analysis Services queries integrating into Web sites interactive reports linked reports localization security shared data sources snapshots subscribing to 2nd summary information types of reprocessing data mining models resource constraints restartable packages restoring data warehouses restrictions on partitioned tables RI (referential integrity) in data warehouses ROLAP (Relational OLAP) MOLAP versus role-playing dimensions roles Analysis Services security 2nd package security rolling partitions in real-time business intelligence Row Count transform row counts, auditing data quality rows, converting columns to running packages in production in transactions |