OBI typically displays the names of the individual dashboards across the top of the screen. Unless we create more than 15 dashboards, it would not show it in a drop-down menu. That is the default dashboards required before they turn out to a menu.
Here we can group the dashboards that were built based out of same subject areas and show a drop down menu as follows:
In order to do that, we need to create dashboards by using the same shared folder and change the instanceconfig.xml file parameter as follows.
We always used to keep the Weblogic server username and password on server start-up and shutdown. This process could be automated. There are two different approaches for this. Making this as Windows Service and set it as ‘Automatic’ in Startup Type .Other controllable approach is to manipulate the StartStopservices.cmd file of weblogic to pass the weblogic user name and password variable with a hard-coded predefined value.
To adopt the second approach take the backup of file “StartStopServices.cmd(for WINDOWS)/ StartStopServices.tmplt(for LINUX)” located in below path:
and add the below strings to pass the value of the variables: -DWLS_USER=weblogic -DWLS_PW=xxxxxxxxxxxx
(here “xxxxxxxxxxxx ″ is my password).
Save the file and start the BI Services. It will take the username and password automatically reading from the file.
Parent Child hierarchies are different from normal level based hierarchies not only in the nature of their structure but also in the way aggregations are done. For example, in a level based hierarchy, the most common type of aggregation that is done involves rolling up the numbers from the lower most level. But in the case of parent-child hierarchy, an aggregation by default enforces the roll-up across all descendant members.
Right Click on any dimension column and click on Dimension with Parent-Child Hierarchy.
Give the Parent Key and Member Column.
Now click on Parent-Child Settings.
Create Parent-Child Relationship Table (middle one – yellow arrow).
After clicking new give the name for the DDL and DML scripts. This wizard will create the SQL scripts.Click Next.
After finishing the wizard you can see the HierarchyTable got imported automatically.
Now go to the scripts location and run the DDL & DML scripts and commit the changes.
Update the row count and make sure table got created properly.
Pull the BMM model to presentation layer and create presentation folders.
Now we are done with the metadata definition. Save the RPD and make sure there are no consistency errors.
Running answers and verifying the hierarchy.
Here we can see the Parent-Child Hierarchy which we created.
Step1: Open Enterprise Manager (em).Go to Business Intelligence–Core Application–Deployment–Repository.
Step2: Click Lock and Edit Configuration on the top, such that it allows us to Edit the screen.
Step3: Browse the repository file here by clicking the Browse button and give the password for the repository , the repository is path is not required. After Uploading it will automatically goes to the repository path.
Step4: In the same way you can do for the catalog. Change the name of the catalog and Click on Apply.
Step5: On the top you can find Activate Changes and Restart to apply recent changes. Click it.
After restarting the services you can find the changed RPD and Catalog in Online mode.
I f you are using the Linux Box and you want to open the RPD in your Local by using Admin Tool then you have to add a DSN to your local pointing to the Server.
Adding a DSN:
Open ODBC Microsoft Administrator. Go to System DSN tab, Click on Add.
We will get Create New Data Source window.
In that select Oracle BI Server 1 which will connect to Oracle BI server.
Give the Name and Server IP address. Click Next.
Give the Login ID and Password of Oracle BI Server and Click Next.
Now you will get the success screen ,Click Finish.
Now you can Open your RPD in online mode by using the Admin Tool.
This feature allows a column prompt to be displayed as a slider and the user can use the slider to “slide” thru the specific values of that column, changing the chart view for each value.
Chart Zoom allows the user to zoom to a set of values while in a chart view. To use the Chart Zoom Feature, edit the properties of a chart using the Answers Analysis Editor and check the ‘Zoom and Scroll’ property in the Canvas tab.
Hierarchies and In-place Drill
In earlier version interacting with dimensional hierarchy meant drilling down from one level to next which added a new column to output. In addition to this behavior, OBIEE 11g has provided for interacting with the hierarchy by expanding and collapsing individual levels within the same report column using the plus (+) and minus (-) icons adjacent to the displayed member values. This way you can easily navigate across various dimensions. This is more of a paradigm shift from static hierarchical experience to dynamic hierarchical experience.
Allows users to visualize their analytics datausing maps,thus bringing the intuitiveness of the spatial visualizations to the world of business intelligence.
Improved and Enhanced Report indexing or Report search facilities
Master-detail linking of views allows us to establish a relationship between two or more views such that one view, called the master view, will drive data changes in the other (connected) views, called detail views.
We can have Page Break in prompts,scrolling of prompts.
Will be Available from Apple iTunes App Store
Devices supported: iPhone 3GS, 4, iPad
A KPI is a measurement of a particular business process which is compared against specific goals and objectives of an organization.KPI’s are typically tracked over time as a way
to monitor performance and drive business decisions to help improve upon that performance.
Scorecard and Strategy Management
Scorecard ultimately is about the identification of a small number of financial and non-financial measures and attaching targets to them, so that when they are reviewed it is possible to determine whether current performance ‘meets expectations’. The idea behind this is that by alerting managers to areas where performance deviates from expectations, they can be encouraged to focus their attention on these areas, and hopefully as a result trigger improved performance within the part of the organization they lead.
Very useful feature where you can track multiple KPIs at the same time and you can collect interrelated KPIs and make their list and keep them on dashboard for ready reference.
Action Link Menu
Used to link Different Webpages,BI Content,http Request,Java Method,Browser Script,Web Service.
Which is used to browse the reports in the folder.
Which is used for Alert Mechanism.
selection steps are applied on a column-level basis and provide two methods for limiting the data.
Interaction and WriteBack
In column Properties the Interaction and Write Back was given in new tab but in 10g we got those in Column Format.
Interchange Of Columns Order
We can interchange the columns from left to right and vice versa even in the Dashboards.We can move the Columns from Prompts,Sections in the Dashboards.