Oracle Essbase 11 development cookbook :: over 90 advanced development recipes to build and take your Oralce Essbase applications further /
Annotation Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios....
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham :
Packt Publishing Limited,
©2012.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Annotation Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios. This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further. Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes. |
| Beschreibung: | 1 online resource |
| ISBN: | 9781849683272 1849683271 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBU-ocn776603646 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 120214s2012 enk o 000 0 eng d | ||
| 040 | |a N$T |b eng |e pn |c N$T |d UMI |d COO |d OCLCQ |d DEBSZ |d OCLCQ |d DKDLA |d OCLCQ |d OCLCF |d OCLCQ |d AGLDB |d CNNOR |d U3W |d OCLCQ |d OCLCO |d JBG |d CEF |d NLE |d UKMGB |d OCLCQ |d OCLCO |d STF |d UKAHL |d HS0 |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 016 | 7 | |a 018015080 |2 Uk | |
| 019 | |a 796020993 | ||
| 020 | |a 9781849683272 |q (electronic bk.) | ||
| 020 | |a 1849683271 |q (electronic bk.) | ||
| 020 | |z 1849683263 | ||
| 020 | |z 9781849683265 | ||
| 035 | |a (OCoLC)776603646 |z (OCoLC)796020993 | ||
| 037 | |a CL0500000147 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b R85 2012eb | |
| 072 | 7 | |a COM |x 005030 |2 bisacsh | |
| 072 | 7 | |a COM |x 004000 |2 bisacsh | |
| 082 | 7 | |a 006.3 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Ruiz, Jose R. | |
| 245 | 1 | 0 | |a Oracle Essbase 11 development cookbook : |b over 90 advanced development recipes to build and take your Oralce Essbase applications further / |c Jose R. Ruiz. |
| 260 | |a Birmingham : |b Packt Publishing Limited, |c ©2012. | ||
| 300 | |a 1 online resource | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 520 | 8 | |a Annotation Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios. This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further. Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes. | |
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions | |
| 505 | 8 | |a Using Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building the BSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table | |
| 505 | 8 | |a Adding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report | |
| 505 | 8 | |a Using the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas | |
| 505 | 8 | |a Using Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts | |
| 630 | 0 | 0 | |a Essbase (Computer file) |0 http://id.loc.gov/authorities/names/n96119638 |
| 630 | 0 | 7 | |a Essbase (Computer file) |2 blmlsh |
| 630 | 0 | 7 | |a Essbase (Computer file) |2 fast |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Enterprise Applications |x Business Intelligence Tools. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Intelligence (AI) & Semantics. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 758 | |i has work: |a Oracle Essbase 11 development cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PCYpqkRKBFW7gHbhh8cMWgq |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Ruiz, J.R. |t Oracle essbase 11 development cookbook. |d [S.l.] : Packt Publishing Limited, 2011 |z 1849683263 |w (OCoLC)756180746 |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBU |q FWS_PDA_EBU |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=432015 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26944176 | ||
| 938 | |a EBSCOhost |b EBSC |n 432015 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBU | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBU-ocn776603646 |
|---|---|
| _version_ | 1816796903533182976 |
| adam_text | |
| any_adam_object | |
| author | Ruiz, Jose R. |
| author_facet | Ruiz, Jose R. |
| author_role | |
| author_sort | Ruiz, Jose R. |
| author_variant | j r r jr jrr |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 R85 2012eb |
| callnumber-search | QA76.9.D3 R85 2012eb |
| callnumber-sort | QA 276.9 D3 R85 42012EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBU |
| contents | Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions Using Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building the BSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table Adding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report Using the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas Using Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts |
| ctrlnum | (OCoLC)776603646 |
| dewey-full | 006.3 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 006 - Special computer methods |
| dewey-raw | 006.3 |
| dewey-search | 006.3 |
| dewey-sort | 16.3 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06316cam a2200601 a 4500</leader><controlfield tag="001">ZDB-4-EBU-ocn776603646</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">120214s2012 enk o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">UMI</subfield><subfield code="d">COO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">DKDLA</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">CNNOR</subfield><subfield code="d">U3W</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">JBG</subfield><subfield code="d">CEF</subfield><subfield code="d">NLE</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">STF</subfield><subfield code="d">UKAHL</subfield><subfield code="d">HS0</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018015080</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">796020993</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849683272</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849683271</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1849683263</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849683265</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)776603646</subfield><subfield code="z">(OCoLC)796020993</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000147</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">R85 2012eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">005030</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">004000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">006.3</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Ruiz, Jose R.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle Essbase 11 development cookbook :</subfield><subfield code="b">over 90 advanced development recipes to build and take your Oralce Essbase applications further /</subfield><subfield code="c">Jose R. Ruiz.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing Limited,</subfield><subfield code="c">©2012.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="520" ind1="8" ind2=" "><subfield code="a">Annotation Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios. This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further. Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Using Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building the BSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Adding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Using the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Using Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">Essbase (Computer file)</subfield><subfield code="0">http://id.loc.gov/authorities/names/n96119638</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Essbase (Computer file)</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Essbase (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Enterprise Applications</subfield><subfield code="x">Business Intelligence Tools.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Intelligence (AI) & Semantics.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Oracle Essbase 11 development cookbook (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCYpqkRKBFW7gHbhh8cMWgq</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Ruiz, J.R.</subfield><subfield code="t">Oracle essbase 11 development cookbook.</subfield><subfield code="d">[S.l.] : Packt Publishing Limited, 2011</subfield><subfield code="z">1849683263</subfield><subfield code="w">(OCoLC)756180746</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBU</subfield><subfield code="q">FWS_PDA_EBU</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=432015</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26944176</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">432015</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBU</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBU-ocn776603646 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-26T14:49:04Z |
| institution | BVB |
| isbn | 9781849683272 1849683271 |
| language | English |
| oclc_num | 776603646 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource |
| psigel | ZDB-4-EBU |
| publishDate | 2012 |
| publishDateSearch | 2012 |
| publishDateSort | 2012 |
| publisher | Packt Publishing Limited, |
| record_format | marc |
| spelling | Ruiz, Jose R. Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oralce Essbase applications further / Jose R. Ruiz. Birmingham : Packt Publishing Limited, ©2012. 1 online resource text txt rdacontent computer c rdamedia online resource cr rdacarrier Print version record. Annotation Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios. This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further. Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes. Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions Using Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building the BSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table Adding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report Using the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas Using Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts Essbase (Computer file) http://id.loc.gov/authorities/names/n96119638 Essbase (Computer file) blmlsh Essbase (Computer file) fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Enterprise Applications Business Intelligence Tools. bisacsh COMPUTERS Intelligence (AI) & Semantics. bisacsh Database management fast has work: Oracle Essbase 11 development cookbook (Text) https://id.oclc.org/worldcat/entity/E39PCYpqkRKBFW7gHbhh8cMWgq https://id.oclc.org/worldcat/ontology/hasWork Print version: Ruiz, J.R. Oracle essbase 11 development cookbook. [S.l.] : Packt Publishing Limited, 2011 1849683263 (OCoLC)756180746 FWS01 ZDB-4-EBU FWS_PDA_EBU https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=432015 Volltext |
| spellingShingle | Ruiz, Jose R. Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oralce Essbase applications further / Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions Using Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building the BSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table Adding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report Using the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas Using Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts Essbase (Computer file) http://id.loc.gov/authorities/names/n96119638 Essbase (Computer file) blmlsh Essbase (Computer file) fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Enterprise Applications Business Intelligence Tools. bisacsh COMPUTERS Intelligence (AI) & Semantics. bisacsh Database management fast |
| subject_GND | http://id.loc.gov/authorities/names/n96119638 http://id.loc.gov/authorities/subjects/sh85035848 |
| title | Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oralce Essbase applications further / |
| title_auth | Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oralce Essbase applications further / |
| title_exact_search | Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oralce Essbase applications further / |
| title_full | Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oralce Essbase applications further / Jose R. Ruiz. |
| title_fullStr | Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oralce Essbase applications further / Jose R. Ruiz. |
| title_full_unstemmed | Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oralce Essbase applications further / Jose R. Ruiz. |
| title_short | Oracle Essbase 11 development cookbook : |
| title_sort | oracle essbase 11 development cookbook over 90 advanced development recipes to build and take your oralce essbase applications further |
| title_sub | over 90 advanced development recipes to build and take your Oralce Essbase applications further / |
| topic | Essbase (Computer file) http://id.loc.gov/authorities/names/n96119638 Essbase (Computer file) blmlsh Essbase (Computer file) fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Enterprise Applications Business Intelligence Tools. bisacsh COMPUTERS Intelligence (AI) & Semantics. bisacsh Database management fast |
| topic_facet | Essbase (Computer file) Database management. Bases de données Gestion. COMPUTERS Enterprise Applications Business Intelligence Tools. COMPUTERS Intelligence (AI) & Semantics. Database management |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=432015 |
| work_keys_str_mv | AT ruizjoser oracleessbase11developmentcookbookover90advanceddevelopmentrecipestobuildandtakeyouroralceessbaseapplicationsfurther |