Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
SQL Server Analysis Services 2012 Cube Development Cookbook [[electronic resource]]
| SQL Server Analysis Services 2012 Cube Development Cookbook [[electronic resource]] |
| Autore | Dewald Baya |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, : Packt Publishing, 2013 |
| Descrizione fisica | 1 online resource (340 p.) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) |
TurleyPaul
HughesSteve |
| Collana | Quick answers to common problems |
| Soggetto topico |
Client/server computing
Computer networks -- Security measures SQL server Web servers Engineering & Applied Sciences Computer Science |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-84968-981-4 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views
Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session Checking whether cubes are accessible |
| Record Nr. | UNINA-9910453416803321 |
Dewald Baya
|
||
| Birmingham, : Packt Publishing, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SQL Server Analysis Services 2012 Cube Development Cookbook [[electronic resource]]
| SQL Server Analysis Services 2012 Cube Development Cookbook [[electronic resource]] |
| Autore | Dewald Baya |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, : Packt Publishing, 2013 |
| Descrizione fisica | 1 online resource (340 p.) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) |
TurleyPaul
HughesSteve |
| Collana | Quick answers to common problems |
| Soggetto topico |
Client/server computing
Computer networks -- Security measures SQL server Web servers Engineering & Applied Sciences Computer Science |
| ISBN | 1-84968-981-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views
Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session Checking whether cubes are accessible |
| Record Nr. | UNINA-9910790721203321 |
|
Dewald Baya
|
||
| Birmingham, : Packt Publishing, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SQL Server Analysis Services 2012 Cube Development Cookbook
| SQL Server Analysis Services 2012 Cube Development Cookbook |
| Autore | Dewald Baya |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, : Packt Publishing, 2013 |
| Descrizione fisica | 1 online resource (340 p.) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) |
TurleyPaul
HughesSteve |
| Collana | Quick answers to common problems |
| Soggetto topico |
Client/server computing
Computer networks -- Security measures SQL server Web servers Engineering & Applied Sciences Computer Science |
| ISBN | 1-84968-981-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views
Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session Checking whether cubes are accessible |
| Record Nr. | UNINA-9910812566203321 |
|
Dewald Baya
|
||
| Birmingham, : Packt Publishing, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||