Sunday 29 January 2012

How to deploy RPD and catalog without Enterprise manger

Many times the obiee service goes off because of deployment of inconsistent RPD and to make the services up we need to deploy the previous RPD.

To achieve this we change the name of RPD and Catalog in NQSConfig.ini and Instanvceconfig.xml file respectively just similar to obiee 10g RPD and catalog deployment method. But in obiee11g if we change in NQSConfig.ini and Instanceconfig.xml file and restarted the services the obiee 11g revert back the changes whatever we did manually.


Actually there is Central configuration enable by default in obiee11g which allows us to update the configuration with interface. So to disable the central configuration and deploy the RPD and catalog with obiee10g fashion follow the following steps

1) Edit the biee-doamin.xml file from location ORACLE_HOME\user_projects\domains\bifoundation_domain\config\fmwconfig and edit the “centralConfigurationEnabled” tag as shown below











2) Change the RPD name in of RPD in NQSConfig.ini file .The NQSConfig.ini file is located at ORACLE_HOME\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1












3) Change the catalog detail in instanceconfig.xml file.File is located at location at ORACLE_HOME\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1








4) Restart all services, now you can see the changes whatever we did in NQSConfid.ini and instanceconfig.xml file are as per our requirement now.

Saturday 28 January 2012

How change the column heading dynamically

We can change the column heading dynamically by passing the presentation variable in column heading, to achieve this follows following steps

1) Log into the Business Intelligence analytics with the link 
    http://Machine_name:port/analytics
    The port will be 7001 if OBIEE install with simple install option with default port
    configuration or it will 9704 if OBIEE is install with enterprise option default port configuration

2) Click on New-> Dashboard Prompt


          





















3) Select the column prompt

  






















4) Select the Column Calendar Date from Sample Sale Lite subject area

 






















5) Set the presentation variable Date and save it

 




















6) Then go for report creation click New-> Analysis

  






















7) Pulled the column field to display on the reports









8) Click on right most button of field and select column property











9) On column properties dialog box navigate over column format and select check box Customize heading.              Set the presentation variable @{Date} in column heading

















10) Save the report and pulled it on Dashboard page and select the date from prompt















11) The column heading will change according to value select in the prompt

 

Thursday 26 January 2012

Use of presentation Variable across Dashboard page and subject area in Prompt

 1) Log into the Business Intelligence analytics with the link 
    http://Machine_name:port/analytics
    The port will be 7001 if OBIEE install with simple install option with default port configuration or it will 9704 if
     OBIEE is install with enterprise option default port
2) Click on New-> Dashboard Prompt


3) Select the column prompt


4) Select the Column Calendar Date from Sample Sale Lite subject area

5) Set the presentation variable Date and save it


6) Then go for another prompt and select variable prompt this time

 
7) Do the setting as shown below, in user input select the choice list, in choice list value select
    All column values and then click on select column(select desired column you want)
 
8) Pass the presentation variable created earlier and save it

    
9) Now pull both the prompt on same Dashboard page or we can pulled it on different page also


10) Select one of the Date and click on apply button the other prompt will also change with
       selected Date in prompt one as default value