Explore topic-wise InterviewSolutions in .

No.

No.

After a DATABASE crash or server interruption, Essbase automatically RECOVERS a database after rolling back the TRANSACTIONS that were active at that time.

After a database crash or server interruption, Essbase automatically recovers a database after rolling back the transactions that were active at that time.

Classification of a member in a dimension is known as an attribute. We can do selection of GROUP members based on their associated attributes. We can also specify an attribute while performing calculations and along with we can use CALCULATION functions. As EXAMPLE, the db in Sample Basic with product dimension has some attributes like package type, size, and FLAVOR. We can add attributes to the dimensions and can RETRIEVE data. For example, to retrieve “coke with 8 Oz with bottles”.

Classification of a member in a dimension is known as an attribute. We can do selection of group members based on their associated attributes. We can also specify an attribute while performing calculations and along with we can use calculation functions. As example, the db in Sample Basic with product dimension has some attributes like package type, size, and flavor. We can add attributes to the dimensions and can retrieve data. For example, to retrieve “coke with 8 Oz with bottles”.

Yes. You can QUERY a MEMBER for its UDA in a CALCULATION script.

Yes. You can query a member for its UDA in a calculation script.

Dense: A DIMENSION which has the high probability that DATA exists for every combination of dimension MEMBERS.

SPARSE Dimension: A dimension which has low probability that data exists for every combination of dimension members.

Dense: A dimension which has the high probability that data exists for every combination of dimension members.

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

DENSE dimension is a dimension in which most DATA exists for EVERY COMBINATION of dimension members whereas sparse DIMENSIONS are the dimensions which has low probability that data will exist for every combination of dimension members.

Dense dimension is a dimension in which most data exists for every combination of dimension members whereas sparse dimensions are the dimensions which has low probability that data will exist for every combination of dimension members.

The ESSBASE SERVICES, also called ANALYTIC will make a lock to each of the BLOCKS that encapsulate the childs of the INITIAL block, this is what a block locking system means.

The Essbase Services, also called analytic will make a lock to each of the blocks that encapsulate the childs of the initial block, this is what a block locking system means.

YES, in this ONE DATABASE PER APPLICATION.

Yes, in this one database per application.

It STOPS MEMBER from BECOMING CONSOLIDATE on all DIMENSIONS.

It stops member from becoming consolidate on all dimensions.

UDA REPRESENTS the class of the members. Aliases are just other names of the members. Both are DIFFERENT and have different USAGE.

UDA represents the class of the members. Aliases are just other names of the members. Both are different and have different usage.

In reference to RPG, DOU means (Do Until).This will execute a loop MATCHED with an End or End do

For INSTANCE

Eval X=1

DOU X=4

Eval X=X=1

EndDo

This example will go through the loop 4 times with the result of X being 4.

“DOU” is similar to Do While(“DOW”) where the DIFFERENCE LIES in that the DOU will always perform 1 pass through the loop and DOW will perform the comparison and only continue into the loop if the CONDITION meets else the program continues after the

End (EndDo).

For example

Eval X=1

DOW X=4

X=X+1

Enddo

The result is that the loop will not execute and the value of X will be 1.

In reference to RPG, DOU means (Do Until).This will execute a loop matched with an End or End do

For instance

Eval X=1

DOU X=4

Eval X=X=1

EndDo

This example will go through the loop 4 times with the result of X being 4.

“DOU” is similar to Do While(“DOW”) where the difference lies in that the DOU will always perform 1 pass through the loop and DOW will perform the comparison and only continue into the loop if the condition meets else the program continues after the

End (EndDo).

For example

Eval X=1

DOW X=4

X=X+1

Enddo

The result is that the loop will not execute and the value of X will be 1.

RULE FILE is .rulCalc SCRIPT is – .cscBatch FILES – .batoutline – .OTL

Rule file is .rulCalc Script is – .cscBatch files – .batoutline – .otl