05455nam 2200697 450 991046405720332120200520144314.01-84968-991-1(CKB)2670000000530574(EBL)1572948(SSID)ssj0001158020(PQKBManifestationID)11649186(PQKBTitleCode)TC0001158020(PQKBWorkID)11212281(PQKB)10971171(MiAaPQ)EBC1572948(CaSebORM)9781849689908(PPN)228020247(Au-PeEL)EBL1572948(CaPaEBR)ebr10842718(CaONFJC)MIL577615(OCoLC)871223823(EXLCZ)99267000000053057420140312h20142014 uy 0engur|n|---|||||txtccrExpert cube development with SSAS multidimensional models expert tips and tricks for designing analysis services multidimensional models /Chris Webb, Alberto Ferrari, Marco Russo ; cover image by Faiz Fattohi1st editionBirmingham, [England] :Packt Publishing,2014.©20141 online resource (402 p.)Professional expertise distilledIncludes index.1-84968-990-3 Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Designing the Data Warehouse for Analysis Services; The source database; The OLTP database; The data warehouse; The data mart; Data modeling for Analysis Services; Fact tables and dimension tables; Star schemas and snowflake schemas; Junk dimensions; Degenerate dimensions; Slowly Changing Dimensions; Bridge tables or factless fact tables; Snapshot and transaction fact tables; Updating fact and dimension tables; Natural and surrogate keysUnknown Members, key errors, and NULLabilityPhysical database design for Analysis Services; Multiple data sources; Data types and Analysis Services; SQL queries generated during cube processing; Dimension processing; Dimensions with joined tables; Reference dimensions; Fact dimensions; Distinct Count measures; Indexes in the data mart; Usage of schemas; Naming conventions; Views versus the Data Source View; Summary; Chapter 2: Building Basic Dimensions and Cubes; Multidimensional and Tabular models; Choosing an edition of Analysis Services; Setting up a new Analysis Services projectCreating data sourcesCreating Data Source Views; Designing simple dimensions; Using the New Dimension wizard; Using the Dimension Editor; Adding new attributes; Configuring a Time dimension; Creating user hierarchies; Configuring attribute relationships; Building a simple cube; Using the New Cube wizard; Project deployment; Database processing; Summary; Chapter 3: Designing More Complex Dimensions; Grouping and banding; Grouping; Banding; Modeling Slowly Changing Dimensions; Type I SCDs; Type II SCDs; Modeling attribute relationships on a Type II SCD; Handling member status; Type III SCDsModeling junk dimensionsModeling ragged hierarchies; Modeling parent/child hierarchies; Ragged hierarchies with HideMemberIf; Summary; Chapter 4: Measures and Measure Groups; Measures and aggregation; Useful properties of measures; FormatString; DisplayFolders; Built-in measure aggregation types; Basic aggregation types; DistinctCount; None; Semi-additive aggregation types; ByAccount; Dimension calculations; Unary operators and weights; Custom Member Formulas; Non-aggregatable values; Measure groups; Creating multiple measure groups; Creating measure groups from dimension tablesMDX formulas versus pre-calculating valuesHandling different dimensionality; Handling different granularities; Non-aggregatable measures - a different approach; Using linked dimensions and measure groups; Role-playing dimensions; Dimension/measure group relationships; Fact relationships; Referenced relationships; Data mining relationships; Summary; Chapter 5: Handling Transactional-level Data; Details about transactional data; Drillthrough; Actions; Drillthrough actions; Drillthrough columns order; Drillthrough and calculated members; Drillthrough modelingDrillthrough using a transaction detail dimensionAn easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used.If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you.You are expected to have some prior experience with Analysis Services cube development.Client/server computingRelational databasesElectronic books.Client/server computing.Relational databases.004.36Webb Chris899754Ferrari Alberto36508Russo Marco282838Fattohi Faiz991104MiAaPQMiAaPQMiAaPQBOOK9910464057203321Expert cube development with SSAS multidimensional models2267993UNINA03891nam 2200709 a 450 991096577390332120240417222500.09781283901703128390170697802520944840252094484(CKB)2550000000707714(EBL)3414175(SSID)ssj0000783908(PQKBManifestationID)11490442(PQKBTitleCode)TC0000783908(PQKBWorkID)10760900(PQKB)11524400(StDuBDS)EDZ0000649290(OCoLC)824655084(MdBmJHUP)muse25130(Au-PeEL)EBL3414175(CaPaEBR)ebr10639730(CaONFJC)MIL421420(OCoLC)923496654(MiAaPQ)EBC3414175(Perlego)2575895(EXLCZ)99255000000070771420120514d2013 ub 0engur|n|---|||||txtccrOrganized crime in Chicago beyond the Mafia /Robert M. Lombardo1st ed.Urbana :University of Illinois Press,[2013]©20131 online resource (xviii, 258 pages)Description based upon print version of record.9780252078781 0252078780 9780252037306 0252037308 Includes bibliographical references (pages 211-246) and index.Explaining organized crime -- The gem of the prairie -- The black Mafia -- The syndicate -- The Forty-two Gang -- The outfit -- The outfit as a complex organization -- Street crew neighborhoods.This book provides a comprehensive sociological explanation for the emergence and continuation of organized crime in Chicago. Tracing the roots of political corruption that afforded protection to gambling, prostitution, and other vice activity in Chicago and other large American cities, Robert M. Lombardo challenges the dominant belief that organized crime in America descended directly from the Sicilian Mafia. According to this widespread "alien conspiracy" theory, organized crime evolved in a linear fashion beginning with the Mafia in Sicily, emerging in the form of the Black Hand in America's immigrant colonies, and culminating in the development of the Cosa Nostra in America's urban centers. Looking beyond this Mafia paradigm, this volume argues that the development of organized crime in Chicago and other large American cities was rooted in the social structure of American society. Specifically, Lombardo ties organized crime to the emergence of machine politics in America's urban centers. From nineteenth-century vice syndicates to the modern-day Outfit, Chicago's criminal underworld could not have existed without the blessing of those who controlled municipal, country, and state government. These practices were not imported from Sicily, Lombardo contends, but were bred in the socially disorganized slums of America where elected officials routinely franchised vice and crime in exchange for money and votes. This book also traces the history of the African American community's participation in traditional organized crime in Chicago and offers new perspectives on the organizational structure of the Chicago Outfit, the traditional organized crime group in Chicago.Organized crimeIllinoisChicagoCriminalsIllinoisChicagoGangsIllinoisChicagoOrganized crimeCriminalsGangs364.10609773/11Lombardo Robert M1807100MiAaPQMiAaPQMiAaPQBOOK9910965773903321Organized crime in Chicago4356634UNINA