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] scalability Analysis Services SQL Server database engine SCDs (slowly changing dimensions) 2nd Analysis Services and backups changing dimension tables for deployment detecting changes in source data for wide dimension tables processing in Analysis Services Slowly Changing Dimension transformation translating business keys to surrogate keys Type 1 SCD Type 2 SCD scheduling jobs scope of package variables scorecard applications Analysis Services database KPIs (key performance indicators) many-to-many relationships parent-child dimensions perspectives security setup backing up Business Scorecard Manager dimensional modeling FrontPage Microsoft Office 2007 Reporting Services reports adding charts adding KPIs parameters for Analysis Services queries WSS (Windows SharePoint Services) adding PivotTable views to site adding reports to site creating team site deployment security scripting in SQL Server Management Studio security data mining 2nd for Analysis Services administrators for data warehouses application access database adminstrator access user access in Analysis Services 2nd 3rd packages Reporting Services 2nd SQL Server database engine WSS (Windows SharePoint Services) segmentation with clusters (data mining) self-referencing dimensions 2nd [See also parent-child dimensions.] semi-additive measures 2nd 3rd Sequence Clustering algorithm sequence numbers, detecting changes in source data sequence of dimension members, changing server-based solution, Reporting Services as servers, deploying reports to Service Broker shared data sources for reports silence interval (proactive caching) silence interval override (proactive caching) similarity rank (fuzzy matching) Slowly Changing Dimension transformation slowly changing dimensions (SCDs) 2nd Analysis Services and backups changing dimension tables for deployment detecting changes in source data for wide dimension tables processing in Analysis Services Slowly Changing Dimension transformation translating business keys to surrogate keys Type 1 SCD Type 2 SCD snapshot isolation for proactive caching 2nd snapshots 2nd of reports snowflake design in data warehouse dimensional model slowly changing dimensions (SCDs) and star design versus source control Analysis Services databases data integration process spreadsheet loading SQL Profiler Analysis Services and SQL Server components of deploying data warehouses, changing default settings full-text search maintenance plans for data warehouses Notification Services Service Broker SQL Server Agent SQL Server Analysis Services [See Analysis Services.] SQL Server database engine availability job scheduling management of scalability security very large database support SQL Server Destination SQL Server Integration Services (SSIS) [See Integration Services.] SQL Server Management Studio Analysis Services and prediction query builder Reporting Services and scripting actions SQL Server notification SQL Server Reporting Services [See Reporting Services.] SSIS (SQL Server Integration Services) [See Integration Services.] staging database (data warehouses) star design 2nd snowflake design versus storage of data warehouse files strategy [See scorecard applications.] subscriptions to reports 2nd subtotals in reports success of BI projects, measuring summary information in reports support (data mining) surrogate keys adding to dimension tables in partitioned tables referential integrity (RI) and translating business keys into 2nd 3rd synchronization, Database Synchronization synonyms in dimensional data models System Monitor |