Tag: technology

It is possible to edit SQL

It is not possible to merge dimension

Interactive editing is possible

.wqy documents are supported in XIR3

Attached to Measure

Attached to Dimension

Standalone objects

A & B

Rank

Alert

Filter

Break

prompt(‘message’,[‘type’],[lov],[MONO|MULTI],[FREE|CONSTRAIN])

@Prompt(‘message’,[‘type’],[MONO|MULTI],[FREE|CONSTRAIN])

@Prompt(‘message’,[lov],[MONO|MULTI],[FREE|CONSTRAIN])

None

These tables contain precalculated data

They are used to speed up the execution of queries

Both

None of these

To deliver structured information that the business user can easily navigate by using any possible combination of business terms to show the Key performance indicator

To make it easier for business User to build applications.

To make it easier to store data in the database and avoid data redundancy.

All of the above.

Query navigation states and query results are stored in the application server memory

If the same query has been executed by another user the result sets can be used if the OLAP cache is active

Reading query results from OLAP cache is faster than reading from the database

The size of the OLAP cache available does depend on the size of Cache memory available on the Users Desktop

Shared

Secure

Personal

Save for all

Multidimensional

Pre-calculated value

Nested data

Run time Calculation

MOLAP

ROLAP

DOLAP

HOLAP