Datawarehouse Architect

Dashboards name renaming for business purpose. Steps to Renaming Dashboard Names 1. Select the Dashboard which you are going to change Before Changing Dashboard Name take a back up of Catalog and RPD too. Look Before changing the name. Renaming Dashboard Name in OBIEE 10G Changing ‘FINANCIALS’ to ‘Financial 2013’ 2. Click on Edit Dashboard properties in the right side of the dashboard under page option. Renaming Dashboard Name in OBIEE 10G 3. You will get the dashboard editor page to change the name, Under that click on dashboard properties hand symbol. Renaming Dashboard Name in OBIEE 10G Click on that properties. 4. Dashboard properties page will get display, below that go for Dashboard pages à operations Under operations u can change the dashboard name. Renaming Dashboard Name in OBIEE 10G 5. Click on Rename symbol Rename the dashboard to FINANCIALS TO Financials 2

In OBIEE 11g there are three ways to renaming the dashboard name. 1. First method is by edit dashboard page properties. 2. Using catalog à admin view à renaming. 3. Using catalog manager changing/renaming the dashboard name. Using Dashboard – Page properties Select the dashboard page you need to rename and go to the right top to “Edit Dashboard “ Renaming From “Supplier Statement” to “Aging” and “Aging” to “Supplier Statement” Renaming Dashboard Name in OBIEE 11g Edit the Dashboard. Renaming Dashboard Name in OBIEE 11g Go to the Dashboard properties Renaming Dashboard Name in OBIEE 11g Dashboard properties and pages to edit page will get display to make changes. Renaming Dashboard Name in OBIEE 11g Rename and check in “preserve the old name for the item” From “Supplier Statement” to” AGING” Renaming Dashboard Name in OBIEE 11g Renaming Dashboard Name in OBIEE 11g

Conditional Format is used to perform some mathematical or calculating measures and making difference between the values by using column properties with images. Step 1: Select the Columns from subject area for which you want to make difference between the values. Most commonly in Profit & Loss Income statement we may have revenues (difference). Data is on pivot table without using conditional format. Condition formatting in OBIEE 11g  Here we are having 10 types of accounts and its revenue sale, but in this we can’t find out the difference between the revenues which gave profit & Loss. Step 2 For making difference select the “Actual_sum” column and edit. Condition formatting in OBIEE 11g  Click on the ‘E’ symbol column edit properties and go for the 4th tab “Conditional Format” Condition formatting in OBIEE 11g  Step 3: Click on Add Condition and select the “Actual Sum” Column and use the condition  If the valu

In obiee 11g we have the option named as “ Selection Steps ” Selection Steps is the new feature added in OBIEE 11g to be very useful for calculations. Steps included the condition formats (Conditions) like ·          Exception ·          Top/Bottom ·          Match Selection Steps in OBIEE 11g Exception ·          X>=value ·          X>=Y ·          X>=Y+10 ·          X>=Y-5% ·          X within 10 of Y ·          X not within 5% of Y ·          X between 'min' and 'max' values Top/Bottom ·          Top 10 based on X ·          Bottom 5% based on X ·          Making up to 3% based on X Match ·          Name contains 'abc'