HyperionGuru: Essbass interview collection

What are LRO’s( Linked Reporting Objects)?
Ans: They are specific objects like files, cell notes or URL’s associated with specific data cells of Essbase database. You can link multiple objects to a single data cell. These linked objects are stored in the server. These LRO’s can be exported or imported with the database for backup and migration activities.

What are the three primary build methods for building dimensions?
Ans:
1. Generation references

2. Level references

3. Parent-Child references

How does UDA’s impact database size?
Ans: There will be no impact on the database as the UDA’s doesn’t store data in the database.

Can we have an meta outline based on two different OLAp models.
Ans: No.

Can we create UDA’s and apply it to Dense as well as Sparse dimensions?
Ans: Yes

Types of Partitions available in Essbase?
Ans: Three types of partitions are there.

1. Transparent partition: A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users

2. Replicated Partition: ensure the data source and data target contain same number of cells and two partition have the same shape.

3. Linked Partition:is creating database in local database and in remote essbass server host to validate .

What is hybrid analysis?
Ans: Lower level members and associated data remains in relational database where as upper level members and associated data resides in Essbase database.

Why top-down calculation less efficient than a bottom-up calculation?Being less efficient, why do we use them.
Ans: In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.

On what basis you will decide to invoke a serial or parellel calculation method.
Ans: If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.

How can you display UDA’s in reports?
Ans: UDA’s values are never displayed in the reports and hence do not impact report performance.

While loading the data, you have applied both the selection criteria as well as rejection criteria to a same record. What will be the outcome?
Ans: The record will be rejected.

What are the specified roles other than Aministrator to view sessions, disconnect sessions or kill users requests for a particular application?
Ans: You should have the role of Application manager for the specified application.

What is block locking system?
Ans: Analytic services(or Essbase Services) locks the block and all other blocks which contain the childs of that block while calculating this block is block locking system.

What are the three options specified in Username and Password management under security tab in Essbase server proprties.
Ans: 1. Login attempts allowed before username is disabled.

2. Number of inactive days before username is diabled.

3. Number of days before user must change password.

Can we have multiple databases in one single application?
Ans: Yes. But only one database per application is recommended.

Depend on which database that you are going to create. For Example: If you are creating ASO then we can’t create more that 1 db per application. If you are creating BSO then you can create more than 1 db per application

How is data stored in the Essbase database?
Ans: Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.

We have created an application as unicode mode. Can we change it later to non-unicode mode.
Ans: No

What are the types of partitioning options available in Essbase?
Ans: 1. Replicated partition. 2. Transparent partition 3. Linked partition.

Dynamic calc decreases the retreival time and increases batch database calculation time. How true is the statement?
Ans: The statement should be just opposite. As dynamic calc members are calculated when requested, the retreival time should increase.

What is the role of provider services.
Ans: To communicate between Essbase and Microsoft office tools.

A customer wants to run two instances of an Essbase server on a same machine to have both test environment and Development environment on the same server. Can he do that?
Ans: Yes. We can have multiple instances of an Essbase server on a single machine and there will be different sets of windows services for all these instances.

Can we have multiple databases in one single application?
Ans: Yes. But only one database per application is recommended.

Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why.
Ans: No. Because we define ASO or BSO option while creating the appication and not database. Hence if the application is ASO, the databases it contains will be that type only.

What are the file extensions for an outline, rule file and a calc script.
Ans: .OTL, .RUL and .CSC

What is the role of provider services.
Ans: To communicate between Essbase and Microsoft office tools.

What is an alternative to create metaoutline, rule file and load data.
Ans: Integration services and in version 11, we have Essbase studio.

What is data file cache?
Ans: A buffer in memory that holds compressed data (.PAG) files.

What is custom defined function?
Ans: Essbase calculation functions that you develop in the Java programming language and then add to the standard Essbase calculation scripting language by means of MaxL.

Can we start and stop an application individually. How ca this be used to increase performance.
Ans: Yes. We can manage our server resources by starting only the applications which receive heavy user traffic. When an application is started, all associated databases are brought to the memory.

We have created an application as unicode mode. Can we change it later to non-unicode mode.
Ans: No.

How can I migrate an application from my test environment to the production environment. Can I still do this if my test environment is a windows one and my production env is UNIX one. Also can I still do it if my test env and prod env versions are different.
Ans: Hyperion Administrative services console provides a migration utility to do this but only the application, database objects are migrated and no data is transferred. the answers to other two questions are Yes.

A customer wants to run two instances of an Essbase server on a same machine to have both test env and Development env on the same server. Can he do that?
Ans: Yes. We can have multiple instances of an Essbase server on a single machine and there will be dfferent sets of windows services for all these instances.

Suppose I have a dimension A with members B and C and I do not want B and C to roll up to A. how can I do this.
Ans: Using (~) exclude from consolidation operator.

What is custom based macro?
Ans: Essbase macros that we write with Essbase calculator functions and special macro functions. Custom-defined macros use an internal essbase macro language that enables you to combine calculation function and operate on multiple input parameters.

What do you mean by dirty block?
Ans: A data block containing cells that have been changed since the last calculation. Upper level blocks are marked as dirty if their child blocks are dirty (that is, have been updated)

When do we generally use build rules files?
Ans: To automate the process of creating dimensions with more members, where it will take a lot of time in creating manually.

What does never consolidate operator(^) do?
Ans: It prevents members from being consolidate across any dimension.

Can we create more than 2 dimensions using only one build rule file.
Ans: Yes, we can do that but it is recommended to use seperate rule file for each dimension.

What is UDA( user defined attributes). How are they different than Aliases.
Ans: UDA represents the class of the members. Aliases are just another names of the members. both are different and has different usage.

What is the Extension of Cal Scripts, Batch files, outline, and Rule File?
Ans: Rule file is .rul

Calc Script is – .csc

Batch files – .bat

outline – .otl

Why are Filters used?
Ans: If you want to grant access to all dimensions then you wouldn’t use a filter. Just grant read access for the database to the user and/or group. The only reason you would use a filter is if you wanted to restrict access.

What are Dense and Sparse Dimensions?
Ans: Dense: A dimension which has the high probability that data exists for every combination of dimension members

Sparse: A dimension which has low probability that data exists for every combination of dimension members

Can we query a member for its UDA in a calculation script.
Ans: Yes. You can query a member for its UDA in a calculation script.

How does UDA’s impact database size?
Ans: Absolutely no impact as UDA’s do not require additional storage space.

How does Essbase recover from a database crash?
Ans: After a database crash or server interruption, Essbase automatically recovers a database after rolling back the transactions that were active at that time.

Can we build dimensions directly from data sources without using rule files.
Ans: No.

When do we generally use build rules files?
Ans: To automate the process of creating dimensions with thousands of members.

What are the three primary build methods for building dimensions?
Ans: 1. Generation references

2. level references

3. Parent-Child references.

What is the difference between ASO & BSO?
Ans: i. We cannot create more than 1 database in ASO, but we can create more than 1 db per application. If we have more dimensions (generally more than 10) then we will go for ASO

ii. we cannot write back in ASO, but we can write back in BSO.

iii. Most of the dimensions are sparse in ASO whereas in BSO most of them are dense.

How can we backup an aggregate storage database?
Ans: To back up an aggregate storage database, copy the application directory ARBORPATH/app/appname.

How can you make a Max L script run at a specified time?
Ans: MaxL scripts can be called from a BAT file which is used for scheduling.

I have created an application with one database in Essbase at test environment and now needs to copy the entire application with all security permissions to the production server which is not connected to the test server. How can I do that?
Ans: You can acheive this using migration wizard to migrate an application to a text file which you can take physically to the production server.

To know how you can do that, take a look at this post Essbase Application Migration.

In what case we can define generation 1 to a feild in generation build method.
Ans: We cannot define that as Generation 1 is not valid.

What is Incremental Dimensional Built and one time Dimension Built?
Ans: Incremental Dimensional Build: Builds and reads from different data sources for dimension builds and delay restructuring until all data sources have been processed.

Can we have multiple databases in one single application?
Ans: Yes. But only one database per application is recommended.

What are the file extensions for an outline, rule file and a calc script.
Ans: .OTL, .RUL and .CSC

What is the role of provider services.
Ans: To communicate between Essbase and Microsoft office tools.

What is an alternative to create metaoutline, rule file and load data.
Ans: Integration services and in version 11, we have Essbase studio.

What is data file cache?
Ans: A buffer in memory that holds compressed data (.PAG) files.

We have created an application as unicode mode. Can we change it later to non-unicode mode.
Ans: No.

How can I migrate an application from my test environment to the production environment. Can I still do this if my test environment is a windows one and my production env is UNIX one. Also can I still do it if my test env and prod env versions are different.
Ans: Hyperion Administrative services console provides a migration utility to do this but onluy the application, database objects are migrated and no data is transferred. the answers to other two questions are Yes.

Suppose I have a dimension A with members B and C and I do not want B and C to roll up to A. how can I do this.
Ans: Using (~) exclude from consolidation operator.

What is custom based macro?
Ans: Essbase macros that we write with Essbase calculator functions and special macro functions. Custom-defined macros use an internal Essbase macro language that enables you to combine calculation function and operate on multiple input parameters.

What is meant by Clean block and Dirty block?

to be simple ...when u load the data its dirty l and whn u calculate the same data its clean thats all

When Intelligent Calculation is enabled, Essbase calculates only dirty blocks and their dependent

parents. When disabled, Essbase calculates all data blocks, regardless of whether they are marked

as clean or dirty.

To be much more specific:

Marking Blocks As Clean

Essbase marks data blocks as clean in these types of calculations:

● A full calculation (CALC ALL) of a database (the default calculation).

● A calculation script that calculates all the dimensions in one CALC DIM statement.

For example, the following calculation script calculates all members in the Sample Basic

database:

CALC DIM(Measures, Product, Market, Year, Scenario);

Compare this calculation script to a calculation script that calculates all the members with

two CALC DIM statements:

Marking Blocks as Dirty

Essbase marks a data block as dirty in the following situations:

● Calculating the data block for a partial calculation of the database only if SET

CLEARUPDATESTATUS AFTER is not part of the partial calculation statement in the

calculation script

● Loading data into the data block

● Restructuring the database (for example, by adding a member to a dense dimension)

● Copying data to the data block; for example, using DATACOPY

What are the Commands of Intelligent calculation?

SET CLEARUPDATESTATUS AFTER is a calculation command that engages intelligent calc for any calc script, regardless of construction

How do you calculate the subset of a cube?

You can write calculation scripts. Within the calc script use

Fix ( members which form the subset of DB)

/*Perform your calculation*/

EndFix

What is the difference between standard dimension and attribute dimension?

Standard dimensions represent the core dimensions eg.Time, Account

Attributes describe characteristics of data such as product size and color.

What is the difference between UDA and Attribute Dimension?

Essbase UDA is a descriptive word or tag about an outline member.

What is meant by XREF Function?

Enables a database calculation to incorporate values from a different database.

Can you give the same name to different members in UDA?

What is Data Cahce ?

he data file cache is a buffer in memory that holds compressed data files (.pag files)

What is the Difference between the Data Cache and Data File Cache?

he data file cache is a buffer in memory that holds compressed data files (.pag files)

A buffer in memory that holds uncompressed data blocks. Essbase allocates memory to the data cache during data load, calculation, and retrieval operations, as needed.

What is the Size of your cube?

What is Shared members? Can shared members can have children below it ?

What are the different storage properties in Essbase?

What is the difference between Dynamic calc and Dynamic Calc and Store?

Dynamic calc:

The data associated with the member is not calculated until requested by a user. The calculated data is not stored; it is discarded after the request is completed.

Dynamic calc and store:

The data associated with the member is not calculated until it is requested by a user. The calculated data is then stored.

How does Essbase consolidates the Data?

Ans: consolidation operator defines rolling up of data of each member to the parent.

What are the Different types of Dimension Building?

What is Label only? Give the the example of it?

abel only members the “no consolidation” property

What is the Difference between calc all and Calc Dim?

This command calculates the formulas and aggregations associated with each member of all of the specified dimensions cal all

Dimension or comma-delimited list of dimensions to be calculated cal dim

Explain me about your project? And tell me any difficulties that you have faced and how did you resolve it?

What is Commit Block?

The commit blocks setting tells Essbase how frequently to write blocks to the database during data loads / lock and sends.

Tell me different steps so that your can optimze the performance your cube?

What is Partition?

Hyperion Essbase Partitioning is a collection of features that makes it easy to design and administer databases that span Hyperion Essbase applications or servers. You must license Hyperion Essbase Partitioning separately from Hyperion Essbase OLAP Server. You must license the Hyperion Essbase Partitioning option for every server that contains a database partition.

Partitioning can help you:

Synchronize the data in multiple partitioned databases. Hyperion Essbase tracks changes made to data values in a partition and provides tools for updating the data values in related partitions.
Synchronize the outlines of multiple partitioned databases. Hyperion Essbase tracks changes made to the outlines of partitioned databases and provides tools for updating related outlines.
Allo

What are different types of Partition? Have you ever worked on partation?Ans: Transparent, linked, replicated

What is MAXL ? and where is it used?

MaxL is the multi-dimensional database definition language (DDL) for Essbase Server. Using MaxL, you can easily automate administrative and query operations on Essbase Server.

You can write MaxL scripts in MaxL Script Editor or in an external text editor. You can open existing scripts and modify or execute them from MaxL Script Editor. You cannot save MaxL scripts as Essbase objects on Essbase Server; therefore, MaxL scripts are not displayed in Enterprise View. You can, however, enable other users to access MaxL scripts by saving them to the middle-tier Administration Server. You can also save MaxL scripts as text files on a client computer or on a network, and you can open and manage the files in MaxL Script Editor

What is Alias?

Alias is another name for dimension.

How many Alias Tables can be created?

"Creating an Alias Table

An alias table contains a list of aliases to use for outline members. These requirements apply:

•You can create up to *32* alias tables for a block storage or aggregate storage outline.

•The naming conventions for alias table names are the same as those for dimensions."

How is Data Retrived from Essbase?

How is Data Stored in ASO?

the data is stored in table spaces in a .dat file in the \App\Appname\ default folder.

What are the Different types of Attributes in ASO?

How do you create shared members in your cube?

There are three differant kinds of hierarchies in ASO model.

1) Stored

2) Dynamic

3) Multiple Hierarchies enabled.

I assume your dimension is of type stored.

Just change your dimension property to Multiple hierarchies enabled and follow the below three rules

1) The nonshared instance of the member must occur in the outline before any shared instances of the member.

2) The first hierarchy in a dimension where multiple hierarchies are enabled cannot contain a shared member.

3) Stored hierarchy dimensions cannot have shared members. Stored hierarchies within a multiple hierarchies dimension can have shared members

Why do you use Fix Command?

The FIX command is a block command that allows you to define a fixed range of dimensions or members to which the associated commands are restricted.

You can use SET EMPTYMEMBERSETS to stop the calculation within a FIX command if the FIX evaluates to an empty member set.
FIX commands can be nested within other FIX command blocks.
FIX statements can only be used in calculation scripts, not in outline member formulas. Use an IF command instead of a FIX statement in member formulas

Can you use the same logic which are used in calculation scripts in MDX formulas?

You have 5 dimensions in your cube and to load the data in the cube you have got only 4 columns what do you do?

Why do you use set update cal on and set update calc off?

What is mean by free form data load?

When do delete one member from the outline what will be status of the block?

What are different Types of blocks?

What is the difference between Attributes and UDA?

What is meant by location Alias?

Tell me about your project and what is your role in your project?

Did you write any MDX Member formulas in your Project?

What are different Types of Data Blocks?

Where do you check the data has been loaded properly or not?

What is Fact Table ? What are supporting Dimensions?

What is your Fact Table in Cube?

a Fact table consists of the measurements, metrics or facts of a business process. It is located at the center of a star schema or a snowflake schema surrounded by dimension tables.

1. What are new features in 7.x version?

• Aggregate Storage option

• Hyperion Hub

• Triggers

2. What is MOLAP? What is MDDB? What are features available with Multidimensional Data base?

• Essbase OLAP Server contains multidimensional databases that support analysis and management reporting applications that are described as online analytical processing (OLAP) applications.

• A multidimensional database supports multiple views of data sets for users who need to analyze the relationships between data categories.

• Multidimensional databases consolidate and calculate data to provide different views. Only the database outline, the structure that defines all elements of the database, limits the number of views.

• With a multidimensional database, users can pivot the data to see information from a different viewpoint, drill down to find more detailed information, or drill up to see an overview.

3. What Essbase Administration Services will do In Essbase?

Ans: Essbase Administration Services is for managing and maintaining Essbase. Essbase Administration Services consists of a client console and a middle tier server that communicate directly with Essbase OLAP Servers.

4. What are differences between Application Manager and Essbase Administration services?

Ans: With Admin services,

• We can run calc scripts directly from editor.

• Migrate application from one server to other server.

• You can restructure database from admin console.

• You can start and stop OLAP server.

II. Essbase Client/Server Architecture

1. What server agent will do?

• The server runs a Server Agent (ESSBASE) process that acts as a traffic coordinator for all user requests to Essbase applications.

• Administrative requests, such as logging in and logging out, starting and stopping applications and databases, and viewing user security information, are handled by the Essbase Server Agent (ESSBASE).

2. What ESSSVR process will do?

Application server (ESSSVR) handles client requests for data, such as data loads, calculations, spreadsheet reports, and data lock and unlock..

III. Application/database Creation and settings

1. What files will be created once you created application?

.app, .apb, and application log file.

2. I have 4 databases in my application then how many database log files can be created in Application?

Only one application log

(Note: Only one app log is created for one application)

3. What files will be created once you created database?

.db, .dbb, .esm, .tct, and .ind

IV. Outline creation and settings

1. What is outline and what is it contains?

Database outlines define the structure of a multidimensional database, including all the dimensions, members, aliases, tags, types, consolidations, and mathematical relationships. The structure defined in the outline determines how data is stored in the database.

When a database is created, Essbase creates an outline for that database automatically. The outline has the same name as the database (dbname.OTL).

2. What is difference between non-attribute/standard and attribute dimensions?

Standard dimensions represent the core components of a business plan and often relate to departmental functions.

Attribute dimensions are a special type of dimension and are associated with standard dimensions. Through attribute dimensions, you group and analyze members of your standard dimensions. It doesn’t associate any data.

3. Why they classified standard dimensions as dense and sparse? What is difference between Dense and Sparse dimensions?

Essbase maximizes performance by dividing the standard dimensions of an application into two types: dense dimensions and sparse dimensions.

Most multidimensional databases are inherently sparse: they lack data values for the majority of member combinations. A sparse dimension is a dimension with a low percentage of available data positions filled.

Most multidimensional databases also contain dense dimensions. A dense dimension is a dimension with a high probability that one or more data points is occupied in every combination of dimensions.

4. What is difference between generation and level?

Generation: Any member can have only one generation and Top to Bottom

Level: Any member can have more than one level and Bottom to Top

5. What are storage properties available in Essbase?

Store Data:

Computed, when the default calculation script is run.

Dynamic Calc Member (do not store data).

Computed at Reporting time. Not stored in HDD.

Dynamic Calc and Store Member.

Same as above, but after first computation, starts behaving as Stored Member.

Shared Member (do not store data).

Explicit sharing for implementing Alternate Hierarchy.

Never share data.

Explicitly mention that there should be no implicit sharing.

Label Only.

Not stored. Not computed. Used just for grouping purpose.

6. What is difference between Dynamic calc and Dynamic calc and store?

Dynamic calc:

The data associated with the member is not calculated until requested by a user. The calculated data is not stored; it is discarded after the request is completed.

Dynamic calc and store:

The data associated with the member is not calculated until it is requested by a user. The calculated data is then stored.

7. What is shared member? What are uses of shared member? What are features and limitations of shared member?

• The data associated with the member comes from base member with the same name. The shared member stores a pointer to data contained in the other member and the data is only stored once.

• Shared members are typically used to calculate the same member across multiple parents.

• Using shared members lets you use members repeatedly throughout a dimension. Essbase stores the data value only once, but it displays in multiple locations. This offers considerable space saving as well as processing efficiency.

Features:

You can have an unlimited number of shared members with the same name.
You can assign aliases to shared members.

Limitations:

The shared members must be in the same dimension.
You should not create an outline where shared members are located before

actual members in a dimension

8. What is implicit sharing?

Some members are shared even if you don’t explicitly set them as shared.

9. When does it happen/ eg of implicit sharing.

1 Single PC-C

2 Parent with all children as ~

3 Parent with only one child with a consolidation, all other with ~

10. What is never share member?

Not allow members to be shared implicitly.

11. When you want to use it?

• If you do not want a member to be shared implicitly, mark the parent as Never Share so that the data is duplicated, and is not shared.

12. What is Label only member? What are uses of label only members? What are limitations on Label only member?

• Label only members have no data associated with them.

• Use them to group members or to ease navigation and reporting from the Spreadsheet Add-in. Typically, you should give label only members the no consolidation property.

• You cannot associate attributes with label only members. If you tag as label only a base dimension member that has attributes associated with it, Essbase removes the attribute associations and displays a warning message.

13. What is significance of ‘~’?

When a member has the ~ operator, Essbase does not use it in the consolidation to its parent.

14. (What are the types of dimensions and what are the features of each one of them?

A dimension type is a property that Essbase provides that adds special functionality to a dimension.

o Time, Accounts, Country, Currency and Attribute.

15. What is the use of two pass calculation?

• Your combination of data and calculation needs may require the use a calculation script to calculate a formula twice, instead of two-pass tagging to preserve accuracy.

• You can use a two-pass calculation on member formulas that need to be calculated twice to produce the correct value.

• Whenever possible, Essbase calculates two-pass formulas at the data block level, calculating the two-pass formulas at the same time as the main calculation. Thus, Essbase does not need to do an extra calculation pass through the database. How Essbase calculates the two-pass formulas depends on whether there is a dimension tagged as time as well as a dimension tagged as accounts.

16. What is the use of Time balance calculations? If we want to work on TB what we required?

• TB provides instructions to Essbase about how to calculate the data in a dimension tagged as accounts.

• To use these tags, you must have a dimension tagged as accounts and a dimension tagged as time.

• The first, last, average, and expense tags are available exclusively for use with accounts dimension members.

• Time Balance Last The value for the last child member is carried to the parent.

• Time Balance First The value for the first child is carried to the parent.

17. What DTS will do in Essbase?

• In order to calculate period-to-date values dynamically, you need to use a Dynamic Time Series member for a period on the dimension tagged as time.

• Use built in Dynamic Time series calculations for period – to – date calculations such as YTD, QTD, & MTD accumulations. DTS calculations are on the fly and require time related dimension to be tagged as Time.

• You do not create the Dynamic Time Series member directly in the database outline. Instead, you enable a predefined Dynamic Time Series member and associate it with an appropriate generation number.

• Dynamic Time Series members are not displayed as members in the database outline. Instead, Essbase lists the currently active Dynamic Time Series members in a comment on the time dimension.

18. What is the importance of variance reporting? What are various reporting properties? To do expense reporting what we required?

• The variance reporting calculation requires that any item that represents an expense to the company must have an expense reporting tag.

• Essbase provides two variance reporting properties: expense and non-expense. The default is non-expense.

• Variance reporting properties define how Essbase calculates the difference between actual and budget data in members with the @VAR or @VARPER function in their member formulas.

• We required account dimension tag.

V. Dimension Building and Loading data

1. What we can do with Rule file?

• Rule file automate loading and maintenance of dimensions in an outline.

• With rule file,

-Add new dimensions and members to the database.

-Loading data.

2. In how many ways you can build outline using rule file?

- Parent/Child reference

- Generation Reference

- Level Reference

3. In how many ways you can load data into Database?

- Essxxxxx.pag and Essxxxx.Ind

VI. Calculation Part

1. In how many ways we can calculate database?

- Consolidation operators

- Member formula

- Calculation Scripts

2. What is intelligent calculation? What is the use of intelligent calculation?

A calculation method that tracks which data blocks have been updated since the last calculation.

When Intelligent Calculation is enabled, Essbase calculates only dirty blocks and their dependent parents.

Note: Change in Member Formula or Addition of members does not mark the block Dirty. So it’s better to turn intelligent calc OFF.

3. What is dirty block?

A data block containing cells that have been changed since the last calculation. Upper level blocks are marked as dirty if their child blocks are dirty (that is, have been updated).

4. What is difference between formula and calc script?

5. What is the use of Fix command? What are benefits we will get once you use FIX command on Dense/Sparse dimension(s)?

The FIX command is particularly useful to calculate a carefully defined subset of the values in a database.

When you use the FIX command only on a dense dimension, Essbase retrieves the entire block that contains the required value or values for the member or members that you specify. Thus, I/O is not affected, and the calculation performance time is improved.

When you use the FIX command on a sparse dimension, Essbase retrieves the block for the specified sparse dimension member or members. Thus, I/O may be greatly reduced.

6. What is use of @XREF function?

A data value from another database to be used for calculation of a value from the current database

7. What is substitution variable? What is use of substitution variable? What is the limitation? At which level we can set substitution variable?

• Substitution variables act as placeholders for information that changes regularly;

• You can use substitution variables in formulas that you include in a calculation script.

• You cannot use substitution variables in formulas that you apply to the database outline.

• You can set substitution variables at the server, application, and database levels.

8. What is optimal block size and block density to improve calculation performance?

Upto > 100 kb in Windows

Upto > 200 kb in Unix

9. How many types of restructure methods available in Essbase?

– Full Restructure

– Sparse Restructure

– Outline only Restructure

VII. Reporting part

1. How can the data be extracted from essbase Cubes?

1. Report script

2. Excel spread sheet add-in

3. VBA

VIII. Optimization

1. How the dimensions should be arranged in an outline. (What should be the order of dimension in the outline)

a. Large members Dense dimension

b. Small members Dense dimension

c. Small members Sparse dimension

d. Large members Sparse dimension

e. Attribute dimensions

2. Calculation order of the dimensions

a. Dimension tagged accounts if it is dense.

b. Dense dimensions in outline or CALC DIM statement order.

c. Dimensions tagged as Accounts if it is sparse.

d. Sparse dimensions in outline order or CALC DIM statement order.

e. Two-pass calculations on members in the Accounts tagged dimension.

3. What are optimization techniques you used in Essbase?

For data loading:

• Grouping Sparse Member Combinations

• Positioning Data in the Same Order As the Outline

• Loading from the Essbase OLAP Server

• Making the Data Source As Small As Possible

• Making Source Fields As Small As Possible

• Managing Parallel Data Load Processing

For Calculation:

• Using Parallel Calculation

• Using Formulas

• Managing Caches to Improve Performance

• Using Two-Pass Calculation

• Aggregating #MISSING Values

• Removing #MISSSING Blocks

IX. Security and Administration

1. What information contains in ESSBASE.SEC file? Where is Essbase.sec file stored?

All information about users, groups, passwords, privileges, filters, applications, databases, and their corresponding directories is stored in the ESSBASE.SEC file

Location:

$ARBORPATH\Bin directory.

X. Partitioning.

1. What is partitioning? What are uses of partitioning? How many types of partition available in Essbase?

A partition is the piece of a database that is shared with another database.

Essbase Partitioning is a collection of features that makes it easy to design and administer databases that span Hyperion Essbase applications or servers.

Uses:

Synchronize the data in multiple partitioned databases. Essbase tracks changes made to data values in a partition and provides tools for updating the data values in related partitions.

● Synchronize the outlines of multiple partitioned databases. Essbase tracks changes made to the outlines of partitioned databases and provides tools for updating related outlines.

Types:

A replicated partition is a copy of a portion of the data source that is stored in the data target.

A transparent partition allows users to access data from the data source as though it were stored in the data target. The data is, however, stored at the data source, which can be in another application, in another Essbase database, or on another OLAP Server

A linked partition sends users from a cell in one database to a cell in another database. This gives users a different perspective on the data.

XI. Essbase Log files

How many types of log files are in Essbase?

XII. Backup/Recovery

You should regularly back up the server, application, and database files.

It is important to back up all .ind and .pag files related to a database because a single database can have multiple .ind and .pag files.

Note: Remember, the Agent should be shut down before the essbase.sec file is backed up.

XIII. Others

You can verify an outline automatically when you save it or you can verify the outline manually at any time. When verifying an outline, Analytic Services checks the following items:

●All member and alias names are valid. Members and aliases cannot have the same name as other members, aliases, generations, or levels.

●Only one dimension is tagged as accounts, time, currency type, or country.

●Shared members are valid

●Level 0 members are not tagged as label only.

●Label-only members have not been assigned formulas.

●The currency category and currency name are valid for the currency outline.

●Dynamic Calc members in sparse dimensions do not have more than 100 children.

●If a parent member has one child and if that child is a Dynamic Calc member, the parent member must also be Dynamic Calc.

●If a parent member has one child and if that child is a Dynamic Calc, Two-Pass member, the parent member must also be Dynamic Calc, Two-Pass.

●The two names of members of Boolean attribute dimensions are the same as the two Boolean attribute dimension member names defined for the outline.

●The level 0 member name of a date attribute dimension must match the date format name setting (mm-dd-yyyy or dd-mm-yyyy). If the dimension has no members, because the dimension name is the level 0 member, the dimension name must match the setting.

●The level 0 member name of a numeric attribute dimension is a numeric value. If the dimension has no members, because the dimension name is the level 0 member, the dimension name must be a numeric value.

●Attribute dimensions are located at the end of the outline, following all standard dimensions.

●Level 0 Dynamic Calc members of standard dimensions have a formula.

●Formulas for members are valid.

●In a Hybrid Analysis outline, only the level 0 members of a dimension can be Hybrid Analysis-enabled.

During outline verify, Analytic Services also performs the following conversions to appropriate numeric attribute dimension member names and displays them in the outline:

●It moves minus signs in member names from the front to the end of the name; for example, -1 becomes 1-.

●It strips out leading or trailing zeroes in member names; for example, 1.0 becomes 1, and 00.1 becomes 0.1.

Understanding the Essbase Kernel

The Essbase Kernel provides the foundation for a variety of functions of the Essbase server. These

functions include data loading, calculations, spreadsheet lock&send, partitioning, and restructuring.

The Essbase Kernel reads, caches, and writes data; manages transactions; and enforces transaction semantics to ensure data consistency and data integrity.

The Essbase Kernel has the following functions:

• Handles disk storage and caching of Essbase files

• Handles data retrieval

• Handles data updates

• Controls input-output functions related to Essbase

• Consolidates free space for re-use

• Manages concurrent operations

• Recovers databases after a server crash

• Issues locks

• Manages transactions

Essbase Kernel Components

The Essbase Kernel contains components that control all aspects of retrieving and storing data:

The Index Manager finds and tracks the location of requested data.

The Allocation Manager is part of the Index Manager, allocates space and manages some file operations.

The Data Block Manager retrieves the data pointed to by the index and stores the data.

The LRO Manager handles retrieval and storage of linked reporting objects (LROs).

The Lock Manager handles the locking of data blocks to regulate concurrent data access.

The Transaction Manager tracks transactions and handles internal commit and abort operations.

Essbase.cfg usage

You can define storage settings for all databases on the Hyperion Essbase server by changing values in the configuration file essbase.cfg.

——————========================Hyperion Essbase Questions Set One

1. can you tell me something about yourself and explain me about your project?

2. What is your role in ur current project?

3. What are the issues that you have faced while designing the cube and how did you resolve it?

4. What are different types of build methods?

5. How do you handle null values in essbase?

6. what is the maxl script to aggregate the values in ASO?

7. How are the values Aggregated in ASO? Is there any command that you run to aggregate the values in ASO?

8. What are different types of hierachies in ASO?

9. Say for example that i am building the dimensions and some members which are at gen4 are at gen3 how do build the dimension?

10. What will be there in .CFG file in essbase?

11. Tell me the end to end procedure how do you schedule the batch?

12. what do you understand by configuratation utility while installing the essbase system 9?

13. How do you capture errors while building the dimensions?

14. Tell about alternative hierachy?

15. HAve you ever worked on calculations Scripts?

16. Tell me steps to do migratation?

17. Difference between ASO & BSO?

18. What are the different types of LOG Files ?

19. What is the Extension of Cal Scripts and Rule File?

20. What is an Attribute dimension?

21. What are filters & Why are filters used?

22. what is dense dimension and sparse dimension?

23. What are different types of attribute dimension?

24. what is substitution Variables & Where do you use them?

25. What the storge type of essbase?

26. What are different types of built methods?

27. Tell me what do you understand by Two-pass Calculation?

28. What is the differene between Calc Dim and Calc All?

29. Tell me about TB First and TB Last?

30. How do you calculate the size of the DataBlock?

31. What is the differene between calc All and AGG?

32. What is the difference between Dynamic Calc and Dynamic Calc and Store?

33. How do you do the Data Load Optimization?

34. Different types of Data Load?

35. What is the difference between Fix and IF?

36. What is Intelligent Calculation?

37. what is Dirty Block and Clean Block?

38. If i delete a member from the dense dimension will that block be a clean block or dirty block?

39. What are the different types of Restructuring?

40. What will @ISMEM function will do?

41. What is the difference between Standard dimension and Attribute Dimension?

42. Difference between UDA and Attribute Dimension?

43. Tell me what do you understand by @XREF Function?

44. What is Data Cache?

45. What is the difference between Data Cache and Data File Cache?

46. What are the things that you take the backup?

47. How do you create users in Shared Services?

48. How and where do you configure LDAP?

49. Tell me about SSO?

50. How do you handle duplicate records while loading data into the essbase?

51. Can we give Formulas to Shared Members?

52. Can we give formulas to attribute dimension?

53. How do you optimize the Calclation?

54. What is the difference between ESSCMD and MAXL?

55. What is the difference between 7.x and System 9?

56. What is the the use of navigatation without data in Excel- add-ins?

57. What is cascade option in Excel-addins?

58. Can i give the same alias name to the different member?

59. What is TB First and TB Last?

60. What is the differene between FIX and IF Command?

61. What is MDALLOCATE Function do?

62. What @XREF Function do?

63. What is the difference between Data file cache and Data cache?

64. What will uncommit access do?

65. How does essbase consolidates the data?

66. Can you give the same name to different members in UDA?

67. What are different types of dimension building?

68. What do know about partition?

69. What are different types of partition? Have you ever worked on Partition?

70. what is the Maxl Command to rename the application or database?

71. What is the MAXL Command to bring the application into read only mode?

72. What are the steps to schedule the batch in Financial Reporting?

73. I have got 10 reports in my financial reporing and i want to send all those reports in one pdf how to you do that?

74. What is the difference between MOLAP and ROLAP?

75. What is fact table in your outline?

76. Can i have more then one fact table in my outline?

77. What is the calculation order of essbase?

78. How do you decide whether the file which you have received is in generation reference or level referene or parent & Child reference?

79. IS there any situation that i get more number of text files then the number of dimensions in my outline to build the dimensions?

80. Can i build the dimension and also the shared member with one text file if yes what is the procedure ?

81. Can i build the dimension and the data load with the same rule file if yes what is the procedure?

82. Can i set my cahces using MAXL Command if yes how do you do it?

83. Can i assign storage properties in my rule file if yes how should i do it?

84. If your end user complaint in report where should u check for finding error values? and what is the procedure that you follow to close it? Do you interact with user directly? if yes what is the mode of your interaction?

85. What are the different compression techniques?

86. How many dimensions a there in your project and what are they?

87. How many members are there in your time and account dimension & What is the hierachy of your time dimension?

88. What is rule file?

89. How many flat files for data loading you used in your project?

90. How many rule files you have used for data loading?

91. Tell me errors that you get while data loading and dimension building?

92. Where do you capture data laod errors and dimension build errors?

93. How much time it will take to load data in your project?

94. What is the size of your data file?

95. What is lock and send in your excel-addins

96. While loading the data if server hangs up what will happen?

97. When does restructuring happen?

98. What is your application size? and where do you check it?

99. How is data stored in ASO a and where is it saved?

100. If the data corrupts what will you do?

101. How do you remove defragmentation?

102. Is your current project and ASO or BSO and who will decide it and at which stage of SLDC?

103. What is your team size?

104. What are the differnent optimization techniques that you have followed to imporve the performance of the Essbase and how much percentage it has improved?

105. Can you tell me the number of users in your project?

106. How do you know if everything what you have done in your project is meeting the client needs?

107. Do you interact with client?

108. What type of testing is done in your project?

109. What is your project duration? How much time is spent for Dimension building and data loading?

110. Can you name some of your calculation scripts in your project?

111. How much time it will take when your run your calculation script?

112. Do you know what your calculation script does?

113. When and how do you take the back up of the cube?

114. What are the frequently used MAXL scripts in your project?

115. What will you do when you are not able to solve when problem occurs in your project?

Hyperion Essbase Questions Set Two

1) Difference between ASO & BSO?

2) What is Incremental Dimensional Built and one time Dimension Built?

3) What are the different types of LOG Files?

4) What is the Extension of Cal Scripts and Rule File?

5) Why are Filters used?

6) What are dense and sparse dimensions?

7) What are Filters?

8) What are Attributes?

9) Different Types of Attributes?

10) What is Substitution Variable?

11) How is Data Stored in Essbase?

12) What is an hour glass modle?

13) Types of Build Methods?

14) What is Two Pass Calculation?

15) What is TB First and TB Last?

16) How do you calculate the Size of the datablock?

17) How many data blocks are there in your cube?

18) What is meant by Descendents and can you give me the best example to describe it?

19) How do you do the Data Load?

20) Where is IS Member Command used?

21) What is the difference between FIX and If Command?

22) What is intelligent Calcuation?

23) What is meant by Clean block and Dirty block?

24) Commands of Intelligent calcuation?

25) How do you calculate the subset of a cube?

26) Difference between standard dimension and attribute dimension?

27) Difference between UDA and Attribute Dimension?

28) What is meant by XREF Function?

29) Can you give the same name to different members in UDA?

30) What is Data Cahce ?

31) What is the Difference between the Data Cache and Data File Cache?

32) What is the Size of your cube?

33) What is Shared members? Can shared members can have children below it ?

34) What are the different storage properties in Essbase?

35) What is the difference between Dynamic calc and Dynamic Calc and Store?

36) How does Essbase consolidates the Data?

37) Different types of Dimension Building?

38) What is Label only? Give the the example of it?

39) Difference between calc all and Calc Dim?

40) Explain me about your project? And tell me any difficulities that you have faced and how did you resolve it?

41) What is Commit Block?

42) Tell me different steps so that your can optimze the performance your cube?

43) What is Partition?

44) What are different types of Partition? Have you ever worked on partation?

45) What is MAXL ? and where is it used?

46) What is Alias?

47) How many Alias Tables can be created?

48) How is Data Retrived from Essbase?

49) How is Data Stored in ASO?

50) Different types of Attributes in ASO?

51) Tell me about your project and what is your role in your project?

52) Did you write any MDX Member formulas in your Project?

53) What are different Types of Data Blocks?

54) Where do you check the data has been loaded properly or not?

55) What is Fact Table ? What are supporting Dimensions?

56) What is your Fact Table in Cube?

57) How do you create shared members in your cube?

58) Why do you use Fix Command?

59) Can you use the same logic which are used in calculation scripts in MDX formulas?

60) You have 5 dimensions in your cube and to load the data in the cube you have got only 4 columns what do you do?

61) Why do you use set update cal on and set update calc off?

62) What is mean by free form data load?

63) When do delete one member from the outline what will be status of the block?

64) What are different Types of blocks?

65) What is the difference between Attributes and UDA?

66) What is meant by location Alias?

Hyperion Essbase Questions Set Three

Can we have multiple metaoutlines based on one OLAP model in Integration services?

Ans: Yes

What are LRO's( Linked Reporting Objects)?

Ans: They are specific objects like files, cell notes or URL's associated with specific data cells of Essbase database. You can link multiple objects to a single data cell. These linked objects are stored in the server. These LRO's can be exported or imported with the database for backup and migration activities.

What are the three primary build methods for building dimensions?

Ans:

1. Generation references

2. Level references

3. Parent-Child references

How does UDA's impact database size?

Ans: There will be no impact on the database as the UDA’s doesn’t store data in the database.

Can we have an metaoutline based on two different OLAp models.

Ans: No.

646

Can we create UDA’s and apply it to Dense as well as Sparse dimensions?

Ans: Yes

Types of Partitions available in Essbase?

Ans: Three types of partitions are there.

2. Replicated Partition:

3. Linked Partition:

What is hybrid analysis?

Ans: Lower level members and associated data remains in relational database where as upper level members and associated data resides in Essbase database.

Why top-down calculation less efficient than a bottom-up calculation?Being less efficient, why do we use them.

Ans: In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.

On what basis you will decide to invoke a serial or parellel calculation method.

Ans: If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.

How can you display UDA’s in reports?

Ans: UDA's values are never displayed in the reports and hence do not impact report performance.

While loading the data, you have applied both the selection criteria as well as rejection criteria to a same record. What will be the outcome?

Ans: The record will be rejected.

What are the specified roles other than Aministrator to view sessions, disconnect sessions or kill users requests for a particular application?

Ans: You should have the role of Application manager for the specified application.

What is block locking system?

Ans: Analytic services(or Essbase Services) locks the block and all other blocks which contain the childs of that block while calculating this block is block locking system.

What are the three options specified in Username and Password management under security tab in Essbase server proprties.

Ans: 1. Login attempts allowed before username is disabled.

2. Number of inactive days before username is diabled.

3. Number of days before user must change password.

Can we have multiple databases in one single application?

Ans: Yes. But only one database per application is recommended.

How is data stored in the Essbase database?

Ans: Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.

We have created an application as unicode mode. Can we change it later to non-unicode mode.

Ans: No

What are the types of partitioning options available in Essbase?

Ans: 1. Replicated partition. 2. Transparent partition 3. Linked partition.

Dynamic calc decreases the retreival time and increases batch database calculation time. How true is the statement?

Ans: The statement should be just opposite. As dynamic calc members are calculated when requested, the retreival time should increase.

What is the role of provider services.

Ans: To communicate between Essbase and Microsoft office tools.

A customer wants to run two instances of an Essbase server on a same machine to have both test environment and Development environment on the same server. Can he do that?

Ans: Yes. We can have multiple instances of an Essbase server on a single machine and there will be different sets of windows services for all these instances.

Why top-down calculation less efficient than a bottom-up calculation?Being less efficient, why do we use them.

Ans: In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.

Hyperion Essbase Questions Set Four

Hyperion Essbase Interview Questions

1. What is Hyperion Essbase?

A multidimensional database supports multiple views of data sets for users who need to analyze the relationships between data categories.

2. What is Hyperion Essbase architecture?

Hyperion Essbase 7.1.2 follows 3-tier architecture.

 Database tier – Hyperion Essbase server (Analytic Server)

One or more analytic servers store and process multidimensional database information.

 Middle tier – EAS Server EAS: Essbase Administration Services

This server maintains communication, session and security info for analytic servers.

 Client tier – EAS Console

Console provides a user interface to manage the analytic services environment.

EAS server, Essbase Server and EAS Console can be on a single machine or they can be on separate machine. EAS server/Essbase can be installed on windows/Unix platform.

Note: Console is a tool where end user/ client will work, where as server is tool where data will be stored.

3. What are dimension, parent, child, level, generation and sibling?

 Dimension is the highest level of consolidation in an outline.

 A parent is member that has a branch below it. For example profit is a parent member for sales and cost of products sold.

 A child is member that has a parent above it. For example sales and cost of products sold are children of the parent profit.

 Level refers to a branch within a dimension. The member that doesn’t have any children is at level ‘0’. Also called leaf members. The parent of level ‘0’ member will be at level ‘1’. Levels will increase from bottom to top where as generations will increase from top to bottom.

 Generation refers to a consolidation level within a dimension. When a database is created an empty outline gets created, outline will be at generation ‘0’. All the dimensions will be at generation ‘1’ and members created under dimensions will be G2, the members created under G2 will be at G3 and so on.

 Siblings are child members of the same intermediate parent, at the same generation. For example sales and cost of products sold are siblings (they both have the parent profit).

4. What is outline?

 Outline defines the structural relationships between members in an analytic services database.

 It defines consolidation and mathematical relationships between members.

 Organizes all the data in the database.

 Outline files are stored under ARBORPATH\ APP\ app_name\ DB_name\ with a file extension of “.otl”. To see the arbor path click on the properties under Essbase server. Example: ARBORPATH= C:\Hyperion\Essbase

5. What is rules file?

Rules files are used to build dimensions and to load data. Rules files are saved with “.rul” in the path, ARBORPATH \ APP \ app_name \ DB_name \

6. How to build dimensions using rules file?

STEP 1.Make sure the source file is ready. (The source file could be text file\ excel file\ csv file etc.). The default delimiter is “TAB”.

STEP 2.Right click on the rules file,  “create rules file”, and this will opens the data prep Editor.

STEP 3.Go to file menu and  “open data file”, select the source file from file system tab.

STEP 4.Select dimension build field button and select field properties button, select dimension build properties tab.

STEP 5.Make sure you are in field no 1.

STEP 6.Double click on dimension which you add to outline and double click on generations under filed type and enter number in number files: 2 and  next.

STEP 7.You are in field number 2. Repeat the above process until all the fields are mapped. Finally  OK.

STEP 8.Validates and save the rule file on analytic server.

STEP 9.Double click on the outline, go to outline menu and  update outline. Find data file from file system and select the source file OK.  Find rules file and select the rules file  OK. Select the overwrite check box and OK.

STEP 10.Save the outline.

7. How to handle headers in source file?

The source file may contain header records. In that case we need to skip the header records.

Open data prep editor (Right click on the rules file, click on “create rules file”), go to options menu and  data source properties and  header tab, and enter a number in “Number of lines to skip: 1”  OK.

8. How to handle delimiter in the source file?

Delimiter is one which separates the columns/fields in database file/source file/data file. Open data prep editor (Right click on the rules file, click on “create rules file”), go to options menu and  data source properties and  Delimiter tab, Select the required delimiter and  OK. Note: Default delimiter is “TAB”. In SQL, the default delimiter is “TAB”.

9. What are all the different methods to load data?

Data can be loaded using

I. Rules file

II. Through lock and send from excel file / right back option in analyzer

III. Free form loading (without rules files)

10. How to load data using rules file?

STEP 1.Open the data prep editor. Make sure data load fields button selected.

STEP 2.File  open data file  select source file

STEP 3. Filed properties,  Data load properties tab. Make sure you are in field number 1.

STEP 4. Double click on dimension and click next repeat the process until all the dimensions are selected. At the final you have to select data field check box. ( No need to select any dimension)  OK.

STEP 5.Validate and save rules files.

STEP 6.Right click on the database name (Ex: sales)  load data; make sure the type is “data file”.  Find data file, select source file,  find rules file, select the rules file and  overwrite check box  OK.

STEP 7. Right click on the database name (Ex: sales)  execute calculations.

STEP 8.Right click on the database name (Ex: sales)  Preview data.

Note:

I. Always try to load data for level ‘0’ members’ combination.

II. At least one member should present from each dimension.

11. What are the different steps in database design process?

The database design process includes the following basic steps

1. Analyze business needs and design a plan:

2. Draft a database outline.

3. Check system requirements.

4. Load test data into the database.

5. Define calculations.

6. Define reports.

7. Verify with users.

8. Repeat the process.

12. How to handle duplicate records?

 Open Data Prep Editor  Options (from menu bar)  data load settings  data load values (tab) under data values Select

o Overwrite existing value (to overwrite duplicate records)

o Add to existing values (to add the duplicate records)

13. How to solve the records unique problem?

Take an example of time dimension

Field1 Field2 Field3

2007 Qtr1 Jan

2007 Qtr1 Feb

2007 Qtr1 Mar

2006 Qtr1 Jan

2006 Qtr1 Feb

2006 Qtr1 Mar

Above data is your source file data.txt,

 Open data prep editor  file Open data file, go to  field(menu)  Move Filed1 to last position go to fields  Create using join select Field2 & field1 OK it will create one column with Qtr12007 Repeat the above process up to your requirement. Finally in the first field You want to add some prefix like Year 2007 or Year 2006 go to filed properties  Global properties  prefix Year  OK.

14. What are all the different build methods?

Select the build method to use for the selected dimension:

 Use generation references: Builds dimensions from top-down data sources. Generations are numbered hierarchically from the top down, with the dimension as generation 1 and its immediate children as generation 2, and so on.

 Use level references: Builds dimensions from bottom-up data sources. Levels are numbered hierarchically from the bottom up, with the lowest level at level 0.

 Use parent/child references: Builds the dimension using parent/child references. Parent/child references refer to the parent/child relationship among members in an outline.

 Add as sibling of member with matching string: Builds the dimension by matching new members to similar members in the outline.

 Add as sibling of lowest level: Builds dimensions by adding new members to the lowest level in the outline.

 Add as child of: Builds dimensions by adding each new member as a child of the dimension specified in the text box or selected from the dimension node. Expand this node to specify or select the dimension.

 Process null values: Select to perform certain processing if a null value is encountered in the data source. Analytic Services promotes primary fields (such as member names) that occur after a null field and ignores secondary fields (such as member properties and aliases) that occur after a null field. This option is only available when you use the generation references or level references build methods.

15. What are Consolidation operators?

Operator Description

+ Adds the member to the result of previous calculations performed on other members. + is the default operator.

- Multiplies the member by -1 and then adds it to the sum of previous calculations performed on other members.

* Multiplies the member by the result of previous calculations performed on other members.

/ Divides the member into the result of previous calculations performed on other members.

% Divides the member into the sum of previous calculations performed on other members. The result is multiplied by 100 to yield a percentage value.

~ Does not use the member in the consolidation to its parent.

Sample Roll up Example:

Parent1

Member1 (+) 10

Member2 (+) 20

Member3 (-) 25

Member4 (*) 40

Member5 (%) 50

Member6 (/) 60

Member7 (~) 70

Sample Roll Up for Members 1 through 4

(((Member1 + Member2) + (-1) Member3) * Member4) = X

(((10 + 20) + (-25)) * 40) = 200

Sample Roll Up for Member 5

(X/Member5) * 100 = Y

(200/50) * 100 = 400

Sample Roll Up for Member 6

Y/Member6 = Z

400/60 = 66.67

Because it is set to No Consolidation (~), Analytic Services ignores Member7 in the consolidation.

16. What is the use of ‘~’ (tilt) operator?

When a member has ‘~’ operator, it is not rolled upto parent.

Year

Qtr1

Jan (+) Qtr1=Jan + Feb

Feb (+)

Mar (~)

17. When you save the application in analytics server what are all the backup files will create?

Let us take an application Product, 2 files created.

1. Prodcut.app (Application file, defining the name and location of the application and other application settings)

2. Product.txt (Text file, such as a data file to load or a text document to link as a linked reporting object).

If you create the data base file Product, 4 files created.

1. Product.dbb (Backup of database file)

2. Product.esm (Analytic Services database transaction control file that manages all commits of data and follows and maintains all transactions)

3. Product.tct (Analytic Services database transaction control file that manages all commits of data and follows and maintains all transactions)

4. Prodcut.otl (Outline)

Along with folder “Trig”

If you save the dimension it creates .ind file (Analytic Services index file)

If you save the data, it creates the .pag file (Analytic Services database data (page) file). The default size of page file is 2GB. The minimum size is 8192Kb (8Mb). In projects let us say your page file size is 12GB.

18. What is the use of LOCKING and UNLOCKING of outline?

An outline is always locked when it is opened in edit mode. Analytic Services unlocks the outline when the Close button is used to close the outline. In some circumstances, an outline may get closed without getting unlocked; for example, when a user has an outline open and is disconnected from the server because of a timeout. When an outline is locked to other users, Analytic Services does not allow them to save over, rename, delete, edit, or optimize the outline. When you attempt to edit a locked outline, you are given an option to view the outline in Outline Viewer. If you have Supervisor permissions, you can unlock a locked outline. Before you forcefully unlock a locked outline, make sure that no one else is working with it.

19. What are the different storage properties?

When a member is created, the default storage type is “STORE”. Available storage types are

1. Store member

Stored members contain calculated values that are stored with the member in the database after calculation. By default, members are set as stored.

2. Dynamic Calc member

When a member is dynamic calc, analytic services does not calculate the value until user requests it. Also the value will not be stored. Dynamic calc can be tagged on parent members. Dynamic calc can be tagged on level ‘0’ members provided a formula is attached to level ‘0’ members. Using dynamic calc we can save space and also we can save calc time. But the retrieval time will be the more.

3. Dynamic Calc and Store member

When we tag member as dynamic calc and store, Essbase will not calculate the data value until user requests it. When the member is retrieval for first time, Essbase calc the member and then store the data value. For subsequent retrieval, the property will be same as store data.

4. Implied sharing

Analytic services, assumes implied shared member relationship with child values,

• When a parent has only one child

• A parent has more than one child, but only one child is consolidating to the parent, remaining children has ‘~’ operator.

In the above two cases, Essbase need not calc the parent value. It simply refers the child values. There is no storage space reserved for the parent.

Examples of implied sharing:

Year 2007

 Qtr1

 Jan 2007 (+)

 Feb 2007 (~)

 Mar 2007 (~) Year 2007

 Qtr1

 APR 2007 (+)

5. Never share member

Never share will not allow members to implicitly shared. Tag the parent member as never share to avoid implicit sharing.

6. Label only member

Label only members have no data associated with them. Use them to group members or to ease navigate and reporting from any reporting tool (spread sheets, etc.).

Note: For measure dimension most of the applications make it as label only.

7. Shared member

Shared members help us to create alternate hierarchies, in the above example using same children members, we can get different roll ups.

Products

 Soda(+)

 Coke(+)

 Coke Diet(+)

 Coke Reg(+)

 Pepsi(+)

 Pepsi Diet(+)

 Pepsi Reg(+)

 Diet(~)

 Coke Diet (Shared members) (+)

 Pepsi Diet(Shared members) (+)

 Reg(~)

 Coke Reg (Shared members) (+)

 Pepsi Reg (Shared members) (+)

Coke= coke diet + coke Reg

Pepsi= Pepsi diet + Pepsi Reg

Diet= coke diet + Pepsi Diet

Reg= Coke Reg + Pepsi Reg.

The data values associated with the shared member comes from another member with same name.

 Shared member should exit in the same dimension as their base member.

 Shared member must come after the base member in the outline.

 Shared members cannot have the children.

 We can have unlimited number of shared members.

 We cannot assign attributes with shared members.

 We cannot assign UDA’s or formulas to shared members.

 We can give alias to a shared member.

20. How to set member properties using data source file?

Let us create a source file like this

Parent Property Child

Soda Coke

Soda Pepsi

Coke Coke Diet

Coke Coke Reg

Pepsi Pepsi-Diet

Pepsi Pepsi-Reg

Diet ~ Coke-Diet

Pepsi ~ Pepsi-Reg

Diet ~ Pepsi-Diet

Pepsi ~ Coke-Reg

Load the source file into data prep editor.  Dimension build fields  Fields properties

 Dimension build properties (tab)

 Products (dimension)  parent (field type)  next

 Products (dimension)  Properties (field type)  next

 Products (dimension)  Child (field type)  OK

Remaining procedure is same as above. The output has shown in question no 20.

21. What is duplicate generation field type?

The name of a member that has duplicate parents; that is, a member that is shared by more than one parent. Put DUPGEN fields immediately after GEN fields. For example let us take a source file like this.

Gen2 Gen3 DUPGEN3 Gen4

Soda Coke Diet Coke Diet

Soda Coke Reg Coke Reg

Soda Pepsi Diet Pepsi Diet

Soda Pepsi Reg Pepsi Reg

The output will be something like this

 Products

 Soda (+)

 Coke (+)

 Coke-diet (+)

 Coke-Reg (+)

 Diet (~)

 Coke-diet (+) (Shared Member)

 Pepsi-diet (+) (Shared Member)

 Reg (~)

 Coke-Reg (+) (Shared Member)

 Pepsi-Reg (+) (Shared Member)

 Pepsi (+)

 Pepsi-diet (+)

 Pepsi-Reg (+)

Observation: the DUPGEN 3 members will be created along with ‘~’ operator instead of ‘+’ operator.

22. What is alias and alias table? What are all the different ways to create aliases?

Alias is an attribute name for a member. Any member in the outline can have alias. We can have more than one alias for a member. Alias information is stored in alias table. When you create a database, an empty alias table called default will get created.

If we want more than one alias for a member, we need to create a new alias table. The name of the alias table can be a max of 30 characters. An alias name can be a max of 80 characters. A member can have 10 aliases. That means we can create 9 more tables only. We can export the alias table information and at later point of time we can import the alias table.

Creating alias

Right click on the member  Edit member properties

Aliases  Aliases name.

Creating alias table using rules file:

Gen 2 Gen 3 Gen 4 Alias Prop

India SI AP Telugu

India SI TN Tamil

Open the data prep editor

 Map all the generation columns, and for the alias column, select dimension under field type. Select alias, the generation number will be the same as the previous column.

 Options (menu)

 Dimension build settings

 Dimension build settings (Tab)

Select the dimension

 Allow property changes

Validate and save the rules file.

Creating alias table:

In the outline editor:

 Properties (tab)

 Right click on the alias table name

 Create table name

 Right click on the alias table

 Set as active (It makes the alias table active)

23. What is the alias table format?

$ALT_NAME 'EMPLOYEE'/*Alias Table name*/

"E001" "Suresh"

"E002" "Pro_X"

$END /* End of table*/ Outline( Alias Table Employee)

 Employee

 E001 (Alias Suresh)

 E002 (Alias Pro_X)

24. What are the different types of dimensions?

Essbase has two types of dimensions.

1. Standard dimension

2. Attribute dimension

 Standard dimension: It again two types.

1. Dense dimension

2. Sparse dimension

Most multi dimensional databases are inherently sparse, that is they lack data values for majority of member combinations. A sparse dimension is a dimension with low percentage of available data. A dense dimension is a dimension with high probability that one or more points is occupied for the combination.

Data blocks and index system:

Analytic services uses 2 types of internal structures to store and access data. Those are data blocks and index system.

Data blocks:

An analytic service creates a data block for each unique combination of sparse members provided at least one data value exists for sparse member combination. Analytic service creates an index entry for each block.

No of indexes = No of Blocks.

= Multiply the no of members from one sparse dimension with the member from other sparse dimension and so on.

Block Size:

The data block represents all the dense dimension members for its combination of sparse dimension members. A block contains several cells.

No of cells =multiply the members from one dense dimension with the members from other dense dimension and so on.

Idle block size is between 8K and 100k. Each cell occupies 8 bytes.

Take an example:

Let us consider D: Dense dimension, S: Sparse dimension.

D1=10, D2=25, S1=10, S2=20, S3=10;

Potential no of indexes = S1 * S2 * S3

= 10 * 20 * 10 = 2000

No of cells = D1 * D2

= 10 * 25 = 250

Block size= No of cells * 8

= 250 * 8 = 2000 = 2K

Note: It is applicable only for storage type “Store”.

Example 2:

D1= 25, D2: Measure, D3= 10, S1=20, S2=100, S3=50;

Measure (Label only)

 Gross Sales(+)

 Net sales (+)

 Return sales(+)

 Gross Transactions (Dynamic Calc)

 Net Transaction (+)

 Return transaction (+)

 Quantity (~)

 Opening inventory(+)

Potential no of indexes = S1 * S2 * S3

= 20 * 100 * 50 = 1, 00,000

No of cells = D1 * D2 * D3

= 25 * 6 * 10 = 1500

In D2 (dense dimension) we count all the level ‘0’ members (5), Then we will count the parents, here we are having 3 parents, on that one parent (Gross transactions) is dynamic calc (It will calc the data at execution only, it will not store the data so we cannot count this member) another parent (Quantity) is having ~ operator so it is nothing but implied sharing. We are not count this parent also. The measure dimension that is also Label only data storage type, so this also not counted. Left is only one parent (Gross sales) we can count this parent. Total no of dense members are 6.

 Attribute Dimension:

Attribute describe characteristics of some other dimensions.

1. Attribute dimensions are always at the end of the outline.

2. Attribute dimensions are sparse in nature.

3. Attribute dimensions are dynamic calc data storage type.

4. We can tag attribute dimension only to sparse dimension.

5. A base dimension can have many no of attribute dimensions.

6. An attribute dimension must be associated with only one base dimension.

7. Only level “0” members of attribute dimension can be associated with level ‘0’ members of base dimension.

8. We cannot associate multiple members from the same attribute dimension with the same base member. Example: Coke-1 cannot have 1lit and 2lit at the same time.

9. There are 4 different attribute type available, ‘text’, ‘numeric’, ‘Boolean’, and ‘date’.

10. There are 5 types of calculations available, ‘sum’, ‘min’, ‘max’, ‘count’, and ‘avg’.

25. How to see/change the dimension is sparse or dense dimension?

You are in outline editor, go to properties (Tab), outline properties  data storage  Dimension storage types. If you want to change the dimension type you must change the data storage property Auto configure “False”.

26. Where you see the data block size and no of cells?

Double click on the data base properties, data base properties  go to statistics (Tab) there we will see the block size.

27. How to create attribute dimension using rules file?

1. Create a dimension at the end of the outline.

2. Tag the dimension as attribute.

3. Right click on standard sparse dimension and click edit member properties.

 Attribute(Tab)

 Select the attribute dimension

 Assign OK and save the outline.

Note: The above steps are manual.

4. Rules file

Emp Dept

E1 D1

E2 D1

E3 D2

Open data prep editor  open source file  dimension build properties  Field properties dimension build properties (Tab)  select the dimension  select the field type as generation  next. And again select the dimension and under field type select the attribute dimension. Generation will be same as previous column. Validate and save rules file.

28. What are the key futures of Essbase products?

Essbase products provide the analytic solution that integrates data from multiple sources and meets the needs of users across an enterprise.

1. Integration with existing infrastructure: Essbase products integrate with your existing business intelligence infrastructure.

2. Data Integration (Essbase integration services): It integrates data warehouses, legacy systems, OLTP, ERP systems, e-business systems, CRM applications, web log files, and other external data sources.

3. Ease of server and data base administration: Essbase products provide a cross-platform administration console. The console gives you detailed control over the Essbase environment:

• You can manage multiple servers and databases.

• You can use MaxL, a syntactical language command shell with a PERL extension module, to automate batch maintenance.

4. Mission critical applications in web based environment: A middle-tier framework extends the power of Essbase products by creating a Web-enabled, distributed platform for Essbase applications hence serving the analysis needs of large numbers of users in Web-based environments. Essbase Deployment Services provide connection pooling, clustering, and failover support, which extend the scalability and reliability of the platform and support mission-critical applications in a 24 x 7 environment.

5. Powerful querying

6. Calculations

7. Write back and security:

8. Easy development: Analytic Services offers many key advantages to help users develop effective multi-dimensional applications. Users can:

• Design and manage applications using a graphical interface to control most server functions.

• Quickly add dimensions, change calculations, and modify hierarchies to reflect new business developments. In addition, the dynamic dimension builder automatically defines and dynamically loads large amounts of data, including data from spreadsheets, flat files, and supported relational database tables directly into a database.

• Define key calculations without having to write a program

• Define security for individuals and groups and customize views and retrieval procedures for each user without writing a program.

29. What is User defined attributes (UDA’s)?

UDA’s can be associated with both sparse and dense dimensions also.

 Right lick on any member

 Edit member properties

 UDA’s (Tab)

 Enter a characteristic, for example small market

 Assign OK

1. UDA’s can be associated with any level member

2. Using UDA’s we cannot get the calculations automatically. For data analysis UDA’s are not as powerful as attributes.

Creating UDA’s using Rules file:

Source file:

India SI AP Small

India SI TN Medium

India NI UP Small

India NI Delhi Large

Everything is same, the difference is go to options Dimension build settings Dimension build settings (Tab) select the appropriate dimension, in existing members select allow property changes and allow UDA changes.  OK.

30. What is time dimension?

There are four types of inbuilt functions (dimension types) available in Essbase. Those are

1. Time

2. Accounts

3. Country

4. Currency

1. Time Dimension: we can assign any sparse or dense dimension as time. When dimension type is set as time, we get functions like dynamic time series. They are 8 inbuilt dynamic time series members are available.

H-T-D History – To – Date

Y-T-D Year – To – Date

S-T-D Season – To – Date

P-T-D Period – To – Date

Q-T-D Quarter – To – Date

M-T-D Month – To – Date

W-T-D Week – To – Date

D-T-D Day – To – Date

Note: if the lowest level is month M-T-D, W-T-D, D-T-D are not available. If the lowest level is daily, D-T-D is not available. To retrieve the dynamic time series members in report, we need to enter Y-T-D (level ‘0’ member’s name) Example: Y-T-D (jan 2007), Y-T-D (01/05/2007).

 Only one time dimension type can be there in an outline.

 It can work on only on base members, not on shared members/ attribute members etc.

31. How to add Essbase to your excel?

Open excel (if it is Excel 2003)

 Tools

 Add-ins (Browse)

 C:\Hyperion\Essbase\bin\ essexcln

 C:\Hyperion\Essbase\bin\ essxleqd

Open excel (If it is Excel 2007)

 Right click on any tool bar and select customize quick access toolbar, select Add-Ins

 Go

 Browse

 C:\Hyperion\Essbase\bin\ essexcln

 C:\Hyperion\Essbase\bin\ essxleqd

 OK

32. What is accounts dimension?

When we tag any dimension as accounts dimension, we will get additional functions such as time balance properties, two pass calculations etc. only one dimension can be tagged as accounts dimension. In order to have above features, a dimension tagged as time should also exist in the outline. We can tag accounts dimension to either sparse or dense dimension.

Time balance properties:

When a dimension is tagged as accounts, the members in the accounts dimension can be tagged with any of the following TB properties.

1. TB First

2. TB Last

3. TB Average

When a member is tagged as TB first consolidation of the parent in the time dimension will get effected.

Example: Qtr1 2007

 Jan 2007

 Feb 2007

 Mar 2007

Accounts

 Inventory(+)

 Opening Inventory(TB First)

 Ending Inventory(TB Last)

 Avg Inventory(TB Avg)

Now Qtr1 2007Inventory=Jan 2007+Feb 2007+ Mar 2007

Qtr1 2007Opening Inventory=Jan 2007

Qtr1 2007 Ending Inventory=Mar 2007

Qtr1 2007Avg Inventory = (Jan 2007+Feb 2007+Mar 2007)/3

Whatever be the value in Mar 2007 that value will be stored in Qtr2 2007. Sometimes there don’t be any data in Mar 2007 to get the current value of Qtr1 2007 Ending Inventory, there are skip missing & ‘0’ options are available.

Note: TB First & TB Last depends upon outline hierarchy.

What is partitioning?

A partition is the piece of a database that is shared with another database. An Essbase partitioned application can span multiple servers, processors, or computers.

What is Essbase Partitioning?

Essbase Partitioning is a collection of features that makes it easy to design and administer databases that span Essbase applications or servers. Partitioning is licensed separately from Essbase.

What are the types of Partitions available in Essbase?

Three types of partitions are there.

1. Transparent partition:

A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users

2. Replicated Partition:

A portion of a database, defined through Partition Manager, used to propagate an update to data mastered at one site to a copy of data stored at another site. Users can access the data as though it were part of their local database.

3. Linked Partition:

A shared partition that enables you to use a data cell to link two databases. When a user clicks a linked cell in a worksheet, Essbase opens a new sheet displaying the dimensions in the linked database. The user can then drill down those dimensions.

What is the process for designing a partitioned database?

Here is the suggested process for designing a partitioned database.

1. Learn about partitions.

2. Determine whether the database can benefit from partitioning.

3. Identify the data to partition.

4. Decide on the type of partition.

5. Understand the security issues related to partitions.

What are the parts of partition?

Partitions contain the following parts,

· Type of partition: A flag indicating whether the partition is replicated, transparent, or linke

· Data source information: The server, application, and database name of the data source.

· Data target information: The server, application, and database name of the data target.

· Login and password: The login and password information for the data source and the data target.

· Shared areas: A definition of one or more areas, or sub cubes, shared between the data source and the data target.

· Member mapping information: A description of how the members in the data source map to members in the data target.

· State of the partition: Information about whether the partition is up-to-date and when the partition was last updated.

What are benefits of partitioning?

Partitioning applications can provide the following benefits:

· Improved scalability, reliability, availability, and performance of databases

· Reduced database sizes

· More efficient use of resources

· Data synchronization across multiple databases.

· Outline synchronization across multiple databases.

· Ability for user navigation between databases with differing dimensionality.

Can you define different types of partitions between the same two databases?

Can a single database serve as the data source or data target for multiple partitions?

Yes

What is overlapping partition?

An overlapping partition occurs when similar data from two or more databases serve as the data source for a single data target in a partition.

Is overlapping partition valid in all the partitions?

An overlapping partition is allowed in linked partitions, but is invalid in replicated and transparent partitions and generates an error message during validation.

When do you use substitution variables in partitions?

Using substitution variables in partition definitions enables you to base the partition definition on different members at different times.

Can we use attribute values to partition a database?

Yes,You can use attribute functions for partitioning on attribute values. But you cannot partition an attribute dimension.

Can we partition an attribute dimension?

No, we cannot partition an attribute dimension.

What is the limitation on version and mode during partition?

Both ends of a transparent, replicated, or linked partition must be on the same release level of Essbase Server. For example, if the source of a linked partition is on a Release 7.1.2 server, the target must also be on a Release 7.1.2 server.

In addition, for transparent and replicated (but not linked) partitions, the application mode of both ends of the partitions must be the same--either Unicode mode or non-Unicode mode.

What are the major difference between ASO & BSO?

If we have more dimensions (generally more than 10) then we will go for ASO that simply rollup If we have less dimensions then we will go for BSO We cannot write back in ASO we can write back in BSO Most of the dimensions are sparse in ASO Most of the dimensions are dense in BSO

What is "Enterprise Analytics"? ASO in System 9 is called Enterprise Analytics.

Explain in detail about the features of ASO?

· ASO databases are created specifically to deal with the requirements of very large sparse data sets with a high no of dimensions and potentially millions of members. · ASO do not have indexes or data blocks. · ASO do not use calculation scripts. Bcoz calculations are not complex. · ASO uses a new kind of storage mechanism that allows improved calculation times from 10 to100 times faster than BSO. · ASO can store up to 252 dimensional combinations. · The front end tools usually do not care if the database is ASO or BSO. Even Maxl sees minor differences. · We can have attribute dimensions in ASO. · In ASO there is no concept as dense and sparse dimensions. · We do not have two pass logic and built in time balance functionality.( time balance functionality is present from 9.3 version onwards). · Member formulas are not supported in stored hierarchies. · Only non consolidation (~) and addition (+) operators are supported in shared hierarchies. · We cannot create more than 1 database in ASO. · ASO does not utilize procedural calculation scripts. · ASO formulas are written in MDX syntax. · ASO has Accounts dimension but it is completely different from the account dimension of BSO. · ASO is read-only. You cannot write to ASO databases, but there is a workaround using transparent partitions and pointing to an attached BSO database for those duties. · You can load data to level zero members only. · The database must restructure after any members in the standard dimensions are added ,deleted or moved. In fact most actions on an ASO outline will either cause a loss of data or restructure.

How do you differentiate ASO applications?

You can easily differentiate the ASO database in the Administrative Services Console by the red star beside the application name.

How do you create an ASO application? ASO has two types of hierarchies: stored and dynamic. The dimension can contain both types of hierarchies (if you enable multiple hierarchies).Other properties that need to be set for dimensions and members include · Dimension Type · Data Storage(store, never share, label only) · Member solve order

· Alias

You can add dimensions using the visual editor or the rules files.

Unlike in block storage ASO does not allow you to preview the outline changes. If you are unsure of the build file, make a backup of your outline before running the new build rule. For ASO databases after the data values are loaded into the level 0 cells of an outline, the database requires no separate calculation step. For retrieving from the ASO database, retrieve and analyze just as in BSO database.

How do you create an ASO database using ASO Outline Conversion Wizard ? You can also create an ASO database using ASO Outline Conversion Wizard. This wizard uses the existing BSO database to convert to an ASO database. This is advantageous because we do not need to create an ASO database from the Scratch. However we need perform reengineering of dimensions and hierarchies.

How do you create ASO in the Automated Way? The final way of creating an ASO application is by using "Create Application" , "Create Database" ,"Create Outline " commands using MaxL. Typically this method is used when you are running the MaxL command as a part of the batch job.

**Unicode is supported for BSO databases only.

**Data Mining is not supported by ASO databases.

**MDX is the only mechanism for defining member calculations in databases.

Unicode applications use UTF-8 encoding form to interpret and store character text, providing support for multiple character sets.

To set up a Unicode application

1. Setup a computer for Unicode support by doing one of

· Install the for that supports UTF-8 encoding

· Install a Unicode editor

2. Set the Essbase server to Unicode Mode via Administrative Services or MaxL.

3. Check the Unicode box when creating a new Unicode -mode application.

4. You can also migrate from non-Unicode applications to Unicode applications (but not the other way round).

Report Scripts are outdated but still can be helpful when extracting subsets of data from Essbase for online backups or feeding into other systems.

The Wizards Tab of Administrative Services Console menu has the following components

1. Migration

2. Aggregate Storage Outline Conversion

3. Aggregate Storage Partition

4. User Setup

5. Data Mining Wizard

1 comment:

AnonymousMarch 4, 2022 at 1:02 AM
Harrah's Resort Southern California opens poker room
Poker room 경상북도 출장샵 in Highland, CA. Harrah's Resort Southern 경상남도 출장샵 California opens poker room Wednesday and Thursday at Harrah's Resort Southern California.Oct 포커 고수 11, 2021 · Uploaded 동해 출장샵 by 김해 출장안마 Southern California at

HyperionGuru

Monday, November 9, 2015

Essbass interview collection

1 comment:

Popular Posts

Popular link