D

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]

dashboard applications [See scorecard applications.]
data destinations, support for
data flow (packages) 2nd
     dimension loading
     for inferred members
     inspecting
     legitimately missing members
     VLDBs (very large databases)
data integration process
     granularity of data
     source control
     with Integration Services
         connection managers
         dimension loading
         Excel spreadsheet loading
         fact table loading
         multiple file loading
         package deployment
         package operation in production
         package security
data marts, data warehouses versus
data mining 2nd
     adding to Web applications
     algorithms for 2nd
     architecture for
     Association Rules algorithm
     creating mining structure
     Data Mining dimension
     data sources for
     deployment
     dimensional modeling for
     ETL process
     in Integration Services 2nd
     managing
     predictions
     reprocessing mining models
     security 2nd
     segmentation with clusters
     Sequence Clustering algorithm
Data Mining dimension
Data Mining Extensions (DMX) 2nd
Data Mining Query transformations
data modeling [See dimensional modeling.]
data quality
     auditing with row counts
     dimensional modeling
     error handling
     in ETL process
     merging data
     missing dimension members
     need for in BI projects
     null values
     of packages
     out-of-range values
     preventing bad source data
     unexpected values
     zero values
data source view (DSV)
data sources
     data integration process
         connection managers
         dimension loading
         Excel spreadsheet loading
         fact table loading
         granularity of data
         multiple file loading
         package deployment
         package operation in production
         package security
         source control
         with Integration Services
     detecting changes in source data
     for data mining 2nd
     for reports
     preventing bad source data
     support for
Data Transformation Services (DTS) [See Integration Services.]
data truncation errors
data types, matching source and destination
Data Viewer
data warehouses
     as solution to ERP (enterprise resource planning) systems
     backing up
     building reports against
     constraints and
     creating with BI Development Studio
     data integration process
         connection managers
         dimension loading
         Excel spreadsheet loading
         fact table loading
         granularity of data
         multiple file loading
         package deployment
         package operation in production
         package security
         source control
         with Integration Services
     data marts versus
     data quality
         auditing with row counts
         dimensional modeling
         error handling
         in ETL process
         merging data
         missing dimension members
         null values
         out-of-range values
         preventing bad source data
         unexpected values
         zero values
     deployment
     design of
     dimension tables, building
     dimensional modeling for
         business process focus
         granularity
         identifying dimensions
         identifying measures
     ETL (extraction, transformation, and loading)
         for data mining
     fact tables, building
     feeding to e-commerce systems
     importing data for real-time business intelligence
     maintenance plans
     naming standards
     OOD (object-oriented design) in
     problems with real-time business intelligence
         proactive caching as solution
     restoring
     security
         application access
         database administrator access
         user access
     slowly changing dimensions (SCDs)
         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
     Time dimension
     UDM (Unified Dimensional Model) versus
     VLDBs (very large databases)
         aggregations 2nd
         automated processing
         backing up
         cube partitions 2nd
         data flow
         Database Synchronization
         fact tables in
         initial loading
         large dimension support
         partitioned tables 2nd
         partitioned views
data, loading into cubes
data-driven subscriptions 2nd
database access for Reporting Services
database administrator access to data warehouses
database engine (SQL Server)
     availability
     job scheduling
     management of
     scalability
     security
     very large database support
Database Engine Tuning Advisor
database servers, deploying Reporting Services on
Database Synchronization (Analysis Services)
datasets in Reporting Services
DateDiff function
dates, loading slowly changing dimensions (SCDs) [See also time information.]
debugging packages
degenerate dimensions 2nd
deleted members, slowly changing dimensions (SCDs) and
deleting
     cube partitions
     partitions
deploying
     Analysis Services databases
     data mining models
     data warehouses
     packages 2nd
     Reporting Services
     reports to server
     slowly changing dimensions (SCDs)
     SQL Server components
     WSS (Windows SharePoint Services)
Deployment Wizard
Derived Column transforms
descriptive attributes [See attributes.]
designing
     aggregations for VLDBs (very large databases) 2nd
     dimensional data models
     packages
         control flows
         data flows
         debugging
     partitioned cubes
     partitioned tables
     reports 2nd
differential backups
dimension loading
dimension members [See inferred members; missing dimension members.]
dimension modeling in VLDBs (very large databases)
dimension table loading (data warehouses)
dimension tables
     building for data warehouses
     changing for slowly changing dimensions (SCDs)
     cube creation
     rebuilding
dimension views, relationships with fact views
dimensional modeling
     candidate attributes, listing
     candidate measures, listing
     data quality
     design process
     E/R modeling versus
     for data mining
     for data warehouse projects 2nd
         business process focus
         granularity
         identifying dimensions
         identifying measures
     for real-time business intelligence
     for reports
     hierarchies
    measures
         grouping into fact tables
         loading test data
     scorecard applications
     snowflake design
         star design versus
     star design
         snowflake design versus
     surrogate keys
     synonyms
dimensions (data warehouses)
     adding hierarchies to
    changing dimensions [See slowly changing dimensions (SCDs).]
     conformed dimensions
     Data Mining dimension
     degenerate dimensions
     fact dimensions
     identifying for data warehouse dimensional model
     large dimension support
     relationships between
     relationships with cubes
     setting up
     Time dimension
discretization feature (Analysis Services)
discriminating between clusters
display formats for measures
display values for attributes
distributed partitioned views (DPVs) 2nd
DMX (Data Mining Extensions) 2nd
DPVs (distributed partitioned views)
drilling down (OLAP)
drilling down reports 2nd
drilling through reports 2nd
drop outdated cache property (proactive caching)
DSV (data source view)
DTS (Data Transformation Services) [See Integration Services.]