Pro SQL Server 2008 Analysis Services- P11

Chia sẻ: Thanh Cong | Ngày: | Loại File: PDF | Số trang:11

0
65
lượt xem
6
download

Pro SQL Server 2008 Analysis Services- P11

Mô tả tài liệu
  Download Vui lòng tải xuống để xem tài liệu đầy đủ

Tham khảo tài liệu 'pro sql server 2008 analysis services- p11', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả

Chủ đề:
Lưu

Nội dung Text: Pro SQL Server 2008 Analysis Services- P11

  1. INDEX cube with dimensions and, 29 Mining Models view, 289, 291–292 CurrentMember function, 235, 245 Mining Structure view, 289, 290–291 custom member formulas, BI, 256 mining structures, SSAS, 65 date dimension, 29 Mining Structures folder, 282 default members, 226 MiningModel objects, SSAS, 51 DefaultMember property, 156 MiningStructure collection, SSAS, 51 Dimension Data tab, roles, 352 mirroring, SSAS databases, 202–204 finding previous or next member, 236 modes, dimensions leaf members, 221 ProcessingMode, 140 MDX notation, 222 specifying storage modes, 142–148 parent members, 221 StorageMode property, 141 PrevMember function, 245 MOLAP (multidimensional OLAP), 39, 54 RootMemberIf property, 158 data sources, SSAS, 61 selecting from dimensions, 221 scheduling OLAP maintenance, 215 selecting members of dimensions on cube, storage, dimensions, 141 30, 31 using partitions, 356 tuples, MDX, 224 MOSS (Microsoft Office SharePoint Server) 2007, using member key to select member, 222 420–423 using member names for annotations, 222 dashboard, 420, 421 Members function, 234 Excel Services, 421, 423 Membership tab, roles, 350 InfoPath Forms Server, 420 MembersWithData property, 157 KPI lists, 420, 421–423 MembersWithDataCaption property, 158 moving averages calculation, 253 metadata MSAS 2008: Xyz counter groups, 338 attributes, dimensions, 21 msmdsrv.exe, 52 cube and measure group metadata locations, changing Config.ini file location, 54 55 multidimensional analysis Metadata tab, Cube Designer, 262 history of OLAP, 7 Calculations page, 187 multidimensional data, 3 creating calculated measure, 190 multidimensional expressions see MDX methods multidimensional OLAP see MOLAP deployment methods, databases, 198 multisnowflake schema, 120 Microsoft Clustering algorithm, 276 Microsoft Data Mining Extensions see DMX Microsoft Decision Trees algorithm, 277 N Microsoft Management Console (MMC) snap-in Naïve Bayes algorithm, 276 OLAP Services, 8 Naïve Bayes mining model Microsoft Naïve Bayes algorithm, 276 Accessory Buyers campaign, 305 Microsoft Office SharePoint Server see MOSS named calculations mining see data mining creating, 110–112 Mining Accuracy Chart view DSV, 110–112 Data Mining Model Designer, 289, 297–299 named queries, 62 mining algorithms see data mining algorithms creating, 113 Mining Legend DSV, 112–116 exploring decision tree, 294 named query designer, 112, 113 Mining Model Prediction view, 289, 299–303 named sets, 251, 262 Mining Model Viewer view, 289, 292–297 dynamic named sets, 262 exploring decision tree, 292–295 static named sets, 262 using Dependency Network, 296–297 NamingTemplate property, 158 using drill-through to view training cases, 295–296 451
  2. INDEX natural hierarchies measure groups, 184 attribute relationships, dimensions, 151 measures, 27–31, 182, 233 navigator calculated measures, 33–34 using DSV table navigator, 106 multidimensional OLAP (MOLAP), 39, 54 New Calculated Member, Cube menu, 186 relational OLAP (ROLAP), 39, 54 New Job Step dialog, 217 scheduling maintenance, 215–217 New Partition Wizard, 358 schemas, 18–20 New Project dialog, 83, 84 setting up Adventure Works, 434 creating data sources, 102 Solution Explorer, 79–80 New Project wizard, BIDS, 8 SQL Server Analysis Services, 41–65 Node_Xyz columns Time dimension, 159–166 viewing Accessory Buyers mining model, user-friendly interfaces for OLAP solutions, 307 373–429 nonadditive measure, aggregations, 32, 183 Excel 2007, 373–398 None measure, aggregations, 183 MOSS 2007, 420–423 Non-Empty Behavior setting PerformancePoint Server, 423–429 calculated measures, 261 SQL Server Reporting Services, 401– Nonempty function, MDX, 237–239 420 notification options, dimension storage Visio 2007, 399–401 Client Initiated option, 142 using Excel to analyze OLAP data, 6, 7 Scheduled Polling option, 142 writeback, 32–33 SQL Server option, 141 XMLA (XML for Analysis), 35 Notifications tab, storage options OLAP engines specifying dimension storage modes, 145 count measure, 27 hierarchies, 25 time-based analysis, 26 O OLAP objects, SSAS, 50 Object Details pane, 214 OLAP query language, 6, 219 Object Explorer pane, 214 see also MDX scheduling OLAP maintenance, 217 OLAP Server Formatting section Object list Connection Properties dialog, Excel, 378 Impact Analysis dialog, 211 OLAP Services Process dialog, 209 history of OLAP, 8 object model, SSAS, 51 one-to-many relationships OLAP (Online analytical processing) attribute relationships, dimensions, 151 actions, 34–35, 265–270 Currency dimension, 140 aggregation, types of, 31–32 relationship types, 180 AMO design warnings, 135 Online analytical processing see OLAP applications of, 5–7 operators axes, 233 unary operators, BI, 255–256 configuring storage for, 38–39 options cubes, 15–18 processing, Analysis Services, 335–336 data source connections to Excel, 374–378 Options tab dimension table, 18 pivot tables, Excel 2007, 381, 391 dimensions, 20–27 OrderBy property, 156 fact table, 18 OrderByAttribute property, 156 history of, 7–8 ordering hybrid OLAP (HOLAP), 39–54 attribute ordering, BI, 257 introduction to, 1 Organization dimension, 137 MDX, 36–37 Output Path property, 197 452
  3. INDEX P Dashboard Designer, 424, 425 scorecard, 423, 424 panes, BIDS, 76–79 period to date calculation, 252 Properties pane, 80–82 periodic growth calculation, 253 Solution Explorer, 79–80 PeriodsToDate function, MDX, 247, 248 tearing off, 78 persp folder, 57 UI for docking panes, 78 Perspective collection, SSAS, 51 Parallel processing, Change Settings dialog, 335 Perspective Designer, 270, 271 ParallelPeriod function, MDX, 247, 248 perspectives, 251, 270–272 trend indicators, KPIs, 264 choosing Standard/Enterprise SSAS, 46 Parent function, MDX, 239 folders for, 57 Parent hierarchy, Cube Designer, 190 physical architecture, SSAS, 52–54 parent members, 221 changing INI file location, 54 parent-child dimensions, 157–159 pivot charts, 374, 386–398 data members for nonleaf members in, adding product categories to, 392 158 Analyze tab, 388 setting Unary Operator on parent attribute, applying color bar conditional formatting, 139 397 parentheses, MDX, 227, 237 creating, 387 partition folders, AdventureWorks cube, 57–58 Design tab, 388 partition jobs, 337 Format tab, 388 partitioned cubes grouping products, 394 choosing Standard/Enterprise SSAS, 46 Layout tab, 388 partitions selecting chart type, 387, 388 aggregation design, 361 PIVOT command, SQL, 220, 221 Analysis Services, 359 pivot currency, 258 defining slice of, 359 pivot diagrams, Visio 2007, 399, 400 New Partition Wizard, 358 Pivot Table Services, 8 reasons for using, 356 Pivot Table task pane, 380–381 Specify Options for Partitions and Roles pivot tables, 1, 374, 379–386 screen, 199, 200 building report, 123 specifying partition locations, 204 Cell Styles gallery, 383 SSAS performance management, 356–359 changing appearance and layout, 382 Partitions tab, 356, 357 conditional formatting for values, 383, 384 enabling/disabling Excel writeback, 313 creating custom groupings, 381 path to executable file, SSAS, 52, 53, 54 cubes and, 15 performance dangers of using cell references with, 386 key performance indicators, 263–265 design ribbon, 382 SQL Server 2008, 65–69 dimensional processing, 2–4 writeback, 68 formats, 382 performance management, SSAS, 352–371 formatting, 383–385 aggregations, 359–367 formulas using values from, 385–386 design, 352–359 GETPIVOTDATA function, 385 scalability, 367–369 graphical view of data, 386 SharePoint Server 2010, 369–371 opening style gallery, 382 virtualization, 369 Options tab, 381, 391 Performance Monitor, 337–339 Pivot Table task pane, 380–381 PerformancePoint, 373 PivotTable options ribbon, 381 PerformancePoint Server (PPS), 423–429 PivotTable tools ribbons, 381–382 building scorecard in, 425–429 PowerPivot pivot table in Excel, 323, 324 renaming, 381 453
  4. INDEX pivot tables (cont.) primary key, table setting options, 317 fact table, 169 using Excel writeback, 315–319 self-referential table, 138 using MDX to produce, 232 priorities with multiple slicers, 325 ProcessingPriority, dimensions, 140 PivotTable design ribbon, 382 ProactiveCaching property PivotTable options ribbon, 381 dimensions, 141, 144 PivotTable Style Options section, 382 measure groups, 185 PivotTable Styles gallery, 382 Process affected objects option polling Change Settings dialog, 336 Scheduled Polling option, notifications, Process checkbox, roles, 351 142 Process Clear Structure option PowerPivot, 311 Process Cube dialog, 335 connecting with SSMS, 330, 331 Process Cube dialog entity relationship designer, 323 AdventureWorks cube, 333–334 Excel add-in, 320 Change Settings button, 335 Excel writeback, 313–320 Process Options drop-down list, 334 from Excel, 320–326 Process Data option importing tables from SQL Server, 322, 323 Process Cube dialog, 210, 335 Master Data Services, 311–313 Process Default option pivot table in Excel, 323, 324 Process Cube dialog, 210, 334 pivot table with multiple slicers, 325 Process dialog support in SQL Server 2008 R2, 311–320 BIDS, 208, 209 with SharePoint Server 2010, 326–331 SSMS, 214 PowerPivot Designer, 321, 322 Process Dimension window creating relationships, 323 creating dimensions, 131 PowerPivot for SharePoint see VertiPaq mode specifying dimension storage modes, 147 PowerPivot Gallery, 326, 327 Process Full option PowerPivot management dashboard Process Cube dialog, 210, 334 SharePoint Server 2010, 369, 370 Process Incremental option Workbook Activity Chart, 370, 371 Process Cube dialog, 334 PowerPivot tab, Excel, 320, 321, 323 Process Index option PowerPivot workbook Process Cube dialog, 210, 334 connecting to worksheet, 328, 329 Process method data loaded into Report Builder, 329, processing Analysis Services objects from 330 AMO, 215 in Excel Services, 326, 327, 328 Process Mining Structure dialog publishing to SharePoint Server, 326 Data Mining Model Designer, 290, 291 PowerShell, 92–95, 343 Process Options drop-down list for SQL Server, 93–94 Process Cube dialog, 334 getting BIOS data, 93 Process Progress dialog listing databases using, 93 processing Analysis Services objects from Windows PowerShell, 92 BIDS, 212, 213 with SSAS, 94–95 Process Structure option PPS see PerformancePoint Server Process Cube dialog, 335 prediction column Process Update option Clustering algorithm, 277 Process Cube dialog, 210, 334 Decision Tree algorithm, 277 processing Analysis Services objects, 204 Naïve Bayes algorithm, 276 automating cube processing, 339 Prediction Query Builder, 299 availability when processing, 208 PrevMember function, MDX, 245 from AMO, 215 454
  5. INDEX from BIDS, 208–214 ProspectiveBuyer table from SSMS, 214 creating Accessory campaign DSV, 281 from XMLA, 215 providers, data sources, 99 processing cubes, 333–335 scheduling cube processing, 343 Processing Option property, 197 Q Processing options tab Quantitative dimension, 137 Change Settings dialog, 211, 335 queries processing options, Process dialog, 210 see also MDX queries Processing Order section creating chart in SSRS 2008, 415 Change Settings dialog, 335 named queries, 62 processing properties, dimensions, 140 named queries, DSV, 112–116 processing settings in SSIS, 347 named query designer, 112 ProcessingMode property Prediction Query Builder, 299 dimensions, 140 query-scoped calculated measure, 236 measure groups, 185 Save Data Mining Query Result dialog, 303 ProcessingPriority, dimensions, 140 using partitions, 356, 358 ProClarity, 373, 401 Query Binding option, Binding type, 357 Product dimension, 137 query cancellation, SQL Server 2008, 67 Product Key attribute, 154 Query Designer Profiler trace, Analysis Services, 337 building reports with tablix, 406, 407 Profiler, SQL Server, 337 query language, OLAP, 6 Program Menu Shortcuts option Query timeout, Data Source Designer, 100 Adventure Works, 432 QueryLogConnectionString property, 366 project properties see properties, project QueryLogTableName property, 366 project properties dialog, 196, 197 projects creating, Analysis Services, 82–84 R deploying, 195–198 importing database into, 86 RAID New Project dialog, 83, 84 hardware requirements, SSAS, 42 setting up Adventure Works, 431–434 random line, Lift Chart tab Promotion dimension, 137 Mining Accuracy Chart view, 298 specifying storage modes, 142 Rates dimension, 137 properties recursive data structures, 157 see also dimension properties referenced/regular relationships attribute properties, 156 associating dimensions with measures, 63 Specify Configuration Properties screen, 200, relationship types, 180 201 Related Tables page, 152 Properties dialog relational data models, 97 Configuration Manager button, 196 relational databases, cubes and, 18 Properties pane, 80–82 relational OLAP see ROLAP attribute properties, 156 relationship types, 180–181 grouped properties, 81 relationships selecting object in, 81 associating dimensions with measures, 63 specifying dimension storage modes, 144 attribute relationships, dimensions, 150–156 toolbar, 81 creating, PowerPivot Designer, 323 properties, project, 195–197 dimensions and measures, 324 opening project properties, 196 flexible relationships, attributes, 151 project properties dialog, 196, 197 relating measures and dimensions, 179–181 Proprietary action type, 269 rigid relationships, attributes, 151 455
  6. INDEX Remove Passwords property, 197 Save Data Mining Query Result dialog, 303 Report Builder scalability, 367–369 PowerPivot data loaded into, 329, 330 choosing Standard/Enterprise SSAS, 45 SQL Server Reporting Services, 418–420 scenario analysis, 32 reporting actions, 267, 268 Scenario dimension, 137 Reporting calendar, Date dimension, 160 writeback, 314 Reporting Services, SQL Server, 401–420 Scheduled Polling option, notifications, 142 reports scheduling building Excel report, 121–125 OLAP maintenance, 215–217 SQL Server Reporting Services, 267, 401–402 processing Analysis Services objects, 343–345 Restore deployment method, 198 Schema Generation wizard result sets creating Date dimension, 164 creating SQL crosstab result set, 220 schemas, OLAP, 18–20 Results grid, 307 advantage of simplicity, 120 revenue, KPIs, 263 AdventureWorks schema, 120 Review Aggregation Usage screen, 362 multisnowflake schema, 120 rigid relationships, attributes, 151 snowflake schema, 18, 19, 20, 119 ROLAP (relational OLAP), 39, 54 star schema, 18, 19, 20, 119, 120 data sources, SSAS, 61 scorecard, PerformancePoint Server, 423, 424 scheduling OLAP maintenance, 216 building scorecard in PPS 2007, 425–429 storage, dimensions, 141 Script Organizer pane, Cube Designer, 186 using partitions, 356 calculated measures, 260 Role objects, SSAS, 51 security roles Active Directory, 348 authorization, 349–352 Analysis Services, 352 Cell Data tab, 351 dimension security, 351 Cubes tab, 350 Security tab, Server Properties dialog, 350 Data Sources tab, 350 security, Analysis Services, 348 Dimension Data tab, 352 authentication, 348–349 dimension security, 351 authorization, 348, 349–352 Dimensions tab, 351 segmentation algorithms, 276 drill-through actions, 350 Select Calendars page, 162, 163 General tab, 349, 350 Select Chart Type dialog, 415 managing Analysis Services, 90 Select Creation Method page Membership tab, 350 Cube Wizard, 174 Process checkbox, 351 Dimension Wizard, 128, 152 Read Definition checkbox, 350 Select Data Source View dialog, 283, 284 Server role, 350 Select Definition Method dialog, 282 Show Advanced (All) Properties checkbox, Select Dimension Attributes page, 129, 130, 153 350 Select Existing Dimensions page, Cube Wizard, 173, Specify Options for Partitions and Roles 176 screen, 199, 200 Select Measure Group Tables page, Cube Wizard, Roll your own method, 161 170, 174, 175 RootMemberIf property, 158 Select Measures page, Cube Wizard, 171–172, 175, Rowset action type, 269 176 Select New Dimensions page, Cube Wizard, 176, 177 S Select statement sample databases, 431 viewing Accessory Buyers mining model, 306 SANs (storage-area networks), 42 SELECT statement, MDX, 229–232 WHERE clause, 232–233 456
  7. INDEX Select Tables and Views page data sources, BIDS, 98 creating DSV, 107 opening, 79 semiadditive measures, aggregations, 32, 183 opening project properties, 196 choosing Standard/Enterprise SSAS, 45 solution tabs, BIDS 2008, 77 Time dimension, 159 sources see data sources Sequential processing, Change Settings dialog, 335 sparse data set, 4 Server property, properties dialog, 197 Specify Column Content and Data Type dialog, 287 Server role, 350 Specify Configuration Properties screen, 200, 201 servers Specify Naming Conventions page, 164 selecting source server and database, 203 Specify Object Counts screen, 362, 363 service account, Data Source Designer, 100 Specify Options for Partitions and Roles screen, 199, Services applet 200 specifying dimension storage modes, 146 Specify Source Information page session-scoped calculated measure, 236 creating dimension, 128, 129 Set Aggregation Options screen, 363, 364 with attribute relationships, 152 sets, MDX, 221, 228 Specify Table Types dialog, 284, 285 named sets, 262 Specify Target page, 164 notation, 222–223 Specify Training Data dialog, 285, 286 SharePoint Server, 369–371 spreadmarts, 320 MOSS 2007, 420–423 SQL (structured query language) PowerPivot Gallery in, 326, 327 creating SQL crosstab result set on server, PowerPivot management dashboard, 369, 220 370 MDX and, 219–221, 235 PowerPivot with, 326–331 PIVOT command, 220 publishing PowerPivot workbook to, 326 results from query using, 221 SharePoint workflows, MDS, 313 tabular results from query, 220 shortcuts SQL Server Program Menu Shortcuts option, 432 importing tables from, PowerPivot, 322, 323 Silverlight applet, Adventure Works, 431 PowerShell for, 93–94 skeleton dimensions, creating, 170 setting up Adventure Works, 433 Slicer Tools tab, Excel, 325 SQL Server 2000 slicers choosing Standard/Enterprise SSAS, 45 adding to tables, 325 upgrading to 2005, 44 Excel 2010, 323 SQL Server 2005 MDX queries, 233 Analysis Services, 8 pivot table with multiple slicers, 325 choosing Standard/Enterprise SSAS, 45 slices folder hierarchy, 52 defining slice of partitions, 359 upgrading from 2000, 44 slowly changing dimensions (SCD), 21–23 upgrading to 2008, 44 snowflake schema SQL Server 2008 attribute relationships, 150, 151 Aggregation Designer, 72 dimensions, 119 AMO design warnings, 72 multisnowflake schema, 120 block computing, optimization, 68 OLAP, 18, 19, 20 Change Data Capture, 68 Solution Explorer, 79–80 choosing Standard/Enterprise SSAS, 45 Analysis Services cube in BIDS, 60, 61 dimension design, 69–71 creating cubes, 170, 173 dynamic management views, 68 creating data sources, 102 folder naming, 53 creating data-mining model, 282 installation, software requirements for, 44 creating DSV, 107 Management Data Warehouse, 65–67 Cubes folder, 170 new features, 65–73 457
  8. INDEX SQL Server 2008 (cont.) hardware requirements, 41–42 performance, 65–69 hybrid OLAP (HOLAP), 54 query cancellation, 67 installing, 41 tools, 69–73 interacting with, 75 upgrading from 2005, 44 KPI lists, MOSS 2007, 422, 423 usage-based optimization, 71 logical architecture, 49–51 writeback performance improvements, 68 multidimensional OLAP, 54 SQL Server 2008 R2 notification options, dimension storage, 141 Master Data Services, 311–313 path to executable file, 52, 53, 54 PowerPivot support in, 311–320 performance management, 352–371 SQL Server Agent perspectives, 251 scheduling OLAP maintenance, 216, 217 physical architecture, 52–54 scheduling processing of Analysis Services PowerShell, 92–95 objects, 344–345 pre-calculation caching, 359 SQL Server Analysis Services see SSAS preparing aggregations for use, 365 SQL Server Analysis Services Properties screen processing Analysis Services objects, 204, 205 Log On tab, 146 relational OLAP, 54 SQL Server Integration Services see SSIS root for SSAS storage, 54 SQL Server Management Studio see SSMS scheduling OLAP maintenance, 217 SQL Server option, notifications, 141 security, 348–352 SQL Server Profiler, 337 setting up Adventure Works, 434 SQL Server Reporting Services see SSRS specifying dimension storage modes, 142– SQL Server Standard Edition 148 installation, software requirements, 44 specifying dimension types in, 138 SQL Server x64 (64-bit) SQL Server Management Studio, 86–92 installation, software requirements, 44 startup parameters, 53 SQL Server x86 (32-bit) storage, 54–59 installation, software requirements, 44 unified dimensional model, 46–49 SQLCMD command-line parameter using DMX development environment, 303 Adventure Works, 434 VertiPaq mode, 320 square brackets, MDX, 222 viewing details of cube in SSMS, 9 SSAS (SQL Server Analysis Services), 8–13, 41–65 virtualization, 43–44 see also Analysis Services Windows Service properties, 53 account intelligence, 255 SSAS 2000, 9 architecture, 46–59 SSAS 2005, 9, 10 authentication, 348–349 SSAS catalogs authorization, 348, 349–352 creating folder for, 56 building reports with tablix, 405 file storage for, 57 Business Intelligence Development Studio, SSAS databases 75–86 Connect to Database dialog, 84, 85 choosing Standard or Enterprise Edition, 45– creating folder, 56 46 data sources, 98 configuration files for SSAS solution, 201 importing into new project, 86 creating calculated measure, 190–193 listing using PowerShell, 93 creating Date dimension, 161 opening, 84–85 cube structures in, 59–65 as part of project, 85–86 DBA tasks, 333–348 selecting source server and, 203 Deployment Wizard, 198–201 synchronizing, 202–204 dimensions, 127–148 SSAS objects attributes, 148–156 selecting storage location for, 56 files in data sets, 58 458
  9. INDEX SSAS performance management SSRS (SQL Server Reporting Services), 401–420 aggregations, 359–367 charts, 410–418 attributes design, 353–355 configuring axis in SSRS 2008, 413 design, 352–359 creating chart in SSRS 2008, 413–418 dimensions, 353 Report Builder 2.0, 418–420 partitions, 356–359 reports, 267, 401–402 scalability, 367–369 tablix, 402–410 SharePoint Server 2010, 369–371 user-friendly interfaces virtualization, 369 for OLAP solutions, 373 SSAS Processing Task working with charts in SSRS 2005, 412 scheduling OLAP maintenance, 215 staging databases SSAS server BI solution, 48 staging databases cleaning data before, 49 cleaning data before SSAS server, 49 SSAS server properties data storage, OLAP, 38 setting default data directory in, 55 scheduling OLAP maintenance, 215 SSAS task pane, Visio 2007, 400 Standard Edition, SSAS SSIS (SQL Server Integration Services) choosing Enterprise edition or, 45–46 executing actions as part of process, 345–348 standard folder, Adventure Works, 434 processing settings in, 347 star schema scheduling OLAP maintenance, 215 advantage of simple schemas, 126 SSIS designer in BIDS, 346 attribute relationships, 150, 151 SSIS transformations, 170 dimensions, 119, 120 SSMS (SQL Server Management Studio), 86–92 OLAP, 18, 19, 20 connecting to Analysis Services Server, 366 Start Object property, 197 connecting to PowerPivot with, 330, 331 startup parameters, SSAS service, 53 cube browser in, 90 Statement action type, 270 cubes and measure groups in, 89 statements, MDX, 36 editing connection string for data source in, static named sets, 262 88 statistics, account intelligence, 255 executing MDX queries, 91–92 Status (indicator and expression), KPIs, 263 managing Analysis Services, 87–90 storage see data storage, OLAP cubes, 89–90 storage file extensions, dimensions, 59 data source views, 88–89 storage modes, OLAP, 38–39 data sources, 87–88 storage properties, dimensions, 141–142 data-mining structures, 90 Client Initiated option, 142 dimensions, 90 Scheduled Polling option, 142 roles, 90 SQL Server option, 141 managing SQL Server Agent, 344 storage, SSAS, 54–59 MDX Designer, 236 file storage for SSAS catalogs, 57 MDX queries, 229 storage-area networks (SANs), 42 MDX query editor, 91 StorageLocation property processing Analysis Services objects from, measure groups, 185 214 StorageMode property setting up Adventure Works, 434 dimensions, 141 specifying dimension storage modes, 143, measure groups, 185 146 stovepipes, MDS, 311 Synchronize Database Wizard, 202–204 Structure Only setting testing MDX expressions and queries, 229 processing Analysis Services objects from using DMX development environment, 303, BIDS, 211 304 Subcategory attribute viewing details of SSAS cube in, 9 processing Analysis Services objects, 206 459
  10. INDEX Subject Area Database Schema Options page, ParallelPeriod, 247, 248 164 PeriodsToDate, 247, 248 Suggest button, Select Measure Group Tables PrevMember, 245 page, 171 YTD, 248 Synchronize Database wizard, 198, 202–204 time intelligence, 252–254 system performance time tables, methods for creating, 160 Performance Monitor, 337 time-based analysis, OLAP engines, 26 tool tips creating tool tip with dimension attribute, 21 T tools, SQL Server 2008, 69–73 Table Binding option, Binding type, 357 TopCount function, MDX, 242–244 table browser, DSV designer, 106 top-down design, data warehouses, 37 tables Transactional Deployment property, 197 see also pivot tables Translation Designer, 272 Add/Remove Tables Wizard, 127 translations, 251, 272–273 adding slicers to, 325 tree functions, MDX, 239–241 creating dimension, 127 Ancestor function, 239 dimension table, OLAP, 18 ancestors and descendants, 240 DSV, 108, 169 Children function, 240 fact table, OLAP, 18 Parent function, 239 finding tables, DSV designer, 106 trend indicator, KPIs, 264 hierarchical dimension tables, 23 tuples, MDX, 223–227 importing from SQL Server, 322, 323 Average function, 228 methods for creating time tables, 160 notation, 222–223 replacing, DSV designer, 106–109 parentheses, 227 Report Builder 2.0, 419 selecting members from dimensions, 221 Reseller Sales table, 169 sets, 228 self-referential table, 138 Type property Specify Table Types dialog, 284, 285 dimensions see dimension types SQL Server Reporting Services, 403 measure groups, 185 tablix, SSRS, 402, 404 using DSV table navigator, 106 tablix U SQL Server Reporting Services, 402–410 UBO (usage-based optimization), 71 Target type UBO Wizard, BIDS 2008, 72 general actions, 268 UDM (unified dimensional model), 46–49 reporting actions, 267 data source view, 62 task pane, Pivot Table, 380–381 SSAS 2005, 10 templates Unary Operator NamingTemplate property, 158 setting on parent attribute, 139 Templates tab, Cube Designer, 262 unary operators, BI, 255–256 Text Box Properties dialog, 409 UnaryOperatorColumn property, 158 Time dimension, 137, 138, 159–166 unbalanced hierarchy, 25 creating Date dimension, 161–166 unified dimensional model see UDM finding previous or next member, 236 UnknownMember property, dimensions, 148 semiadditive measures, 183 Unprocess option time dimensions, 26–27 Process Cube dialog, 335 cubes, 161 processing Analysis Services objects from time functions, MDX, 245–249 BIDS, 210 CurrentMember, 245 460
  11. INDEX upgrading Web application SQL Server 2000 to 2005, 44 user authentication, 349 SQL Server 2005 to 2008, 44 web sites, data mining, 435 URL Welcome page, Cube Wizard, 173, 174 creating URL from dimension members, 35 Welcome screen URL action type, 270 Deployment Wizard, SSAS, 199 usage-based optimization see UBO what-if (scenario) analysis, 32 Usage-Based Optimization Wizard, 72 What-If Analysis option, 318 Use existing tables option, Cube Wizard, 170, 174 WHERE clause, MDX, 232–233 Select Existing Dimensions page, 173 Windows Management Instrumentation (WMI) Select Measure Group Tables page, 170, 171 objects, 93 Select Measures page, 171, 172 Windows Performance Monitor, 337–339 user-friendly interfaces for OLAP solutions, 373–429 Windows PowerShell, 92 Excel 2007, 373, 373–398 Windows Server 2008 R2 MOSS 2007, 420–423 Performance Monitor, 338 PerformancePoint Server, 423–429 Windows Service properties, SSAS, 53 SQL Server Reporting Services, 373, 401–420 Windows username and password Visio 2007, 399–401 Data Source Designer, 100 users WITH statement, MDX, 236 scalability, 367–369 Workbook Activity Chart Utility dimension, 138 PowerPivot management dashboard, 370, 371 writeback V see also Excel writeback vAccessoryBuyers view, 279, 281 OLAP, 32–33 Value Axis Properties dialog, 417 performance improvements, 68 Value Expression, KPIs, 263 writeback dimensions vDMPrepAccessories view, 278 choosing Standard/Enterprise SSAS, 46 VertiPaq mode, 311, 320, 326 Writeback Table Option section, Change Settings views dialog, 336 creating Accessory Buyers views in WriteEnabled property, dimensions, 148 AdventureWorks, 278–281 virtualization, SSAS, 43–44 performance management, 369 X Visible value, Cube Designer, 191 XMLA (XML for Analysis), 35 Visio 2007, 399–401 managing data source views, 88 pivot diagrams, 399, 400 processing Analysis Services objects, 215, 340 SSAS task pane, 400 reprocessing cube, 340 Visual Studio XMLA listener, SSAS, 52 BIDS, 75–76 XMLA queries creating Analysis Services Project, 82–84 processing Analysis Services objects, 340 panes, 76–79 XMLA scripts, 198, 202 W Y warnings year over year growth query, MDX, 236 AMO design warnings, 135–136 YTD function, MDX, 248 Warnings tab, AMO, 136 Yukon, 41 461
Đồng bộ tài khoản