BIEE 11g Install High level Steps :
Software Required
1.Database (Oracle, IBM DB2 or MS-SQL)
2.Repository Creation Utility (RCU)
3.OBIEE 11g (11.1.1.3 is latest OBIEE as of 30 April 2011)
4.WebLogic 10.3.3 (Optional - Only required for 64 bit machine or IBM AIX)
5.JDK 1.6 64 bit (Optional - Only required for 64 bit machine)

Explanation/Reference:
CurrentMonth can be calculated by a sql statement.
Note:
REPOSITORY VARIABLE(DYNAMIC)
Initialized when BI server is started
Assigned value dynamically based on the result of a query
Value is dependent of the sql provided in Initialization Block
Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.

Provide Intialization Block variable Name

Click on "Edit Data Source" button and provide the sql to be used for the variable, e.g.
select lower(sys_context('USERENV','SESSION_USER'))||
'@'||
lower(sys_context('USERENV','DB_NAME'))
from dual;

Explanation/Reference:
Users in Oracle BI Answers can create queries that span multiple subject areas, as long as the subject areas correspond to the same business model.
Incorrect answers:
D: "How do I combine data from two different subject areas into one report?" Although there are a couple of very limited options for doing so within Answers - Union queries and Sub-queries, the real solution is that the Subject Areas themselves were probably not designed properly.
Note: Although each subject area must be populated with contents from a single business model, you can create multiple subject areas for one business model. For very large business models, you may want to do this to help users work with the content.

A:OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.
B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you'd choose to instead scale out the existing BI domain.

Node2-2
C: OBIEE Clustering - Approach of Oracle BI Server Load balancing/Failover

Explanation
Creating Logical Time Dimensions
Compared to modeling an ordinary dimension, the time dimension requires just two additional steps: selecting the Time option in the Logical Dimension dialog, and designating a chronological key for every level of every dimension hierarchy.
Note: Time dimensions and chronological keys. You can identify a dimension as a time dimension. At least one level of a time dimension must have a chronological key. The following is a list of some guidelines you should use when setting up and using time dimensions:
* At least one level of a time dimension must have a chronological key.
* All time series measures using the AGO, TODATE, and PERIODROLLING functions must be on time levels. AGO, TODATE, and PERIODROLLING aggregates are created as derived logical columns.