Displaying dashboards in dropdown menu

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.

<DashboardMaxBeforeMenu>2</DashboardMaxBeforeMenu>

So if you have more than 2 dashboards then all the dashboards which comes from the same shared folder will be displayed as menu. And this entry takes effect for all the shared folders.

Advertisements
By bidevatapraveenkumar Posted in OBIEE

By Pass Username and Password on Weblogic Server Startup

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:

/uo1/Middleware/Oracle_BI1/bifoundation/install

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.

By bidevatapraveenkumar Posted in OBIEE 11g

Scheduling Agents In OBIEE 11g

Agents In OBIEE 11g:

E-Mail Configuration before Scheduling a report:

Step1: Open Enterprise Manager (em), Go to Business IntelligenceàCoreapplicationàDeploymentàMail.

Step2: Give the SMTP Server, Port, Name, Email, Username and Password.

Step3: Open the Answers page login by using the credentials and go to catalog, select a report which you want to schedule.

Step4: You can find Schedule Option in the more tab or else you can schedule a report by going to NewàAgent.

General: The General tab shows the Priority.

Schedule: The Schedule tab shows when to Run the Agent.

Condition: The Condition tab allows us to specify for a condition.

Delivery Content: The Delivery Content shows the report which we want to schedule.

Recipients: The Recipients tab shows who will receive the Agent.

Destinations: The Destinations tab shows in which format the Agent should be delivered.

Step5: Save the Agent and Run the Agent.

We can see the report which you scheduled in our mail.


By bidevatapraveenkumar Posted in OBIEE 11g

Date Last Refreshed in Answers Page

Step 1: Open RPD and Go to ManageàVariables.

Create a new Initialization Block in Session Variables.

Step2: In Variable Target Click on Edit Data Target and create a New Variable.

Step3:  Write the SQL statement  as

SELECT ‘:USER’ || ‘, Data Last Refreshed : ‘ || to_char(sysdate,’DD-MON-YY HH24:MM:SS’)  FROM DUAL

Click the Browse button and browse the Connection Pool.

Open the RPD in Offline mode and Test for the Connection Pool whether it is active or not.

Step 4: Save the PRD, Check consistency.

Step5: Open the Answers Page by using the user credentials then we can see the Username who had login with the date and time of the user login.


By bidevatapraveenkumar Posted in OBIEE

Adding SQL Server as a data source to OBIEE on 64 bit Linux 11g

Integration of  OBIEE11g with SQL Server on linux.

1)      Go to  OBIEE path  like

Ex: /u01/ORACLEFMW/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup

2)      Edit odbc.ini file  and add the below lines.

SHAREPOINTDB = MICROSOFT SQL SERVER DRIVER

[SHAREPOINTDB]

Driver=/u01/ORACLEFMW/Oracle_BI1/bifoundation/odbc/lib/SEmsss23.so

Description=DataDirect 5.1 SQL Server Wire Protocol

Address=172.16.30.5,1433

AlternateServers=

AnsiNPW=Yes

ConnectionRetryCount=0

ConnectionRetryDelay=3

Database=WSS_Content

LoadBalancing=0

LogonID=angel 

Password=angel

QuoteID=No

ReportCodePageConversionErrors=0

3)      Import the SHAREPOINTDB(RPD DSN NAME) by selecting ODBC3.5 in Connectionpool and specifiy the username and  password .

4)      Note: WINDOWS RPD DSN and LINUX RPD DSN Should be same i.e like   SHAREPOINTDB must be in SHAREPOINTDB in odbc.ini file in Linux.

By bidevatapraveenkumar Posted in OBIEE 11g

Parent Child Hierarchies In OBIEE 11g

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.

By bidevatapraveenkumar Posted in OBIEE 11g

How to keep RPD and Catalog in Online mode in OBIEE 11g

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.

By bidevatapraveenkumar Posted in OBIEE 11g

Log Files in OBIEE 11g

In Enterprise Manager Console you can find the Most Recent Errors and Most Recent Warnings. After warning messages,  you can also see all the log files grouped by categories using Log Viewer.

Available files:

• Presentation Services Log
• Server Log
• Scheduler Log
• JavaHost Log
• Cluster Controller Log
• Action Services Log
• Security Services Log
• Administrator Services Log

The log files for OBIEE components are found under /instances/instance1/diagnostics/logs

 Different type of log files:

Presentation Server log files:

/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1
Files: sawlog0.log, webcatupgrade0.log

BI Server log files:

/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1
Files: nqquery.log, nqserver.log, servername_NQSAdminTool.log, servername_nQUDMLExec.log, servername_obieerpdmigrateutil.log

Scheduler log:

/instances/instance1/diagnostics/logsOracleBISchedulerComponent/coreapplication_obisch1
Files: nqscheduler.log

Cluster Controller log:

/instances/instance1/diagnostics/logs/OracleBIClusterControllerComponent\coreapplication_obiccs1
Files: nqcluster.log

ODBC log:

/instances/instance1/diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1

OPMN log:

/instances/instance1/diagnostics/logs/OPMN/opmn
Files: debug.log, logquery~NUMBER.log, opmn.log, opmn.out, service.log

Installation logs:

/logs

By bidevatapraveenkumar Posted in OBIEE 11g

New Features in OBIEE 11g(RPD)

New Features Descripton
ID Columns for Descriptive Columns (“Double-columns”) Allows you to specify another logical column as the ID column for a descriptor
Lookup Tables LOOKUP function introduced with OBIEE 11g allows lookups on logical and physical tables
Support for Ragged, Skip-Level and Parent-Child Hierarchies Level-based hierarchies may have skip-levels, or ragged hierarchies,Skip-levels are when members may not have an immediate parent,Ragged hierarchies are when leaf members are not all at the same level
Hierarchical Subject Area Columns We can bring hierarchy to the subject area and make use of it while creating the reports
LTS Priority Ordering
Repository Passwords In the file –>we can find the change password option
Deployment of Repository Files using Fusion Middleware Control
New in 11.1.1.5 : Oracle OLAP as a Data Source OBIEE 11.1.1.5 supports Oracle OLAP 10.2+ as a data source.Administration Tool can connect to AW metadata and import as MOLAP source
Fact to Dimension join in the physical Layer In the physical layer , we have to use join from dimension to fact for the rpd modelling
User and Group are defined in the Enterprise Manger In OBIEE 11g , we can create user and group and defined the roles to the group by enterprise manager
By bidevatapraveenkumar Posted in OBIEE 11g

New Features in OBIEE 11g(UI)

New Features Description
Chart Sliding 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 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.
Map-based Visualizations 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 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.
Cascading Prompts We can have Page Break in prompts,scrolling of prompts.
Will be Available from Apple iTunes App Store Devices supported: iPhone 3GS, 4, iPad
KPI 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.
WatchLists 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.
Folder Which is used to browse the reports in the folder.
Alert Section Which is used for Alert Mechanism.
Selection Steps 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.
By bidevatapraveenkumar Posted in OBIEE 11g