OBIEE 12c : Oracle Public URL for OBIEE 12c and OBIEE 11.1.1.9

Now its time for all of us to look at the new version of OBIEE and start upgrading. The thing about upgrades is we cannot commit to it until we see what our existing reports will turn out into. Thats the major thing for the users to approve the upgrade projects as they are afraid of something going wrong and also people fear change. But as everyone with brains say CHANGE IS GOOD, lets say the changing to OBIEE 12c is good. Here is the public url for accessing the OBIEE 12c Analytics


OBIEE 12C-

              http://sampleappv805iappl-wikiv80512214publi-gtshuiz7.srv.ravcloud.com:7780/analytics

           Credentails : prodney/Admin123

               http://sampleappv607i1221-wikiv60712212publi-cc8ssyta.srv.ravcloud.com:7780/analytics


            Credentails : Prodney/bitech#1


..

Informatica : Generating CSM from command line

When ever we raise a case with Informatica , it is a general practice to send the CSM file which will have the details of the environment , Informatica Version, OS etc which will help the case engineer to analyze the issue faster.

Some cases the CSM generated from the tool might not be correct as we might be using a client etc. So we might have to generate the same from command line where the Informatica server is installed.

Below steps will help you in getting the file from command line. In all the cases the user who runs the command should be the one who starts the service.

For UNIX 

Navigate to the below location from the command line

INFA_HOME/server/csm 

cd $INFA_HOME/server/csm

./csmagent

Informatica CSMAGENT, Version [1.0]
Invoked at Mon Jul  1 00:22:13 2013

Logging to file csmagentHOST.xml
AdminUser name:Administrator
AdminPassword for User Administrator:Administrator
Collecting information for :

     OPERATING SYSTEM...Done
     USER ENVIRONMENT...Done
     PMSERVER...Done
     ORACLE...Done
     DB2...Done
     SYBASE...Done
     INFORMIX...Done
     ODBC...Done

 Send the output file to Informatica Technical Support.

 A file named csmagentHOST.xml will be created, that may be attached to the project csm/Informatica service request

For Windows

The csmagent in INFA_HOME\server\csm\ can be run to get the  of Informatica node installation. You must run csmagent.exe. For more details refer the following:


      %INFA_HOME%\server\csm>csmagent
      Informatica csmagent, Version [1.0]
      Invoked at

      Logging to file INFA_HOME\server\csm\csmagentHOST.xml
      Collecting information for :


                OPERATING SYSTEM ...Done
                USER ENVIRONMENT ...Done
                PowerCenter Server Cannot be found on this machine.
                PCCLIENTS...Done
                ORACLE...Done
                DB2...Done
                SYBASE...Done
                INFORMIX...Done

      Please send the output file to Informatica Technical Support.
      Please hit return to exit...

 
A file named csmagentHOST.xml will be created in the same directory where csmagent.exe is run. It will be attached to the project csm/Informatica service request.

Virtual Machine : Not enough Physical Memory is available to power on

Hi Guys,

Most of us use VM's to practice different tools in our personal machines. Today i just observed an issue where my VM's struck and when i tried to restart i received the below error.

I did some research and found that this is because of a windows update on Windows 8 and above versions . By the way i'm using Windows 10 and VM build 10. The VM is with Windows 7 64 bit and 4 GB ram.

Go to Control Panel -> Programs -> Programs and Features, then select View installed updates at the top left corner.

Locate Update for Microsoft Windows (KB2995388) and uninstall it. This is a optional update for Windows 8 and above.



Please restart the machine and try accessing the VM now it should work just fine.

Oracle Apps : XXX Not a valid responsibility for the current user. Please contact your System Administrator

It's very good to say that i have started working now on Oracle Apps, of-course i am not doing any hardcore work but just sharing few activities to just get some knowledge. We recived one request from one of the users saying he is getting a weird error when trying to login to the Oracle Apps.

The error says "XXX Not a valid responsibility for the current user. Please contact your System Administrator".

I have done some research online at last found one that solved my issue.

Cause:

This happened because the user responsibility has been updated but middle tiers has yet to pick the change in assigned responsibility. To resolve this issue we need to clear the middle tier cache.

Resolution:

1) Login with System Administrator Responsibility
2) Navigate to System Administrator> Profile > System, click on User and enter the user name
3) Search for profile 'Applications Start Page'. Delete the value set at user level and save
4) Go to Functional Administrator -> Cacheing Framework > Clear All Cache
5) Try logging into the account and try again

MS Excel : Split multiple sheets of One Workbook into Separate Workbooks

In continuation to my previous post on Split data into different sheets based on a column , we will now see on how to split the Workbook with multiple sheets into separate workbooks with sheet names as workbook names.

One we have completed the data split as per my previous post, we are left with a workbook with multiple sheets , each sheet will have data related to a USER and the sheet names are the respective USER_ID's.

Now save the workbook with some name and open the macro editor.

1. Press ALT+F11 , to open macro editor
2. Under Insert , Click on Module
3. Please paste the below code in the module 
4. Press F5 to run

Sub Splitbook()

Dim xPath As String

xPath = Application.ActiveWorkbook.Path

Application.ScreenUpdating = False

Application.DisplayAlerts = False

For Each xWs In ThisWorkbook.Sheets

    xWs.Copy

    Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xls"

    Application.ActiveWorkbook.Close False

Next

Application.DisplayAlerts = True

Application.ScreenUpdating = True

End Sub

This code will split the sheets of one workbook into multiple workbooks with sheet name as workbook name in the same folder of the original workbook.

MS Excel - Split data from one sheet to different sheets based on a column

Recently we have had a small issue with the BI Publisher and we had to run a report manually and implement the Bursting technique somehow to split the data generated by the Data Model ,so that we can email the report to the respective Users.

We ran the SQL used in the data model against the EBS  and was able to get the data for all the users.Now the primary agenda here is to split the data on user basis and send them their data respectively.

Lets say my Excel Workbook has one sheet "Sheet1" and has the below columns

USER_ID 

USER_NAME

USER_EMAIL

USER_CITY

USER_COUNTRY

CALENDAR_DATE

USER_ACTIVITY

We have two steps here 

1. Split the data from Sheet1 into multiple sheets based on USER_ID in the same workbook
2. Split the created sheets of workbook into separate Excel workbooks

This can be achieved  by using macros. Lets see how the first step can be done.

• Open the Excel Workbook, Press [ALT+F11] which will open Macro editor
• Under Insert tab, Click on Module
• Paste the below code in the Module window.
• Make sure the highlighted columns are edited as per your requirement.

"vcol " should be column number based on which the split will happen

"Set ws = Sheets("Sheet1")" is sheetname in which the data is available  

title = "A1:G1"  is the headings - my case it's 7 so G.

• Once the code edit is done , Press F5

Macro to be used

Sub parse_data()

Dim lr As Long

Dim ws As Worksheet

Dim vcol, i As Integer

Dim icol As Long

Dim myarr As Variant

Dim title As String

Dim titlerow As Integer

vcol = 1        

Set ws = Sheets("Sheet1")        

lr = ws.Cells(ws.Rows.Count, vcol).End(xlUp).Row

title = "A1:G1"           

titlerow = ws.Range(title).Cells(1).Row

icol = ws.Columns.Count

ws.Cells(1, icol) = "Unique"

For i = 2 To lr

On Error Resume Next

If ws.Cells(i, vcol) <> "" And Application.WorksheetFunction.Match(ws.Cells(i, vcol), ws.Columns(icol), 0) = 0 Then

ws.Cells(ws.Rows.Count, icol).End(xlUp).Offset(1) = ws.Cells(i, vcol)

End If

Next

myarr = Application.WorksheetFunction.Transpose(ws.Columns(icol).SpecialCells(xlCellTypeConstants))

ws.Columns(icol).Clear

For i = 2 To UBound(myarr)

ws.Range(title).AutoFilter field:=vcol, Criteria1:=myarr(i) & ""

If Not Evaluate("=ISREF('" & myarr(i) & "'!A1)") Then

Sheets.Add(after:=Worksheets(Worksheets.Count)).Name = myarr(i) & ""

Else

Sheets(myarr(i) & "").Move after:=Worksheets(Worksheets.Count)

End If

ws.Range("A" & titlerow & ":A" & lr).EntireRow.Copy Sheets(myarr(i) & "").Range("A1")

Sheets(myarr(i) & "").Columns.AutoFit

Next

ws.AutoFilterMode = False

ws.Activate

End Sub

For splitting the multiple sheets into separate Workbooks please refer here

Unable to start bi_server1 after changing the listening port to 80

We recently tried changing the listener port of the analytics web application from 9704 to 80 using the WebLogic Administration Console. When we tried the restart of bi_server1, the BI Services now fail to start successfully.

When we tried the log files to see what is causing the issue , we found the below error.

After some investigation we found the issue was caused because we didn't perform the system reboot.On the whole below are the steps performed to change the port.

Port Change in Console

Change the Analytics port number from 9704 to 80 following the instructions given in the Configure Listen Ports section of the Oracle Fusion Middleware Oracle WebLogic Server Administration Console Online Help 11g Release 1 (10.3.3) Part Number E13952-03.

Here are the steps:

• Log in to WebLogic console: http://servername:7001/console.

• Go to Environment -> Servers. Click on Lock and Edit button -> Configuration tab -> click on bi_server1 link -> set Listen Port: to 80 -> click on Save.
• Click on Activate Changes button.

Stop the instance:

• Stop the OBIEE components from command prompt:

[FMW_HOME]\instances\instance1\bin\opmnctl stopall

• Stop the Managed server from GUI. Access the weblogic console from a browser (replace "hostname" by the machine name):

http://[hostname]:7001/console

• Log in, Environment -> Servers -> Control -> select bi_server1 -> click on Stop. It will take some time for the Managed server to stop.

• Stop the Admin server from GUI. Access weblogic console from a browser (replace "hostname" by the machine name):

http://[hostname]:7001/console

• Log in, Environment -> Servers -> Control -> select AdminServer(admin) -> click on Stop. It will take some time for the Admin server to stop.

• Stop the Node Manager. Go to Windows Services and stop "Oracle WebLogic Node Manager".

• Reboot the machine. This is required. If you attempt to restart the BI instance without rebooting the machine, it will fail.

Start the instance:

• Start NodeManager. Go to Windows Services and start "Oracle WebLogic Node Manager".

• Start the Admin server from command prompt:

[FMW_HOME]\user_projects\domains\bifoundation_domain\bin\startWebLogic.cmd

It will ask you for the user name and password. Specify the user details that you have mentioned at the time of the 11g install.

Wait until you see a message that the Admin server is in running mode.

• Start the Managed server from GUI. Access weblogic console from a browser (replace "hostname" by the machine name):

http://[hostname]:7001/console

• Log in, Environment -> Servers -> Control -> select bi_server1 -> click on start

It will take some time for the Managed server to start. Wait until you see Running status.

• Start the OBIEE components from command prompt:

[FMW_HOME]\instances\instance1\bin\opmnctl startall

Note: You many want to change the port number in the start up scripts provided when OBIEE is installed. Those scripts are static and port number needs to be updated manually there.