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

Dimension Hierarchies in OBIEE11g



A hierarchy is a cascaded series of many-to-one relationships and consists of different levels.
                                                 
Example, a region hierarchy is defined with the levels Region, State, and City.
In the Business Model and Mapping layer, a dimension object represents a hierarchical organization of logical columns (attributes). One or more logical dimension tables can be associated with at most one dimension object. Common dimensions might be time periods, products, markets, customers, suppliers, promotion conditions, raw materials, manufacturing plants, transportation methods, media types, and time of day. Note that dimensions exist in the Business Model and Mapping (logical) layer and in the Presentation layer.
There are two types of logical dimensions:
1.       Dimensions with level-based hierarchies (structure hierarchies).
2.       Dimensions with parent-child hierarchies (value hierarchies).
Level-based hierarchies are those in which members are of several types, and members of the same type occur only at a single level.
In parent-child hierarchies, members all have the same type. Oracle Business Intelligence also supports a special type of level-based dimension, called a time dimension, that provides special functionality for modeling time series data.

Level-Based Hierarchies
A dimension contains two or more logical levels. For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level-based hierarchies can also contain parent-child relationships. The recommended sequence for creating logical levels is to create a Grand Total level and then create child levels, working down to the lowest level.
Level-based Dimension hierarchy levels allow:
  • to perform aggregate navigation,
  • to configure level-based measure calculations,
  • users from Dashboard and Answers to drill down from one parent to a child level.
The following are the parts of a dimension:
  • Grand Total level : A special level representing the grand total for a dimension. Each dimension can have just one Grand Total level. A Grand Total level does not contain dimensional attributes and does not have a level key. However, you can associate measures with a Grand Total level. The aggregation level for those measures will always be the grand total for the dimension.
  • Level : All levels, except the Grand Total level, need to have at least one column. However, it is not necessary to explicitly associate all of the columns from a table with logical levels. Any column that you do not associate with a logical level is automatically associated with the lowest level in the dimension that corresponds to that dimension table. All logical columns in the same dimension table have to be associated with the same dimension.
  • Hierarchy : Each dimension contains one or more hierarchies. All hierarchies must have a common leaf level and a common root (all) level.
  • Level keys : Each logical level (except the topmost level defined as a Grand Total level) must have one or more attributes that compose a level key. The level key defines the unique elements in each logical level. The dimension table logical key has to be associated with the lowest level of a dimension and has to be the level key for that level.
  • 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:
  • Unbalanced (or ragged) hierarchy : A hierarchy in which all the lowest-level members do not have the same depth For example, a site can choose to have data for the current month at the day level, previous months data at the month level, and the previous 5 years data at the quarter level.
  • For example, a Time hierarchy might have data for the current month at the day level, the previous month's data at the month level, and the previous 5 years' data at the quarter level. This type of hierarchy is also known as an unbalanced hierarchy.
Note that unbalanced hierarchies are not necessarily the same as parent-child hierarchies. Parent-child hierarchies are unbalanced by nature, but level-based hierarchies can be unbalanced also.
  • Skip-level hierarchy : A skip-level hierarchy is a hierarchy where there are members that do not have a value for certain higher levels. . For example, in the United States, the city of Washington in the District of Columbia does not belong to a state. The expectation is that users can still navigate from the country level (United States) to Washington and below without the need for a state.
                                          
Hierarchy with Unbalanced and Skip-Level Characteristics 
 
Parent-Child Hierarchies
A parent-child hierarchy is a hierarchy of members that all have the same type.It is a value-based hierarchy — Consists of values that define the hierarchy in a parent-child relationship and does not contain named levels. This contrasts with level-based hierarchies, where members of the same type occur only at a single level of the hierarchy.
For example, an Employee hierarchy might have no levels, but instead have names of employees who are managed by other employees. Employees can have titles, such as Vice President. Vice Presidents might report to other Vice Presidents and different Vice Presidents can be at different depths in the hierarchy.
The most common real-life occurrence of a parent-child hierarchy is an organizational reporting hierarchy chart, where the following all apply:
  • Each individual in the organization is an employee.
  • Each employee, apart from the top-level managers, reports to a single manager.
  • The reporting hierarchy has many levels.
These conditions illustrate the basic features that define a parent-child hierarchy, namely:
  • A parent-child hierarchy is based on a single logical table (for eg, the "Employees" table)
  • Each row in the table contains two identifying keys, one to identify the member itself, the other to identify the "parent" of the member (for example, Emp_ID and Mgr_ID)
                                        
Multi-Level Parent-Child Hierarchy
In level-based hierarchies, each level is named, and occupies a position in the hierarchy that corresponds to a real-word attribute or category that is deemed useful for analysis. Unlike level-based hierarchies, where the number of levels is fixed at design time, there is no limit to the depth of a parent-child hierarchy, and the depth can change at run time due to new data.

flash charts

As far as BI EE is concerned, Flash charts offer greater quality and interactivity than raster based image formats like PNG or JPEG.

BI Presentation Services however do offer you the choice of having charts render in vector based Flash or SVG formats, or as raster based PNG or JPEG images.

The way to do that is to modify the instanceconfig.xml file and specify the chart format thy heart desires. If your Oracle BI data directory is "C:\OracleBIData" then the instanceconfig.xml file can be found under the C:\OracleBIData\web\config folder.


Open the instanceconfig.xml file using a text editor and insert these three lines in the file:

<charts>
<defaultimagetype>PNG</defaultimagetype>

</charts>

Tuesday, October 30, 2012

OBIEE 11g Features

Some important points/enhancements in OBIEE 11g when compared to OBIEE 10g are listed below
  1. OBIEE 11g uses WebLogic Server as the application server as compared to Oracle AS or OC4J in OBIEE 10g.
  2. The clustering process in much easier and automated in OBIEE 11g.
  3. We can now model lookup tables in the repository.
  4. The new UI called Unified Framework now combines Answers, Dashboards, and Delivers.
  5. A new column called the hierarchical column in introduced.
  6. BI Publishers is fully and seamlessly integrated with OBIEE 11g.
  7. New time series functions PERIOD ROLLING and AGGREGATE AT are introduced.
  8. In OBIEE 11g we can create KPIs to represent business metrics.
  9. The aggregate persistence wizard creates indexes automatically.
  10. The session variables get initialized when they are actually used in OBIEE 11g unlike OBIEE 10g where they were initialized as soon as a user logs in.
  11. OBIEE 11g now supports Ragged (Unbalanced) and Skipped Hierarchy.
  12. You can also define Parent-Child hierarchy in OBIEE 11g as well.
  13. SELECT_PHYSICAL command is supported in OBIEE 11g.
In OBIEE 11g there are some changes in the terminology as well.
  • iBots are renamed as Agents.
  • Requests are renamed as Analyses.
  • Repository password was introduced in obiee 11g  
  •   
  •  
  • Difference of Siebel & OBIEE
  • 1. In OBIEE, we can use Evaluate fn
    2. Time series wizard s used in Siebel whereas ago & todate functions added in OBIEE
    3. OCI call interface connection is available in OBIEE
    4. Presentation variables are introduced
    5. Meta data dictionary is there in obiee
    6. Multi select feature ( contains any, begins with, ends with, wildcards like %) are available in obiee

     
  •  
  • Difference of OBIEE 10g and 11g
    1. In 10g OC4J (Oracle container for java) . In 11g its Weblogic server
    2. Security is managed by RPD in 10 g. In 11g the security is managed by the welogic server.
    3. In 10g we had Foreign key join (physical layer) & complex key join (BMM). We only have a New Key Join in case of 11g , which is used at both the BMM & Physical layer.
    4. 11g supports cross join hierarchies example we can move from customer dimension to product dimension during drilling down. Supports ragged hierarchies etc.
    5. 11g also has column hierarchies available in the presentation services, which are created simply by dragging the dimension hierarchies from the BMM layer to the presentation layer in RPD. when column hierarchies are used to build an analyses the default view is Pivot table.
    6. The time series functions Ago & ToDate which where only available in the RPD with 10g are now also available in the presentation services along with a new function Period rolling.
    7. The analyses can now by reconstructed at run time, that means we can move column attribute from the x-axis to the y-axis and reverse as well.
    8.KPI’s are available in the 11g along with KPI Watchlist on which they are deployed to be viewed by the end user. Key Performance indicators (metrics very essential for the business)
    9. Concept of scorecards is available in 11g, which can measure the goal/mission by using KPI’s as the building blocks for the same
    10. concept of Seletions is now available in the presentation services in 11g.
    11. There is a single portal for the bi publisher/bi intelligence. The reports that are built in the BI Publisher are stored in the same catalog, as the analyses created using the bi intelligence.
    12. 11g has Action Framework which can by used to invoke, existing analyses, html, java procedures.
     
  •  

Sunday, October 28, 2012

rittmanmead important document links for modify the xml files

http://www.rittmanmead.com/files/biforum2012/masterclass/RM_BIForum12_Cust2.pdf



http://obieeelegant.blogspot.in/
http://obiee10grevisited.blogspot.in/2012/06/line-break-in-column.html

 obiee document
-----------------
http://www.scribd.com/doc/63642433/Obiee101-All