Monday, January 7, 2013

How to deploy RPD and catalog without Enterprise manger

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.

Monday, November 26, 2012

OBIEE 11.1.1.6 - Dashboard prompt show "Null" value in drop-down list

OBIEE 11.1.1.6 - Dashboard prompt show "Null" value in drop-down list


In the dashboard prompt, "NULL" value was added as a choice in every prompt after applying the patch OBIEE 11.1.1.6.

In the above example, to filter the NULL value in prompt
1) Edit the prompt definition for this column, select 'SQL Results' from 'Choice List Values' selection.
2) Add the condition WHERE IS NOT IN ('(Null)') to your SQL statement and click OK to preview the result. This will display all non-null values in the prompt drop-down as below.

event pooling table

http://bintelligencegroup.wordpress.com/

OBIEE11g arrow Images location



C:\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\meters\arrow


C:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\meters\arrow


below image should add in the above locations then we get these arrow at column properties-->style-->images location

C:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\s_blafp\meters\arrow

Monday, November 19, 2012

bypass presentation services cache



During our development if we wanted to check the report level UI changes, sometimes we will not see the changes immidiately. This is due to Presentation Server Cache. Eventhough we disable the BI Server cache, It doesnt make any effect on presentation Server objects.
So in that situations we need to disable Presentation server cache permanently across OBI Application, To do this add the following parameters in instaceconfig.xml. (Make sure that you have taken a backup copy of instanceconfig.xml)
<ServerInstance>
———
<Cursors>
<ForceRefresh>false</ForceRefresh>
</Cursors>
——–
</ServerInstance>
Now restart the OBI Presentation server service and test the results.
Note: Keep in mind that this parameters cause Presentation Server to always bypass its cache. To be used only for testing – may have serious performance implications.

bethamsetty

Removing the bookmark link in dashboardpage

enablebookmarkurl
>
false 
<
/enablebookmarkurl
>
<
enablepromptedurl
>
false
<
/enablepromptedurl
>


 
please paste it under   in instance config.ini
repalce true to false.
 
Restart the all services 
 
 

Monday, November 5, 2012

How to start testing during an OBIEE Environment

How to start testing during an OBIEE Environment:

In an earlier posting I discussed the importance of and where to implement testing in the Project Life Cycle for an OBIEE Application. In this posting I want to discuss further how to implement testing for the application and some of the major steps during the Project Life Cycle.
During the Project Initiation Stage of the Project Life Cycle the first step in testing is to develop a Test Strategy. The Test Strategy outlines the recommended approach to the testing processes during the Project Life Cycle. Some of the key components of the Test Strategy are:

· Purpose and Test Objectives
· Quality Standard
· Test Phase Ownership
· Test Phases and Test Types
· Test Plans
· Test Case Repository
· Test Case Design
· Defect Tracking System
· Severity Levels of Defects
· Test Tools
· Test Reports

Since testing will be incorporated of the Project Life Cycle, it is critical that all project team members be familiar with the test strategy and understands their roles in the Project Testing Processes. All project team members will be involved is multiple phases of the testing processes, and it is important that they understand their role in testing and the roles of the other project team members in the testing processes.

Once the Test Strategy has been completed by the Testing Team and approved by the Business Users the next step is to start the Project Test Plan. The Test Plan is started during the Project Requirements Phase. As the requirements are being gathered it is important to identify how the requirements can be validated and tested to insure that they are met by the provided application. The development of the Test Plan involved all members of the Project Team as well as the Business Sponsor and Users. Once a requirement has been defined it is important to have some way to substantiate that the requirement has been met by the application. While looking for ways to test a requirement, it also helps the business user better define and understand the requirements. In most cases the business users have a good understanding of their source application, but have very little insight into the metrics and attributes needed by measure and manage their business processes. Also when a business application is used by many different groups they may have many different business processes to do the same functionally. While gathering the Business Requirement and Testing Requirements, there may be many different test cases to measure the same functionally across different departments in an organization. It is important to gather this testing information to insure that the business requirements can be validated by the different departments. One of the important steps that are often overlooked in testing is to test the actual requirement to insure that is valid and verifiable to measure and manage their business processes. Unfortunately this is often not the case and not until the business users see the Dashboards and Reports do they understand the value of the metrics and attributes for measuring their business processes. The Test Plan can help to identify the type of Testing and Test Cases that need to be developed to validate the requirements. Some of the items that can be included for testing are:

Validate the access to the System – Security
Validate the navigation to a particular screen, dashboard, page, and report
Validate access to the right data, screens, dashboards, pages, and reports
Validate the response time to access the application
Validate the response time to access a particular dashboard, page and report
Validate the capability and ease of using prompts to select data on a report with specific attributes
Validate the use of drilldown on Reports
Validate the use of navigation on Reports
Validate that the attributes that are used to display the metrics are correct
Validate that the metrics on the Reports provide helpful and valuable information to help them measure and manage their business processes

The next major testing task is to develop test cases to validate the user requirements. The Test Cases are usually designed and built during the design and build stages of the Project Life Cycle. In most situations the Test Cases are iterative, because more details are fleshed out during the Project design and build stages. For each requirement the minimum information needs to be developed for each test case:

Test Case Number
Test Case Summary
Test Case Description
Test Case Steps
Test Case Expected Results
Test Case Error Condition
Person responsible for Test Case

Once the Test Cases are built and agreed upon by the Project Team and Business Users, and the design and build stages for the application are complete then the execution of the Test Cases can begin. One major advantages of building the Test Cases early in the Project Life Cycle is the Development Team will understand the test conditions and can execute many of the Test Plans during Unit Testing. Quality is an important of any project and each team member is responsible for building quality into the finished product. By using the aforementioned Testing Processes quality can be built into the project from the earliest part of the Project Life Cycle, instead of waiting until the finished product is turned over to the business users for user acceptance testing. If testing is only implemented during user acceptance testing many of the quality issues that would have been identified and corrected in the early part of the Project Life Cycle will come to light, and will cost more in terms of resources and money to correct than if they were identified and corrected in the earlier stages of the Project Life Cycle