S



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



Practical Business Intelligence with SQL Server 2005
Practical Business Intelligence with SQL Server 2005
ISBN: 0321356985
EAN: 2147483647
Year: 2007
Pages: 132

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net