1q.
What are the two storage options available in Essbase and what are the
differences?
we have two different storage options in Essbase they are
1.ASO
2.BSO
~~~~~ ASO
.ASO is used for reporting purpose and it doesn't have write back functionality and
it doesn't have concept of sparse and dense by default ASO uses sparse dimensions
and data can only be loaded at leve0 members only and single database is used for
single ASO application
if we have more dimensions it is advised to use ASO storage type as it uses sparse
data storage model which is more efficient for storing large volumes of data
resulting in reducing storage requirements
~~~~~ BSO
BSO application is useful for more calculations purpose where there are frequent
write backs and data input is requires such as budgeting and forecasting
applications, BSO applications are classified into two types sparse and dense, data
can be loaded at any level member. BSO applications can have more than single
database
___________________________________________________________________________________
___________________________________________________________________________________
_______________________
2q.Can we build dimensions directly from data sources without using rule files?
yes it is possible to build the dimensions without using rule files but i haven't
tried any of that
~~1.usnig maxl scripts
~~2.oracle data integrator
___________________________________________________________________________________
___________________________________________________________________________________
____________________
3q.When do we generally use build rules files
Rule files are used to automate the process of creating and maintaining the
structure of Essbase databases and it also used to load the data in Essbase
database
___________________________________________________________________________________
___________________________________________________________________________________
________________________
4q.What are the three primary build methods for building dimensions?
the three main build methods on Essbase are
~~~~1.level reference ( in this level 0 members refers to the lowest member of
the dimensions)
~~~~2.generation reference ( in this generation 1 represents the root level in
the hierarchy)
~~~~3.parent child method
___________________________________________________________________________________
___________________________________________________________________________________
______________________
5q.What is the difference between UDA’s and Attribute dimensions?
~~~~ user defined attributes
UDAs are text tags or labels assigned to members within a dimension to categorize
them logically and it is mainly used for filtering and selecting subsets of data
during retrieval
~~~~ Attribute dimensions
Attribute dimensions are dimensions associated with standard dimensions. Attribute
dimensions are useful in describing a standard dimension member's attributes and it
is used to
retrieve and analyze data not only from the perspective of dimensions, but also in
terms of characteristics, or attributes, of those dimensions
attribute dimensions provide more flexibility than UDA’s. Attribute calculation
dimensions which include five members with the default names sum, count, min, max
and avg are automatically created for the attribute dimensions and are calculated
dynamically
___________________________________________________________________________________
___________________________________________________________________________________
______________________
6q.How does UDA’s impact database size?
~~~~~ no it doesn't affect the database, do not consume additional storage space
within the Essbase database. They are metadata attributes assigned to dimension
members
___________________________________________________________________________________
___________________________________________________________________________________
______________________
7q.How do Attribute dimensions and UDA’s impact batch calculation performance?
~~~~ UDA's doesn't impact the performance of calculation
~~~~ meanwhile adding attributes dimensions to base dimension increases the
complexity of the calculation resulting in taking additional time to retrieve the
data
___________________________________________________________________________________
___________________________________________________________________________________
______________________
8q.How can we display UDA’s in reports? How do they impact report performance?
~~~ UDA values are not displayed in reports and they don't affect the report
performance
___________________________________________________________________________________
___________________________________________________________________________________
______________________
9q.How does Attribute dim impact report performance
~~~~The highly impact the report performance as the attributes are calculated
dynamically when referenced in the report. For a very large number of att dim
displayed in the report, the performance could drastically reduce.
___________________________________________________________________________________
___________________________________________________________________________________
______________________
10q.How is data stored in the Essbase database
~~~ Essbase is a file based database where the data gets stores in .PAG file for
every 2gb of data it creates an additional .PAG file
___________________________________________________________________________________
___________________________________________________________________________________
______________________
11q.What is the role of provider services.
~~~~ provider service acts as intermediary between the client application and
Essbase server, it handles the authentication, session management and security for
users accessing Essbase applications
___________________________________________________________________________________
___________________________________________________________________________________
______________________
12q.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
~~~~~ use of exclude from consolidate operator
___________________________________________________________________________________
___________________________________________________________________________________
______________________
13q.What does never consolidate operator (^) do?
~~~ the"never consolidate" operator (^) is used to indicate that a specific
member should never be aggregated or consolidated with other members in the same
dimension
usage example: consider a product dimension where "Total Products" is a
member that aggregates all individual product categories. To ensure "Total
Products" does not consolidate further
___________________________________________________________________________________
___________________________________________________________________________________
______________________
14q.Why is top-down calculation less efficient than bottom-up calculation? Being
less efficient, why do we use them?
~~~~ top-down calculation involve more complex logic and computation because they
start from aggregated values and propagate them downwards
___________________________________________________________________________________
___________________________________________________________________________________
______________________
15q.On what basis you will decide to invoke a serial or parallel calculation method
~~~ it depends on various factors such as size of the database if the size is
smaller we go for serial for larger databases with multiple partitions we use
parallel calculation if our applications needs faster calculations we use parallel
and
___________________________________________________________________________________
___________________________________________________________________________________
______________________
16q.What is a block locking system?
~~~ The block locking system ensures that only one user at a time can update or
calculate a particular data block for example, if multiple users try read or write
data into the same block at a same time may lead to data inconsistency and data
corruption to prevent this from happening we use block locking system
___________________________________________________________________________________
___________________________________________________________________________________
______________________
17q.What are LRO’s (Linked Reporting Objects)?
~~~~ A linked reporting object is either a cell note, external file, or URL that
is linked to a data cell in an Essbase database which can be retrieved by users
through oracle smart view
usage: to attach any external objects or provide any instructions we can use
this
navigation: connect to database and application in eas console expand the
application and right click on database and select option named open data or
preview data it will open data grid and select the cell for which we want to attach
LRO and select the option on the taskbar linked object and select the object type
and browse the file in local and save it now users can see the LRO in smart view
___________________________________________________________________________________
___________________________________________________________________________________
______________________
18q. what is partition and Types of Partitions available in Essbase?
~~~ partition is a piece of database that is shared with another database
we have three types of partitions they are
1.repicated partition
2.transperent partition
3.linked partition
~~~~ replicated partition
it copies a portion of data from source database to target database any
changes made to source data will be reflected into target data and target database
is mostly read only database and if there any changes happened to target database
data wont flow back to source database
scenario: if a company have offices in multiple locations and they want to
access the report locally and also it creates copies of the data across other cubes
making the data is highly available
~~~~~ transparent partition
A transparent partition allows users to manipulate data that is stored
remotely as if it were part of the local database. The remote data is retrieved
from the source database each time the users of the target database request it
~~~~ linked partition
it enables data to be shared and synchronized between two Essbase databases,
known as the source and target databases. Unlike replicated partitions, which
create a read-only copy of data, linked partitions allow for more dynamic and
interactive data sharing, often with read-write capabilities.
___________________________________________________________________________________
___________________________________________________________________________________
______________________
19q. What is a data file cache?
the data file cache is a memory buffer used to improve the performance of data
retrieval operations by caching frequently accessed data blocks. By caching data
blocks that are frequently accessed, the data file cache minimizes the number of
disk reads, significantly speeding up data retrieval times
___________________________________________________________________________________
___________________________________________________________________________________
______________________
20q.What is a custom-based macro?
~~~ Macros enable you to combine multiple calculation functions into a single
function.
___________________________________________________________________________________
___________________________________________________________________________________
______________________
21q.What do you mean by dirty block?
___________________________________________________________________________________
___________________________________________________________________________________
______________________
22q.
What are the different types of LOG Files?
So many log files are there in Essbase, but the important log files are
1. Application log
2. Essbase.log
3. Configtool.log
4. eas_install.log
5. essbaseserver-install.log
___________________________________________________________________________________
___________________________________________________________________________________
______________________
23q.How do you optimize the outline?
~~~~ dimension with account tag
dimension with time tag
largest dense dimension
smallest dense dimension
smallest sparse dimension
largest sparse dimension
___________________________________________________________________________________
___________________________________________________________________________________
______________________
24q. what is standard dimension
~~~~ standard dimension is basic hierarchical structure to organize and analyze
the data according to organization plan
___________________________________________________________________________________
___________________________________________________________________________________
______________________
25q. what is substitution variable?
~~~ Substitution variables act as global placeholders for information that
changes regularly; each variable has a value assigned to it. we can change this
value based upon ore requirement
scenario
for example if we want to generate a report based on current month we have to
update the script manually every month instead we can use substitution variable
CURMNTH and assign values to it every month without changing the script
___________________________________________________________________________________
___________________________________________________________________________________
______________________
26q.what is database restructuring
~~~ it is a process that reorganizes the storage and indexing of data within a
cube to optimize performance and ensure efficient data retrieval and storage
we have three types of data restructuring
Dense restructuring ( it is triggered when there are any changes in dense
dimension or changes in the order of dense dimension)
sparse restructuring ( if a member of sparse dimension is moved, deleted or
added Essbase restructures the index resulting sparse restructuring)
outline only restructuring ( if changes affects only to database outline
___________________________________________________________________________________
___________________________________________________________________________________
______________________
27q.what are the parts of the partition?
~~~ 1.type of partition ( gives the information whether it is replicated,
transparent or linked partition)
2.data source information ( information of the server, application and
database name of the source data)
3.data target information ( information of the server, application and
database name of the target data)
4.login and password ( he login and password information of the source
and target database)
5.shared Areas ( information of one or more areas or sub cubes
shared between the source data and target data)
6.member mapping information ( a description on how the members in the data
source map to the member in the data target)
7.status of partition ( information about whether the data is up to
data or when was it last updated )
___________________________________________________________________________________
___________________________________________________________________________________
______________________
28q. what are the components of database
~~~ 1. outline
2. linked resource object
3. partitions
4. calc scripts
5. report scripts
6. rules file
___________________________________________________________________________________
___________________________________________________________________________________
______________________
29q. what are security filters?
~~~ filters in Essbase are used to restrict data access in database cells, they
ensure that users can only view or manipulate the data that they are authorized to
access
we have different types of access
1.none (No data can be retrieved or updated for the specified member list)
2.Read (Data can be retrieved but not updated for the specified member list)
3.write(Data can be retrieved and updated for the specified member list)
4.metaread(Metadata (dimension and member names) can be retrieved and updated
for the specific member)
___________________________________________________________________________________
___________________________________________________________________________________
______________________
30q.what is block locking system?
~~~it refers to process that controls concurrent access to data blocks within
the Essbase database
___________________________________________________________________________________
___________________________________________________________________________________
______________________
31q.explain members storage properties?
~~~ 1.store data ( members with this property stores the data in the database)
2.dynamic calc ( the data associated with this member is not calculated
until requested by a user)
3.dynamic calc store ( the data associated with this member are not
calculated until requested by user and then stores then data in the database)
4.shared member (a shared member is a member that references the data from
an existing primary member but operates in different location)
5.never share (when a member is set to never share it ensures that the
member doesn't share its data with other member even if they share the same name)
6.label only (it acts as label or heading within a dimension hierarchy these
members do not store data )
___________________________________________________________________________________
___________________________________________________________________________________
______________________
32q.
