LEADER 00000cam a2200781Ia 4500
001 ocn870467562
003 OCoLC
005 20161029080457.4
006 m o d
007 cr cnu---unuuu
008 140213s2013 enka o 001 0 eng d
019 867317608
020 9781849689816|q(electronic book)
020 1849689814|q(electronic book)
020 9781782170662
020 1782170669
020 |z9781849689809
020 |z1849689806
035 (OCoLC)870467562|z(OCoLC)867317608
040 UMI|beng|epn|cUMI|dCOO|dDEBBG|dDEBSZ|dN$T|dEBLCP|dIDEBK
|dE7B|dYDXCP|dCHVBK|dOCLCF|dOCLCO|dOCLCQ|dOCL|dOCLCQ
049 RIDW
050 4 HD38.7|b.D49 2013
072 7 COM|x051170|2bisacsh
072 7 COM|x021000|2bisacsh
082 04 005.7585|223
090 HD38.7|b.D49 2013
100 1 Dewald, Baya.
245 10 SQL server analysis services 2012 cube development
cookbook :|bmore than 100 recipes to develop business
intelligence solutions using analysis services /|cBaya
Dewald, Steve Hughes, Paul Turley.
264 1 Birmingham, UK :|bPackt Pub.,|c2013.
300 1 online resource (1 volume) :|billustrations.
336 text|btxt|2rdacontent
337 computer|bc|2rdamedia
338 online resource|bcr|2rdacarrier
340 |gpolychrome|2rdacc
347 text file|2rdaft
490 1 Quick answers to common problems
505 0 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.
505 8 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.
505 8 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.
505 8 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.
505 8 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.
520 A practical cookbook packed with recipes to help
developers produce data cubes as quickly as possible by
following step by step instructions, rather than
explaining data mining concepts with SSAS. If you are a BI
or ETL developer using SQL Server Analysis services to
build OLAP cubes, this book is ideal for you. Prior
knowledge of relational databases and experience with
Excel as well as SQL development is required.
588 0 Online resource; title from cover (Safari, viewed Feb. 10,
2014).
590 eBooks on EBSCOhost|bEBSCO eBook Subscription Academic
Collection - North America
630 00 SQL server.|0https://id.loc.gov/authorities/names/
n90684343
630 7 SQL server.|2fast|0https://id.worldcat.org/fast/1376937
630 07 SQL server.|2blmlsh
630 07 SQL server.|2fast|0https://id.worldcat.org/fast/1376937
650 0 Business intelligence.|0https://id.loc.gov/authorities/
subjects/sh85018300
650 0 Data mining.|0https://id.loc.gov/authorities/subjects/
sh97002073
650 0 Database management.|0https://id.loc.gov/authorities/
subjects/sh85035848
650 0 MDX (Computer program language)|0https://id.loc.gov/
authorities/subjects/sh2002008553
650 7 Business intelligence.|2fast|0https://id.worldcat.org/fast
/842723
650 7 Data mining.|2fast|0https://id.worldcat.org/fast/887946
650 7 Database management.|2fast|0https://id.worldcat.org/fast/
888037
650 7 MDX (Computer program language)|2fast|0https://
id.worldcat.org/fast/1004511
655 4 Electronic books.
700 1 Hughes, Steve.|0https://id.loc.gov/authorities/names/
n88651636
700 1 Turley, Paul,|d1962-|0https://id.loc.gov/authorities/names
/n2004004075
776 08 |iPrint version:|aDewald, Baya.|tSQL Server Analysis
Services 2012 Cube Development Cookbook.|dBirmingham :
Packt Publishing, ©2013|z9781849689809
830 0 Quick answers to common problems.|0https://id.loc.gov/
authorities/names/no2015091434
856 40 |uhttps://rider.idm.oclc.org/login?url=http://
search.ebscohost.com/login.aspx?direct=true&scope=site&
db=nlebk&AN=680698|zOnline eBook. Access restricted to
current Rider University students, faculty, and staff.
856 42 |3Instructions for reading/downloading this eBook|uhttp://
guides.rider.edu/ebooks/ebsco
901 MARCIVE 20231220
948 |d20161103|cEBSCO|tebscoebooksacademic new|lridw
994 92|bRID
