How to see log level from Presentation Services

Step 1 : Login to answers page http://<hostname&gt;: <port >/analytics/ by using the credentials.

Step2 : Click on new and select a Subject Area, pull any column from the Subject Area.

Step 3 : Go to Edit Formula (fx) of the column and go to variable–>Session Variable now give the value as log level in the server variable and click ok.

Step 4 : Now click on results then we can see the log level which we set in the UI.



By bidevatapraveenkumar Posted in OBIEE

No Log Found error in OBIEE 11g:

When you try to take the query from the Administration Tab we used to get an error like No Log Found.

In order to see our query we have to set the log level to 7 in RPD.

Setting Log Level in RPD:

We have to check the Logging Level in three places in RPD.

Step 1 : Open RPD by using the credentials.

Step 2 : Go to Tools–>Options–>Repository

Here set the Log Level to 7 in System Logging Level.

Step 3 : Go to Manage–>Identity–>weblogic and set the Logging level to 7 here.

Step 4 : Sometimes we used to define the Log Level in Initialization Blocks.

Go to Variables–>Session–>Initialization Blocks–Log Level.

Edit the Data Target and set the Log Level to 7.

 

By bidevatapraveenkumar Posted in OBIEE 11g

Rename Apply Button In Prompts-OBIEE 11g

Requirement: Rename Apply Button in OBIEE 11g:

Steps followed:

Step 1: Go to /uo1/Middleware/Oracle_BI1/bifoundation/web/msgdb/l_en/messages and locate the file viewmessages.xml.

Step 2: Edit the viewmessages.xml file and find for the tag <HTML>Apply</HTML> and replace “Apply” with “GO”.

Step 3: Restart the Services.

Step 4: Login in to verify your changes. Now we can see the Apply Button changed to GO button after successful restart.

By bidevatapraveenkumar Posted in OBIEE 11g

BI integration with Web Services/ADF components

In order to integrate the BI Reports with Web Services / ADF components we have to download Oracle Extensions and update in the JDeveloper.

We can get the extensions from  http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/131167.xml#bi-adf-taskflow-extensions

The Extensions we have to download are:

bi-adf_bundle

bi-vo_bundle

bi-jbips_bundle

bi-adf-taskflow-extension_bundle

bi-adf-taskflow-extension_bundle

Installing the Downloaded Extensions:

Step 1: Copy all the Downloaded extensions to a local folder.

Step 2: Go to Help and click on Check for Updates.

Step 3: The Update Screen appears and Click on Next.

Step 4: Click Install from Local File and Browse for the downloaded Extensions and Click on Next.

Integrating BI Reports in to JDeveloper:

Step 1: Create a New Application.

Click FileàNewàApplications.

Click on Generic Application.

Step 2: Give the Project Name and Click on Finish.

Step 3: Right Click on the Created Project and Click on Project Properties.

Click on Libraries and Classpath.

Make sure that all these Classpath Entries are available.

JSP Runtime

MDS Runtime

BI ADF Runtime true BI JDBC

BI Data ControlRuntime

BI JBIPS

BI JDBC

BI SOAP Connection Runtime

BI View Object Runtime

If the Libraries and Classpath are not available then Click on Add Library and select the specific extensions. Click OK.

Step 4: Click on Technology Scope in Project Properties and make sure that Business Intelligence View ADF Components are selected or not.

Step 5: In Application Resources Click on ConnectionsàNew connectionàBI Presentation Sources.

Give the Host and Credentials and Click on Test Connection.

Step 6: Create a new jsp Page and drag the reports which we want to show in the pages.

Step 7: After doing drag and drop of the specific reports right click on the Project and click on Make Project. Then Click on Run.

 We can get the URL after clicking on Run for the specific Project.

 

We can get the report on Target URL which is published while running the specified Project.

 

Installation of JDeveloper 11.1.1.5.0 in Windows

Installation of JDeveloper 11.1.1.5.0:

Step 1: Download the software from the http://www.oracle.com/technetwork/middleware/fusion-middleware/downloads/index.html.

Step 2: Start the Installation.

Step 3: Click on Create a new Middleware Home and give the path where to install.

Step 4: Click on Custom Installation and Click Next.

Step 5: Check the Installation Directories Path.

Step 6: Check the Node Manager Listen Port and Click on Next.

Step 7: Select the “All Users” Start Menu folder and Click on Next.

Step 8: Now the Installation of JDeveloper 11.1.1.5.0 starts.

Creation of Flex Reports and Integrating it to OBIEE

Development of Reports Using Flex :

Create a report in BI Answers

Go to Advanced Tab and copy the SQL  Issued and save the report.

Open BI Publisher and create a new folder.

In the created folder now Create a new report.

In that report create Click on Edit and create a New Data Set1and check the Data Source name.

The Data Source used here should be equal to the Data Source used in the BI Answers.

Now create a New List of Value and copy the same Sql in to it.

Now go to Layouts and create a New Template in Layouts

Click on Layouts and Generate a New Template.

 

Click on Save button on the Top most left.

Now Click on View.

The data will be displayed in the default HTML format.

Now change it to Data and click on View now we can see the data in XML format.

Click on Export and save that XML file.

Creation Of Flex Project:

Now Open flex and Create a New Flex Project.

Now paste the XML in the new project.

Code for Column Chart:

Save the report by using the save button on the top most left.

Then Run that mxml file by using the run button the top most left.

Then you can get the output in the separate browser.


We can see the output in my documents under Flex Builder 3 under the given project name.we can find the .swf files in debug folder and .mxml files in src folder.

Integrating FLEX Report to BI Answers:

For integrating the FLEX Report to BI Answers first of all we have to bring this report to BI Publisher.

Open BI Publisher create a folder under that folder create a new report.

We can modify in the report which we created previously.

Go to Layouts and create a new template.

Browse to the swf file which we created just now and upload it.

Click on New Template and change the template type to Flash Template then save the report.

Then we can see the output in the Flash format.

Now go to BI Answers and open theDash Boards.

Browse to the Flex report which we created in BI Publisher.

Then we can view it in the BI Answers.

Code for PIE Chart:

Code for LINE Chart:

Code for Advanced Data Grid:

Linking of Prompts to Flex reports:

Create a new prompt in BI Answers.

Open BI Publisher and create a new Data Model

Now create a New List of Value.

Now create a new parameter.

In New DataSet we had given the name as dn now we have to call the name in the prompt under presentation variable.

Now go to Layouts and upload the Flash template.


Click on Save and View then we can see the Flex report based on the prompt.

Open BI Answers and include the prompt and flex report in to it.

Then we can see the data changes according to the given prompt condition.

By bidevatapraveenkumar Posted in Flex

Eventually succeeded, but encountered and resolved errors in Agents OBIEE 11g

Facing error in Agents OBIEE 11g:

Eventually succeeded, but encountered and resolved errors in Agents OBIEE 11g:

Step1: Create a new GMX account.

Go to http://www.gmx.com/ and create a new user.

Step2: Login to Enterprise Manager by using the credentials.

http://&lt; bi server >:<7001>/em

Go to Business IntelligenceàCore ApplicationàDeploymentàMail.

Use the SMTP Server, Port, Username and Password as mentioned below.

Step3: Click Apply and Activate Changes.

Step4: Click Restart to apply recent changes.

Step5: Schedule a report.

Scheduling of report can be shown here.

https://bidevata.wordpress.com/2011/11/25/scheduling-agents-in-obiee-11g/

By bidevatapraveenkumar Posted in OBIEE 11g

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.

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