Index

A

• @ACCUM function / How it works...
• @ATTRIBUTE function / How it works...
• @ATTRIBUTEVAL function / How it works...
• Account dimension
  • setting up, parent-child reference used / Setting up an Account or Measures dimension with a parent-child reference, How to do it...
  • MEASURES table / How it works...
  • Consolidations values / How it works...
  • Two Pass value / How it works...
  • Storage values / How it works...
  • Variance Reporting value / How it works...
  • Time Balance values / How it works...
  • Skip options / How it works...
• Adjust Data button / How to do it...
• Adjustments to ASO Model dialog box / How to do it...
• AGG command / How it works...
• AGG function / How it works
• Aggregate Storage (ASO) / Adding columns for outline formulas, How it works...
• aggregate storage applications
  • MDX, using / Using MDX in aggregate storage applications, How to do it...
  • working / How it works...
• aggregate storage model / Using the DATAEXPORT function to extract data into a text file
• Aggregate Storage Outline Conversion Wizard / Partitioning data from BSO to ASO cubes
• Alias tables
  • about / Creating Alias tables
  • creating / How to do it…
  • working / How to do it…, How it works..., There's more...
• allocation functions
  • using, in calculation scripts / Getting ready, How to do it...
  • working / How it works...
  • ammoun parameter / How it works...
  • Ndim parameter / How it works...
  • allocationRange1 parameter / How it works...
  • basisMbr parameter / How it works...
  • roundMbr parameter / How it works...
  • method parameter / How it works...
• allocationRange1 parameter / How it works...
• ALL parameter / How it works
• Alt+F11 / How to do it...
• amount parameter / How it works...
• application role types
  • Application Manager / How it works...
  • Database Manager / How it works...
  • Provisioning Manager / How it works...
• application_access_type / How it works
• Apply button / How to do it...
• ASO
  • about / Introduction, Using MDX to calculate Aggregate Storage database
  • calculating, MDX used / Using MDX to calculate Aggregate Storage database, How to do it...
  • working / How it works...
  • POV / How it works...
  • SourceRegion / How it works...
• ASO cube
  • setting up, Connection Wizard used / Using the Connection Wizard to set up an ASO cube, How to do it...
  • SQL Server Management Studio, opening / Getting ready
• ASO cube, building
  • Connection Wizard, using / Using the Connection Wizard to set up an ASO cube
  • Measures dimension, building from fact table / Building a Measures dimension from the fact table
  • ASO Cube Schema, creating / Creating an ASO Cube Schema and an Essbase Model
  • Essbase Model, creating / Creating an ASO Cube Schema and an Essbase Model
  • Essbase Model properties / Understanding Essbase Model properties for the ASO cube
  • drill-through report, designing / Designing a drill-through report
  • View dimension, using for Dynamic Time Series reporting / Using the View dimension for Dynamic Time Series reporting
• associate dimensions
  • adding, dimension build rules used / Using dimension build rules to add user-defined attributes and associate dimensions, Getting ready, How to do it...
  • working / How it works...
• Associate Outline button / How to do it...
• Association tab / How to do it...
• attribute dimension
  • adding, dimension build rules used / Creating dimension build rules to add a base and attribute dimensions, How to do it...
• attribute dimensions
  • adding, to hierarchies / Adding attribute dimensions to hierarchies, How to do it…
  • working / How it works…
• attributes, calculation scripts
  • using / Using Attributes in calculation scripts, How to do it...
  • working / How it works...

B

• base dimension
  • adding, dimension build rules used / Creating dimension build rules to add a base and attribute dimensions, How to do it..., There's more...
• basisMbr parameter / How it works...
• Block Storage (BSO) / Adding columns for outline formulas
• Block Storage (BSO) cube / Using the DATAEXPORT function to extract data into a relational source
• Browser button / How to do it...
• BSO
  • about / Introduction
  / Using Essbase Set function commands and Calc All to calculate cubes
• BSO Cube
  • deploying / Deploying a cube, Getting ready , How to do it…
  • EAS, working / How it works...
  • date measures, using / Using Date measures on a BSO cube, How to do it...
• BSO cube
  • text measures, using / Using Text measures on a BSO cube, How to do it...
• BSO Cube, building
  • hierarchies creating, parent-child reference table used / Creating hierarchies using a parent-child reference table
  • hierarchies creating, generation reference table used / Creating hierarchies using a generation reference table
  • attribute dimensions, adding to hierarchies / Adding attribute dimensions to hierarchies
  • Calendar dimension, building / Building a Calendar dimension
  • date elements, creating / Creating date elements
  • Alias tables, creating / Creating Alias tables
  • cube schema, developing / Developing cube schema and an Essbase model
  • Essbase model, developing / Developing cube schema and an Essbase model
  • OLAP Model, creating in EIS / Creating an OLAP Model in EIS
  • OLAP metaoutline, creating in EIS / Creating an OLAP metaoutline in EIS
• BSO cubes
  • data moving, @XREF function / Using @XREF functions to move data between BSO cubes, Getting ready, How to do it...
• build method
  • Use generation reference / There's more...
  • Use level references / There's more...
  • Use parent-child references / There's more...
  • Add as sibling of member with matching string / There's more...
  • Add as sibling of lowest level / There's more...
  • Add as child of / There's more...

C

• Calc All / Getting ready , How to do it...
  • working / How it works...
• CALC DIM function / How it works
• Calc Two Pass
  • using, in calculation scripts / Using UDAs and Calc Two Pass in calculation scripts, How to do it...
  • working / How it works..., There's more...
• Calc TwoPass command / There's more...
• calculation
  • executing, MaxL used / Executing calculations using MaxL, How to do it..., How it works...
• calculation scripts
  • UDAs, using / Using UDAs and Calc Two Pass in calculation scripts, How to do it...
  • Calc Two Pass, using / Using UDAs and Calc Two Pass in calculation scripts, How to do it...
  • attributes, using / Using Attributes in calculation scripts, How to do it...
  • Attributes, using / How it works...
  • allocation functions, using / Using allocation functions in calculation scripts
• calculations script
  • substitution variables, using / Using substitution variables in calculations script , How to do it...
• calculations scripts
  • about / Introduction
  • advantages / Introduction
  • data, clearing / Getting ready, How to do it...
  • cross-dimensional operators, using / Getting ready, How to do it...
• Calendar dimension
  • about / Building a Calendar dimension
  • building / Getting ready, How to do it…
  • working / How it works...
• change_password / How it works
• Check syntax button / How to do it..., How to do it..., How to do it...
• ClearBlock / Clearing data and using the cross- dimensional operators in a calculation script
• CLEARBLOCK command / How it works
• ClearData command / Clearing data and using the cross- dimensional operators in a calculation script
• CLEARDATA command / How it works
• Close button / How to do it...
• column format
  • using, for data export / Exporting data using column format, How to do it...
  • working / How it works...
• columns, MEASURES table
  • SORTKEY / How it works...
  • MEASURESID / How it works...
  • PARENT / How it works...
  • CHILD / How it works...
  • MEASURES_ALIAS / How it works...
  • CONSOLIDATION / How it works...
  • TWOPASSCALC / How it works...
  • STORAGE / How it works...
  • VARIANCEREPORTING / How it works...
  • TIMEBALANCE / How it works...
  • SKIP / How it works...
  • UDA / How it works...
  • FORMULA / How it works...
  • COMMENT_ESSBASE / How it works...
• columns for outline formulas
  • adding / Adding columns for outline formulas, How to do it...
  • working / How it works...
• column templates
  • creating / How to do it..., How it works..., See also
• Compare Files… function / How it works...
• conditional operator
  • using / Using control flow commands, conditional, and logical operators
  • working / How it works, See also
• Connection Wizard / How it works…
  • using, for ASO cube setup / Using the Connection Wizard to set up an ASO cube, How to do it...
  • working / How it works...
  • ASOsamp dimensions / How it works...
• conn param / How it works
• consolidation button / How to do it...
• Consolidations values
  • % / How it works...
  • * / How it works...
  • + / How it works...
  • - / How it works...
  • / / How it works...
  • ^ / How it works...
  • ~ / How it works...
• Context tab / How it works
• control flow commands
  • using / Using control flow commands, conditional, and logical operators, Getting ready, How to do it...
  • working / How it works, See also
• Converting Calc Formulas to MDX in an Essbase Outline / How it works...
• CPL / How it works...
• cross-dimensional operator
  • about / Clearing data and using the cross- dimensional operators in a calculation script
  • using, for data clearing / Clearing data and using the cross- dimensional operators in a calculation script, How to do it...
  • working / How it works, See also
• CTRL+C / How to do it...
• CTRL+V / How to do it...
• Cube Deploymernt Wizard / How to do it…
• cubes
  • calculating, Essbase Set function commands used / Using Essbase Set function commands and Calc All to calculate cubes, How to do it..., How it works..., See also
  • calculating, Calc All used / Using Essbase Set function commands and Calc All to calculate cubes, How to do it..., How it works..., See also
• cube schema, ASO cube building
  • creating / Creating an ASO Cube Schema and an Essbase Model, How to do it...
  • working / How it works...
• cube schema, BSO cube building
  • about / Developing cube schema and an Essbase model, How to do it…
  • developing / How to do it…
  • working / How it works...
• CurMth substitution variable / How it works

D

• data
  • exporting, column format used / Exporting data using column format, How to do it..., How it works...
  • retrieving, UDAs used / Retrieving data using UDAs and Attributes, How to do it..., How it works...
  • retrieving, Attributes used / Retrieving data using UDAs and Attributes, How to do it..., How it works...
  • retrieving, member set functions used / Retrieving data using children and descendants member set functions, How to do it..., How it works...
• Database Connection / Creating a web analysis report
• Database Measures tab / How to do it…
• DATAEXPORT
  • using, for data extraction to text file / Using the DATAEXPORT function to extract data into a text file, How to do it..., How it works...
  • using, for data extraction into relational source / Using the DATAEXPORT function to extract data into a relational source, Getting ready, How to do it...
  • working / How it works...
  • parameters / How it works...
• DATAEXPORT function / Using the DATAEXPORT function to extract data into a text file
  • parameters / How it works...
• DATAEXPORTOPTIONS settings
  • DataExportLevel / How it works..., How it works...
  • DataExportColFormat / How it works...
  • DataExportOverwriteFile / How it works...
  • DataExportDimHeader / How it works...
  • DataExportRelationalFile / How it works..., How it works...
  • DataExportColHeader / How it works..., How it works...
• data partioning
  • from BSO to ASO cube / Partitioning data from BSO to ASO cubes, How to do it..., How it works...
• Data Source dialog / How to do it…
• Data Source Properties button / How to do it...
• Date-Hierarchy button / How to do it…
• date elements
  • about / Creating date elements
  • creating / Getting ready, How to do it…
  • working / How it works...
• date measures
  • using, on BSO cube / Using Date measures on a BSO cube, How to do it...
  • working / How it works...
• description / How it works
• Dimension Build button / How to do it...
• Dimension build field button / How to do it...
• dimension build rules / Introduction
  • using, for parent-child dimension addition / Using dimension build rules to add the parent-child dimension, How to do it...
  • working / How it works...
  • setting up, for Sample Basic database outline modification / Creating dimension build rules to add a base and attribute dimensions, How to do it...
  • attribute dimensions, working / How it works...
  • build method / There's more...
  • using, for user-defined attributes addition / Using dimension build rules to add user-defined attributes and associate dimensions, How to do it...
  • using, for associate dimensions additions / Using dimension build rules to add user-defined attributes and associate dimensions, How to do it..., How it works...
  • executing, MaxL used / Executing dimension build rules using MaxL, How to do it..., How it works...
• Dimension Build setting button / How to do it...
• dimensions
  • setting up, in generation format / Setting up dimensions with a generation reference, Getting ready, How to do it...
  • generation reference, working / How it works...
  • adding, outline editor used / Using the outline editor to add dimensions, How to do it...
• DIRECTOR attribute / How to do it…
• Document Wizard / Creating a web analysis report
• drill-through report
  • designing / Designing a drill-through report, Getting ready, How to do it...
  • working / How it works
• DRM / Adding and populating the Sort Order Column
• DYNAMIC parameter / How it works
• Dynamic Time Series reporting / Using the View dimension for Dynamic Time Series reporting
  • about / Using the View dimension for Dynamic Time Series reporting
  • View dimension, using / Using the View dimension for Dynamic Time Series reporting, How to do it...

E

• EAS / Adding and populating the Sort Order Column, How it works..., Introduction, Introduction
  • about / Introduction
• EIS / Introduction
  • OLAP Model, creating / Creating an OLAP Model in EIS, How to do it…
  • about / Creating an OLAP Model in EIS
  • OLAP metaoutline, creating / Creating an OLAP metaoutline in EIS
• EMPTY parameter / How it works
• enabled / How it works
• Enter key / How to do it..., How to do it..., How to do it...
• Essbase
  • security / Introduction
• Essbase database / Introduction
  • cache type, adjusting / How it works...
• Essbase Integration Services (EIS) / Designing a drill-through report
• Essbase Model, ASO cube building
  • creating / Creating an ASO Cube Schema and an Essbase Model, How to do it...
  • working / How it works...
• Essbase model, BSO cube building
  • about / Developing cube schema and an Essbase model, How to do it…
  • developing / How to do it…
  • working / How it works...
• Essbase Model properties, ASO cube building
  • about / Getting ready
  • listing / How to do it...
  • working / How it works..., There's more...
  • stored hierarchy / How it works...
  • dynamic hierarchy / How it works...
  • multiple hierarchy enabled / How it works...
• Essbase Outline Extractor
  • using, for dimensions extract / Using the Essbase Outline Extractor to extract dimensions, How to do it...
  • working / How it works...
• Essbase properties, BSO cube building
  • about / Setting Essbase properties
  • setting / Getting ready, How to do it…
  • working / How it works...
• Essbase Server
  • database, adding / Adding an application and database on an Essbase Server, How to do it...
  • application, adding / Adding an application and database on an Essbase Server, How to do it...
  • appliccation creating, points / How it works...
  • database creating, points / How it works...
  • working / How it works...
  • file extensions / How it works...
• Essbase Server Roles
  • administrator / How it works...
• Essbase Set function commands / Getting ready , How to do it...
  • working / Getting ready
• Essbase settings
  • modifying, for calculation improvement / Modifying Essbase settings to improve calculation performance, How to do it...
  • working / How it works...
• Essbase Studio
  • about / Introduction
  • advantages / Advantages of Essbase Studio
  • disadvantages / Disadvantage of Essbase Studio
  • development steps / Introduction
  / Introduction
• Exclude from Consolidate button / How to do it...
• Execute Script button / How to do it..., How to do it...
• Execute script button / How to do it...
• Export button / How to do it...
• Export Outline MaxL / Using MaxL to extract the outline in XML format

F

• fact table
  • Measures dimension, building / Building a Measures dimension from the fact table, Getting ready, How to do it...
• Field Options command button / How to do it...
• Field Properties button / How to do it...
• file extensions
  • db / How it works...
  • dbb / How it works...
  • esm / How it works...
  • ind / How it works...
  • otl / How it works...
  • pag / How it works...
  • tct / How it works...
• financial reports
  • connection, creating / Creating a connection and using substitution variables in financial reports, How to do it...
  • substitution variables, using / Creating a connection and using substitution variables in financial reports, How to do it...
  • working / How it works..., How it works...
  • conditional formatting, using / Using conditional formatting and suppression in financial reports, How to do it...
  • conditional supression, using / Using conditional formatting and suppression in financial reports, How to do it...
  • conditional formatting, working / How it works...
  • conditional supression, working / How it works...
  • related contents, adding / Adding related content to financial reports, How to do it...
• Financial Report Studio / How it works...
• Find Rule File button / How to do it...
• flat file data loads
  • rules, creating / Creating load rules for flat file data loads, How to do it...
  • working / How it works...
• folder structure
  • setting up / Setting up folder structure and other files needed for MaxL automation, How to do it...
  • working / How it works
• format settings
  • SUPCOMMAS / How it works...
  • SUPBRACKETS / How it works...
  • SUPHEADING / How it works...
  • ROWREPEAT / How it works...
  • SUPMISSINGROWS / How it works...
  • SUPZEROROWS / How it works...
  • TABDELIMIT / How it works...
  • NOINDENTGEN / How it works...
  • DECIMAL VARIABLE / How it works...
  • SUPSHARE / How it works...

G

• generation reference table
  • hierarchies, creating / Creating hierarchies using a generation reference table, How to do it…
  • working / How it works…
• Get Standard SQL button / How it works
• Grid menu / How to do it...

H

• hierarchies
  • deterimining, in relational tables / Determining hierarchies in relational tables, How to do it...
  • working / How it works...
  • creating, parent-child reference table used / Creating hierarchies using a parent-child reference table, How to do it…
  • creating, generation reference table used / Creating hierarchies using a generation reference table, How to do it…
  • attribute dimensions, adding / Adding attribute dimensions to hierarchies, How to do it…
• HypExecuteMDXEx function / How to do it..., How it works...
• HypF variable / How it works...
• HypIsConnectedToAPS function / How it works...

I

• If/Else logic
  • using, in outline formulas / Using If/Else logic and substitution variables in outline formulas, How to do it..., How it works...
  • working / How it works...

J

• joins setup, in minischema
  • about / Setting up joins in a minischema
  • steps / How to do it...
  • working / How it works..., There’s more…, See also

L

• Launch button / How to do it...
• linked, partition types / How it works...
• lintRow variable / How it works...
• load rule, for SQL data load
  • creating, substitution variables used / Creating a load rule for SQL data load using substitution variables, How to do it...
  • working / How it works..., See also
• load rules
  • executing, MaxL used / Executing load rules using MaxL, How to do it..., How it works...
• location alias / How it works...
• logged in / How it works
• logical operators
  • using / Using control flow commands, conditional, and logical operators
  • working / How it works, See also
• Login button / How to do it...
• Log in button / Getting ready
• lstrError variable / How it works...

M

• @MDALLOCATE function / Using allocation functions in calculation scripts
• Margin % Sales / How it works...
• MaxL
  • dimension build rules, executing / Executing dimension build rules using MaxL, How to do it..., How it works...
  • using, for load rules execution / Executing load rules using MaxL, How to do it..., How it works...
  • using, for calculation execution / Executing calculations using MaxL, How to do it..., How it works...
  • using, for partitions execution / Executing partitions using MaxL, How to do it..., How it works...
  • using, for report script execution / Executing report scripts using MaxL
  • using, for outline extraction in XML format / Using MaxL to extract the outline in XML format, How to do it...
  • working / How it works...
• MaxL automation
  • folder structure, setting up / Setting up folder structure and other files needed for MaxL automation, How to do it...
  • folder structure, working / How it works
• MaxL editor
  • using, for user externalization / Using MaxL editor to add and externalize a user, Getting ready, How to do it..., How it works, There's more...
  • using, for user addition / Using MaxL editor to add and externalize a user, Getting ready, How to do it..., How it works, There's more...
  • working / How it works
  • using, for MetaRead setup / Using MaxL Editor to set up a filter for MetaRead and Write access, How to do it..., How it works...
  • using, for Write access setup / Using MaxL Editor to set up a filter for MetaRead and Write access, How to do it..., How it works...
• MaxL script
  • using, for security file export / Using MaxL to export security file, How to do it..., How it works...
• MDX
  • using, in aggregate storage applications / Using MDX in aggregate storage applications, How to do it..., How it works...
  • using, for ASO calculation / Using MDX to calculate Aggregate Storage database, How to do it...
  • using, for data extraction / Using MDX for extracting data using API, How to do it...
  • working / How it works..., There's more...
• MDX Script Editor / How it works
• Measure dimension
  • setting up, parent-child reference used / Setting up an Account or Measures dimension with a parent-child reference, How to do it...
• Measures dimension
  • building, from fact table / Building a Measures dimension from the fact table, Getting ready
  • working / How it works...
  • properties / There's more..., See also
• MEASURES table
  • columns / How it works...
  • additional tables, adding / Adding the solve order column to tables that have ASO formulas
• Member button / How to do it...
• MetaRead
  • setting up, MaxL Editor used / Using MaxL Editor to set up a filter for MetaRead and Write access, How to do it..., How it works...
• method parameter / How it works...
• minischema
  • building / Building your minischema, Getting ready, How to do it…
  • working / How it works..., See also
  • joins, setting up / Setting up joins in a minischema
  • tables, adding to / Adding tables to a minischema
• Minischemas tab / How to do it...
• Minischema Wizard / How it works...
• Move Field button / How to do it...
• MSAD / How it works
• Multidimensional Expressions (MDX) / Adding columns for outline formulas

N

• Ndim parameter / How it works...
• New Connection button / How to do it...
• NONINPUT parameter / How it works

O

• OLAP metaoutline , EIS
  • creating / Creating an OLAP metaoutline in EIS
  • creating, steps / How to do it…
  • working / How it works...
• OLAP Model, in EIS
  • creating / Creating an OLAP Model in EIS, How to do it…
  • working / How it works...
• Oracle Data Integrator (ODI) / There's more...
• Oracle Essbase Road Map / Introduction
• Oracle Essbase Studio User's Guide / Introduction
• Oracle Internet Directory (OID) / How it works
• outline editor
  • using, for dimensions sddition / Using the outline editor to add dimensions, How to do it...
  • working / How it works...
• outline formula logic
  • using, at parent level / Using different outline formula logic at parent level, How to do it...
  • working / How it works...
• outline formulas
  • If/Else logic, using / Using If/Else logic and substitution variables in outline formulas, How to do it..., How it works...
  • substitution variables , using / Using If/Else logic and substitution variables in outline formulas, How to do it..., How it works...

P

• @PARENTVAL function / How it works...
• parent-child dimension
  • adding, dimension build rules used / Using dimension build rules to add the parent-child dimension, How to do it...
  • working / How it works...
• parent-child reference table
  • about / Creating hierarchies using a parent-child reference table
  • hierarchies, creating / Getting ready, How to do it…
  • working / How it works…, See also
• partition / Introduction
• partitions
  • executing, MaxL used / Executing partitions using MaxL, How to do it..., How it works...
• password_reset_days / How it works
• Period dimension
  • about / How it works
• PeriodsToDate function / How it works
• POV
  • using / Getting ready, How to do it...
  • working / How it works..., See also
• Preview… button / How to do it…
• Print Preview button / How to do it..., How it works...
• privilege
  • create_application / How it works
  • create_database / How it works
  • no access / How it works
  • administrator / How it works
  • designer / How it works
  • read / How it works
  • write / How it works
  • filter / How it works
  • execute / How it works
• Profit % Sales / How it works...
• protocol / How it works

R

• @RANK function / How it works...
• @Relative function / How it works...
• @RETURN function / How it works
• Rebuild button / How it works...
• Refresh button / How to do it...
• reject selected record functionality / Introduction
• relational tables
  • hierarchies, determining / Determining hierarchies in relational tables, How to do it...
  • working / How it works...
• replicated, partition types / How it works...
• replicated partition / Introduction
• report
  • formatting / How it works..., See also
• report script
  • executing, MaxL used / Executing report scripts using MaxL
  / Introduction
• Report Script Editor / Using report script to extract data to a text file
  • using, for data extraction to text file / Using report script to extract data to a text file, How to do it..., How it works...
  • working / How it works..., See also
• Repository menu / How to do it...
• result_Native variable / How it works...
• result_VBCompatible variable / How it works...
• rules
  • creating, for flat file data loads / Creating load rules for flat file data loads, How to do it...

S

• @SUM function / How it works...
• SALESMAN attribute / How to do it…
• Sample Basic database / There's more...
• security file
  • exporting, MaxL script used / Using MaxL to export security file, How to do it..., How it works...
• Select Table tab / How to do it...
• server.datafile.dir property / How it works…
• server.properties file / How it works…
• Server Access / How it works...
• SET MSG DETAIL command / How it works...
• Shared Service
  • using, for filter to group provisioning / Using Shared Services to provision filters to a group, How to do it..., How it works...
  • using, for calculation scripts to group provisioning / Using Shared Services to provision calculation scripts to a group, How to do it..., How it works...
• Shared Services
  • using, for user addition / Using Shared Services to add and provision a user, How to do it..., How it works...
  • using, for user provision / Using Shared Services to add and provision a user, How to do it..., How it works...
  • working / How it works...
• Shift key / How to do it…, How to do it...
• Single Sign On (SSO) / How it works
• Skip options
  • B type / How it works...
  • M type / How it works...
  • Z type / How it works...
• solve order column, adding to ASO formula tables
  • about / Adding the solve order column to tables that have ASO formulas
  • starting with / Getting ready, How to do it...
  • working / How it works...
• Sort Order Column
  • about / Adding and populating the Sort Order Column
  • populating / Getting ready, How to do it...
  • adding / Getting ready, How to do it...
  • working / How it works...
• SQL data load
  • load rule creating, substitution variables used / Creating a load rule for SQL data load using substitution variables, How to do it...
• SQL load rules / Introduction
• SQL Server Management Studio / Getting ready
• Star Analytics
  • using, for star schema building / Using Star Analytics to build your star schema from existing Essbase cubes, Getting ready, How to do it...
  • working / How it works...
• Star Integration Server Manager / Using MaxL to extract the outline in XML format
• Storage values
  • N type / How it works...
  • O type / How it works...
  • S type / How it works...
  • V type / How it works...
  • X type / How it works...
• sts variable / How it works...
• Submit Data button / How to do it...
• substitution variables
  • about / Creating substitution variables
  • creating / Getting ready
  • working / How it works..., There's more..., There's more..., How it works..., How it works...
  • using, in outline formulas / Using If/Else logic and substitution variables in outline formulas, How to do it..., How it works...
  • using, for load rule creating / Creating a load rule for SQL data load using substitution variables, How to do it...
  • using, in calculations script / Using substitution variables in calculations script , How to do it...
• Switch to Analyze View button / How to do it...

T

• tables, adding to minischema
  • about / Adding tables to a minischema, Getting ready
  • steps / How to do it…
  • working / How it works…
• TBC sample database
  • connecting, to data source / Creating TBC sample database and connecting to the data source, Getting ready, How to do it...
  • creating / Creating TBC sample database and connecting to the data source, Getting ready, How to do it...
  • working / How it works...
• Test button / How to do it...
• Test Connection button / How to do it...
• TEXT attribute / How it works...
• text file data source
  • using / Using a text file data source, How to do it…
  • working / How it works…
• Text File Location dialog / How to do it…
• text measures
  • using, on BSO cube / Using Text measures on a BSO cube, How to do it...
  • working / How it works...
• The Beverage Company (TBC)
  • fact table / There's more...
  • design / There's more...
  / There's more...
• Time Balance values
  • A type / How it works...
  • F type / How it works...
  • L type / How it works...
• TIME dimension / How it works...
• transparent, partition types / How it works...
• Two Pass value
  • T / How it works...
• type / How it works

U

• @UDA function / How it works...
• UDAs
  • using, in calculation scripts / Getting ready
  • working / How it works..., There's more..., How it works...
  • using, for data retrieval / Retrieving data using UDAs and Attributes, Getting ready, How to do it...
• Unassign button / How to do it...
• Update button / How it works...
• user / How it works
  • adding, MaxL editor used / Using MaxL editor to add and externalize a user, Getting ready, How to do it..., How it works, There's more...
  • externalizing, MaxL editor used / Using MaxL editor to add and externalize a user, Getting ready, How to do it..., How it works, There's more...
  • provisioning, Shared Service used / Using Shared Services to add and provision a user, How to do it..., How it works...
  • adding, Shared Service used / Using Shared Services to add and provision a user, How to do it..., How it works...
• user-defined attributes
  • adding, dimension build rules used / Using dimension build rules to add user-defined attributes and associate dimensions, Getting ready, How to do it...
  • working / How it works...
• user-defined tables
  • about / Adding user-defined tables, Getting ready
  • adding / How to do it...
  • working / How it works...
• User Prompts
  • using / Getting ready, How to do it...
  • working / How it works..., See also

V

• @VAR function / How it works...
• @VARPER functions / How it works...
• Validate rule file button / How to do it...
• Variance Reporting value
  • E type / How it works...
• varying attributes
  • tables, adding / Adding tables for varying attributes, How to do it...
  • working / How it works...
• Verify Corrections to Outline screen / How to do it...
• View dimension, using for Dynamic Time Series reporting
  • about / Using the View dimension for Dynamic Time Series reporting
  • steps / How to do it...
  • starting with / How to do it...
  • working / How it works
• vtAliasTable variable / How it works...
• vtBoolDataless variable / How it works...
• vtBoolHideData variable / How it works...
• vtBoolNeedStatus variable / How it works...
• vtMbrIDType variable / How it works...
• vtQuery variable / How it works...

W

• @WithAttr function / Using Attributes in calculation scripts
• web analysis report
  • creating / Creating a web analysis report, How to do it...
  • working / How it works...
• Web Preview button / How to do it...
• Write access
  • setting up, MaxL Editor used / Using MaxL Editor to set up a filter for MetaRead and Write access, How to do it..., How it works...

X

• @XREF functions
  • using, for data moving between BSO cubes / Using @XREF functions to move data between BSO cubes, Getting ready, How to do it...
  • working / How it works...
• @XWRITE function / Introduction
• XML outline extraction
  • MaxL, using / Using MaxL to extract the outline in XML format, How to do it...
• XOLAP
  • about / Introduction