Oracle Essbase 9 implementation guide [[electronic resource] ] : develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase / / Sarma Anantapantula, Joseph Sydney Gomez |
Autore | Anantapantula Sarma |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Publishing Ltd., 2009 |
Descrizione fisica | 1 online resource (444 p.) |
Disciplina | 005.36 |
Altri autori (Persone) | GomezJoseph Sydney |
Collana | From technologies to solutions |
Soggetto topico |
Client/server computing
Database design OLAP technology System design |
ISBN |
1-282-17235-2
1-84719-687-X 9786612172359 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: Installing Oracle Essbase; Installing the Essbase analytic server; Installing Essbase Administration Services; Starting the EAS; Installing the Essbase Add-in for Microsoft Excel; A typical network setup; Summary; Chapter 2: Essbase Data and Design Considerations; Introduction to OLAP; Determining the data requirements; Determine data storage options; Types of Essbase applications; Aggregate Storage Option (ASO); Block Storage Option (BSO); Unicode and Non-Unicode applications; Creating your first Essbase application
Essbase Application PropertiesStartup section; Security; Minimum access level; Types of Essbase databases; The normal (non-currency) database; Essbase currency database; Database components; The database outline; Linked Reporting Objects; Partitions; Calculation scripts; Report scripts; Database load rules files; Allowing duplicate member names; Create your first Essbase database; General tab; Dimensions tab; Statistics tab; Caches tab; Transactions tab; Storage tab; Currency tab; Modifications tab; Types of Essbase users; Summary; Chapter 3: Building the Essbase Outline; Before we begin The Essbase outline-the foundationDimensions and members; Outline member descriptors; Generations and Levels; Generation; Level; Types of dimensions; Standard dimension; The Account dimension type; The Time dimension type; The Country dimension type; No dimension type or general dimension; The Currency Partition dimension type; The Attribute dimension; Dense and Sparse dimensions; Build your first outline; Member properties; Member consolidations; Valid consolidation operators; Member storage; Member formulas; Member alias; Alias table; Build your first data rules file Step 1: Start the Data Prep EditorStep 2: Associate the Dimension Build Rules file; Step 3: Open data load file or the SQL data source file; Step 4: Set the Data Source Properties; Step 5: Set the View to Dimension build fields; Step 6: Select Dimension build method; Generation reference; Level reference; Parent-child reference; Step 7: Format file; Step 8: Associate fields with dimensions; Step 9: Validate the Dimension Build rules file; Update your outline using a rules file; Update your outline using the EAS Outline Editor; Update using MaxL Shell; Executing MaxL from EAS editor Executing MaxL from command promptAttribute dimensions; User Defined Attributes (UDA); Dynamic Time Series; Shared members; Summary; Chapter 4: Loading Data into Essbase; Make your data Essbase-friendly; Essbase-friendly thoughts; Essbase-friendly example; Types of data sources; Type of data; Types of files used for data loads; Relational databases; Data load methods; Data file freeform (no load rule); Essbase export and import (no load rule); Structured data load (load rule used); Microsoft Excel Lock and Send (no load rule); Building your first data load rules file Step 1: Starting the Data Prep Editor |
Record Nr. | UNINA-9910780785703321 |
Anantapantula Sarma
![]() |
||
Birmingham, U.K., : Packt Publishing Ltd., 2009 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Essbase 9 implementation guide : develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase / / Sarma Anantapantula, Joseph Sydney Gomez |
Autore | Anantapantula Sarma |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Publishing Ltd., 2009 |
Descrizione fisica | 1 online resource (444 p.) |
Disciplina | 005.36 |
Altri autori (Persone) | GomezJoseph Sydney |
Collana | From technologies to solutions |
Soggetto topico |
Client/server computing
Database design OLAP technology System design |
ISBN |
1-282-17235-2
1-84719-687-X 9786612172359 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Table of Contents; Preface; Chapter 1: Installing Oracle Essbase; Installing the Essbase analytic server; Installing Essbase Administration Services; Starting the EAS; Installing the Essbase Add-in for Microsoft Excel; A typical network setup; Summary; Chapter 2: Essbase Data and Design Considerations; Introduction to OLAP; Determining the data requirements; Determine data storage options; Types of Essbase applications; Aggregate Storage Option (ASO); Block Storage Option (BSO); Unicode and Non-Unicode applications; Creating your first Essbase application
Essbase Application PropertiesStartup section; Security; Minimum access level; Types of Essbase databases; The normal (non-currency) database; Essbase currency database; Database components; The database outline; Linked Reporting Objects; Partitions; Calculation scripts; Report scripts; Database load rules files; Allowing duplicate member names; Create your first Essbase database; General tab; Dimensions tab; Statistics tab; Caches tab; Transactions tab; Storage tab; Currency tab; Modifications tab; Types of Essbase users; Summary; Chapter 3: Building the Essbase Outline; Before we begin The Essbase outline-the foundationDimensions and members; Outline member descriptors; Generations and Levels; Generation; Level; Types of dimensions; Standard dimension; The Account dimension type; The Time dimension type; The Country dimension type; No dimension type or general dimension; The Currency Partition dimension type; The Attribute dimension; Dense and Sparse dimensions; Build your first outline; Member properties; Member consolidations; Valid consolidation operators; Member storage; Member formulas; Member alias; Alias table; Build your first data rules file Step 1: Start the Data Prep EditorStep 2: Associate the Dimension Build Rules file; Step 3: Open data load file or the SQL data source file; Step 4: Set the Data Source Properties; Step 5: Set the View to Dimension build fields; Step 6: Select Dimension build method; Generation reference; Level reference; Parent-child reference; Step 7: Format file; Step 8: Associate fields with dimensions; Step 9: Validate the Dimension Build rules file; Update your outline using a rules file; Update your outline using the EAS Outline Editor; Update using MaxL Shell; Executing MaxL from EAS editor Executing MaxL from command promptAttribute dimensions; User Defined Attributes (UDA); Dynamic Time Series; Shared members; Summary; Chapter 4: Loading Data into Essbase; Make your data Essbase-friendly; Essbase-friendly thoughts; Essbase-friendly example; Types of data sources; Type of data; Types of files used for data loads; Relational databases; Data load methods; Data file freeform (no load rule); Essbase export and import (no load rule); Structured data load (load rule used); Microsoft Excel Lock and Send (no load rule); Building your first data load rules file Step 1: Starting the Data Prep Editor |
Record Nr. | UNINA-9910806266003321 |
Anantapantula Sarma
![]() |
||
Birmingham, U.K., : Packt Publishing Ltd., 2009 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX [[electronic resource] /] / by Sivakumar Harinath ... [et al.] |
Autore | Harinath Sivakumar <1971-> |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, 2012 |
Descrizione fisica | 1 online resource (1180 p.) |
Disciplina | 005.74 |
Altri autori (Persone) | HarinathSivakumar <1971-> |
Collana | Wrox programmer to programmer |
Soggetto topico |
Database management
MDX (Computer program language) OLAP technology Relational databases Client/server computing |
Soggetto genere / forma | Electronic books. |
ISBN |
1-283-65635-3
1-118-22343-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Professional Microsoft® Sql Server® 2012 Analysis Services with MDX and DAX; Contents; Introduction; Who This Book is For; What This Book Covers; How This Book is Structured; What you Need to USE This Book; Conventions; Source Code; Errata; P2P.Wrox.Com; Part I: Introduction; Chapter 1: Introduction; BISM Multidimensional Mode; A Closer Look at Data Warehousing; Key Elements of a Data Warehouse; Fact Tables; Dimension Tables; Dimensions; Cubes; The Star Schema; The Snowflake Schema; Inmon Versus Kimball?-?Different Approaches; Business Intelligence Is Data Analysis; BISM Tabular Mode
SQL Server Analysis Services 2012The Business Intelligence Semantic Model; Data Model; Query Language; Data Access Technology; Summary; Part II Designing Multidimensional BISM; Chapter 2: A First Look at Multidimensional BISM; Development, Administrative, and Client Tools; Upgrading to Analysis Services 2012; Using SQL Server Data Tools to Build Analysis Services Multidimensional Applications; Creating a Project Using SQL Server Data Tools; The Solution Explorer; The Properties Window; The Output Window; Creating an Analysis Services Database Using SQL Server Data Tools Creating a Data SourceCreating a Data Source View (DSV); Creating a Cube Using the Cube Wizard; Deploying and Browsing a Cube; Using SQL Server Management Studio; The Object Explorer Pane; Querying Using the MDX Query Editor; Summary; Chapter 3: Understanding MDX; What Is MDX?; MDX Concepts; Measures and Measure Groups; Hierarchies and Hierarchy Levels; Members; Cells; Tuples; Sets; MDX Queries; SELECT Statement and Axis Specification; FROM Clause and Cube Specification; Subselect Clauses; WHERE Clause and Slicer Specification; Slicer Dimension; WITH Clause, Named Sets, and Calculated Members Named SetsCalculated Members; Ranking and Sorting; MDX Expressions; MDX Operators; Arithmetic Operators; Set Operators; Comparison Operators; Logical Operators; Special MDX Operators?-?Curly Braces, Commas, and Colons; MDX Functions; MDX Function Categories; Set Functions; Crossjoin; NONEMPTYCROSSJOIN and NONEMPTY; Filter and Having; Member Functions; Numeric Functions; Dimension Functions, Level Functions, and Hierarchy Functions; String Manipulation Functions; Other Functions; MDX Scripts; MDX Script Execution; CALCULATE Statement; Cube Space; AUTO EXISTS; Cell Calculations and Assignments RecursionFreeze Statement; Restricting Cube Space/Slicing Cube Data; SCOPE Statement; CREATE and DROP SUBCUBE; Using EXISTS; Using EXISTING; Using SUBSELECT; Parameterized MDX Queries; MDX Comments; Summary; Chapter 4: Data Sources and Data Source Views; Data Sources; Data Sources Supported by Analysis Services; .NET Versus OLE DB Data Providers; .NET Framework Data Providers; OLE DB Data Providers; The Trade-Offs; Data Source Views; DSV Wizard; DSV Designer; Adding/Removing Tables in a DSV; Specifying Primary Keys and Relationships in the DSV; Customizing Your Tables in the DSV Designer Data Source Views in Depth |
Record Nr. | UNINA-9910462242403321 |
Harinath Sivakumar <1971->
![]() |
||
Hoboken, N.J., : Wiley, 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX [[electronic resource] /] / by Sivakumar Harinath ... [et al.] |
Autore | Harinath Sivakumar <1971-> |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, 2012 |
Descrizione fisica | 1 online resource (1180 p.) |
Disciplina | 005.74 |
Altri autori (Persone) | HarinathSivakumar <1971-> |
Collana | Wrox programmer to programmer |
Soggetto topico |
Database management
MDX (Computer program language) OLAP technology Relational databases Client/server computing |
ISBN |
1-283-65635-3
1-118-22343-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Professional Microsoft® Sql Server® 2012 Analysis Services with MDX and DAX; Contents; Introduction; Who This Book is For; What This Book Covers; How This Book is Structured; What you Need to USE This Book; Conventions; Source Code; Errata; P2P.Wrox.Com; Part I: Introduction; Chapter 1: Introduction; BISM Multidimensional Mode; A Closer Look at Data Warehousing; Key Elements of a Data Warehouse; Fact Tables; Dimension Tables; Dimensions; Cubes; The Star Schema; The Snowflake Schema; Inmon Versus Kimball?-?Different Approaches; Business Intelligence Is Data Analysis; BISM Tabular Mode
SQL Server Analysis Services 2012The Business Intelligence Semantic Model; Data Model; Query Language; Data Access Technology; Summary; Part II Designing Multidimensional BISM; Chapter 2: A First Look at Multidimensional BISM; Development, Administrative, and Client Tools; Upgrading to Analysis Services 2012; Using SQL Server Data Tools to Build Analysis Services Multidimensional Applications; Creating a Project Using SQL Server Data Tools; The Solution Explorer; The Properties Window; The Output Window; Creating an Analysis Services Database Using SQL Server Data Tools Creating a Data SourceCreating a Data Source View (DSV); Creating a Cube Using the Cube Wizard; Deploying and Browsing a Cube; Using SQL Server Management Studio; The Object Explorer Pane; Querying Using the MDX Query Editor; Summary; Chapter 3: Understanding MDX; What Is MDX?; MDX Concepts; Measures and Measure Groups; Hierarchies and Hierarchy Levels; Members; Cells; Tuples; Sets; MDX Queries; SELECT Statement and Axis Specification; FROM Clause and Cube Specification; Subselect Clauses; WHERE Clause and Slicer Specification; Slicer Dimension; WITH Clause, Named Sets, and Calculated Members Named SetsCalculated Members; Ranking and Sorting; MDX Expressions; MDX Operators; Arithmetic Operators; Set Operators; Comparison Operators; Logical Operators; Special MDX Operators?-?Curly Braces, Commas, and Colons; MDX Functions; MDX Function Categories; Set Functions; Crossjoin; NONEMPTYCROSSJOIN and NONEMPTY; Filter and Having; Member Functions; Numeric Functions; Dimension Functions, Level Functions, and Hierarchy Functions; String Manipulation Functions; Other Functions; MDX Scripts; MDX Script Execution; CALCULATE Statement; Cube Space; AUTO EXISTS; Cell Calculations and Assignments RecursionFreeze Statement; Restricting Cube Space/Slicing Cube Data; SCOPE Statement; CREATE and DROP SUBCUBE; Using EXISTS; Using EXISTING; Using SUBSELECT; Parameterized MDX Queries; MDX Comments; Summary; Chapter 4: Data Sources and Data Source Views; Data Sources; Data Sources Supported by Analysis Services; .NET Versus OLE DB Data Providers; .NET Framework Data Providers; OLE DB Data Providers; The Trade-Offs; Data Source Views; DSV Wizard; DSV Designer; Adding/Removing Tables in a DSV; Specifying Primary Keys and Relationships in the DSV; Customizing Your Tables in the DSV Designer Data Source Views in Depth |
Record Nr. | UNINA-9910785739203321 |
Harinath Sivakumar <1971->
![]() |
||
Hoboken, N.J., : Wiley, 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX [[electronic resource] /] / by Sivakumar Harinath ... [et al.] |
Autore | Harinath Sivakumar <1971-> |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, 2012 |
Descrizione fisica | 1 online resource (1180 p.) |
Disciplina | 005.74 |
Altri autori (Persone) | HarinathSivakumar <1971-> |
Collana | Wrox programmer to programmer |
Soggetto topico |
Database management
MDX (Computer program language) OLAP technology Relational databases Client/server computing |
ISBN |
1-283-65635-3
1-118-22343-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Professional Microsoft® Sql Server® 2012 Analysis Services with MDX and DAX; Contents; Introduction; Who This Book is For; What This Book Covers; How This Book is Structured; What you Need to USE This Book; Conventions; Source Code; Errata; P2P.Wrox.Com; Part I: Introduction; Chapter 1: Introduction; BISM Multidimensional Mode; A Closer Look at Data Warehousing; Key Elements of a Data Warehouse; Fact Tables; Dimension Tables; Dimensions; Cubes; The Star Schema; The Snowflake Schema; Inmon Versus Kimball?-?Different Approaches; Business Intelligence Is Data Analysis; BISM Tabular Mode
SQL Server Analysis Services 2012The Business Intelligence Semantic Model; Data Model; Query Language; Data Access Technology; Summary; Part II Designing Multidimensional BISM; Chapter 2: A First Look at Multidimensional BISM; Development, Administrative, and Client Tools; Upgrading to Analysis Services 2012; Using SQL Server Data Tools to Build Analysis Services Multidimensional Applications; Creating a Project Using SQL Server Data Tools; The Solution Explorer; The Properties Window; The Output Window; Creating an Analysis Services Database Using SQL Server Data Tools Creating a Data SourceCreating a Data Source View (DSV); Creating a Cube Using the Cube Wizard; Deploying and Browsing a Cube; Using SQL Server Management Studio; The Object Explorer Pane; Querying Using the MDX Query Editor; Summary; Chapter 3: Understanding MDX; What Is MDX?; MDX Concepts; Measures and Measure Groups; Hierarchies and Hierarchy Levels; Members; Cells; Tuples; Sets; MDX Queries; SELECT Statement and Axis Specification; FROM Clause and Cube Specification; Subselect Clauses; WHERE Clause and Slicer Specification; Slicer Dimension; WITH Clause, Named Sets, and Calculated Members Named SetsCalculated Members; Ranking and Sorting; MDX Expressions; MDX Operators; Arithmetic Operators; Set Operators; Comparison Operators; Logical Operators; Special MDX Operators?-?Curly Braces, Commas, and Colons; MDX Functions; MDX Function Categories; Set Functions; Crossjoin; NONEMPTYCROSSJOIN and NONEMPTY; Filter and Having; Member Functions; Numeric Functions; Dimension Functions, Level Functions, and Hierarchy Functions; String Manipulation Functions; Other Functions; MDX Scripts; MDX Script Execution; CALCULATE Statement; Cube Space; AUTO EXISTS; Cell Calculations and Assignments RecursionFreeze Statement; Restricting Cube Space/Slicing Cube Data; SCOPE Statement; CREATE and DROP SUBCUBE; Using EXISTS; Using EXISTING; Using SUBSELECT; Parameterized MDX Queries; MDX Comments; Summary; Chapter 4: Data Sources and Data Source Views; Data Sources; Data Sources Supported by Analysis Services; .NET Versus OLE DB Data Providers; .NET Framework Data Providers; OLE DB Data Providers; The Trade-Offs; Data Source Views; DSV Wizard; DSV Designer; Adding/Removing Tables in a DSV; Specifying Primary Keys and Relationships in the DSV; Customizing Your Tables in the DSV Designer Data Source Views in Depth |
Record Nr. | UNINA-9910819524103321 |
Harinath Sivakumar <1971->
![]() |
||
Hoboken, N.J., : Wiley, 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
PROMISE 2016 : welcome to the 12th International Conference on Predictive Models and Data Analytics in Software Engineering / / / Association for Computing Machinery |
Pubbl/distr/stampa | New York : , : ACM, , 2016 |
Descrizione fisica | 1 online resource (84 pages) |
Disciplina | 006.312 |
Soggetto topico |
Data mining
OLAP technology |
ISBN | 1-4503-4772-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910376434703321 |
New York : , : ACM, , 2016 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|