Transitioning to a New World – An Analytical Perspective

Recently, I had the opportunity to speak at the Silicon India Business Intelligence Conference. The topic I chose for the discussion was focused on providing the BI & Analytics perspective for companies transitioning to a new world. You can view my presentation at this link –http://bit.ly/VLDDfF

The gist of my presentation is given below:

1)      First, established the fact that the world indeed is changing by showing some statistics:

• Data Deluge: Amount of digital data created in the world right now stands at 7 Zettabytes per annum (1 Zettabyte = 1 Trillion Terabytes)
• Social Media: Facebook has touched 1 Billion users which makes it the 3^rd largest country in the world
• Cloud: Tremendous amount of cloud infrastructure is being created
• Mobility: There are 4.7 billion mobile subscribers which covers 65% of world population

2)      Enterprises face a very different marketplace due to the profound changes taking place in the way people buy, sell, interact with one another, spend their leisure time etc.

3)      To ensure that BI can help business navigate the new normal, there are 3 key focus areas.

• Remove Bottlenecks – Give business what they want
• Enhance Intelligence
• End to End Visibility by strengthening the fundamentals

For each of the 3 areas mentioned above, I gave some specific examples of the trends in the BI space.

1)      For Removing Bottlenecks, the impact of in-memory and columnar databases were elaborated.

2)      For enhancing intelligence, working with unstructured data and using big data techniques were discussed.

3)      For the 3^rd point, the focus was on strengthening the fundamentals in the BI landscape.

Please do check out my complete presentation at http://bit.ly/VLDDfF and let me know your views.

Thanks for reading.

Missing script for OBIEE Upgrade (7.8.5 to 10.1.3.3.1)

I did OBIEE upgrade with the help of the document Oracle® Business Intelligence Applications Upgrade Guide Version 7.9 February 2007 b31980.pdf
It was configured successfully but I encountered an error in the process of the final testing by running the provided out of box workflow through informatica. The workflows failed showing an ‘INVALID IDENTIFIER’ error indicating that some of the columns in the warehouse tables were missing. Hence I referred the document again.

As per the document the, warehouse Schema has been upgraded with the following mentioned scripts:-
UPGRADE.ctl script.
790_UPGRADE_PRE_CTL_SCRIPT.sql script.
DW.ctl script.
790_UPGRADE_PRE_DIMENSION_SCRIPT.sql script.
Though the above mentioned scripts were successfully executed, the workflows failed with the same error ‘INVALID IDENTIFIER’
Hence I figured out that one more script is required to resolve the above problem.
So after running the script placed at OracleBI\DAC\conf\sqlgen\ctl-file\ oracle_bi_dw.ctl
(DDLimp utility) the issue was resolved.
This script contained all the missing columns.
To run the Script use the following command:-

Here DDLimp is the utility provided by Siebel to run this Script.
Execute the following Command in the CMD Prompt:
—-DDLimp /U USER /P PASSWORD /C <Connect string i.e. system DSN> /G SSE_ROLE /I N /R Y
F <Path for the oracle_bi_dw.ctl Script>/L (location where you want to store log file)

Where,
U is Database Table owner name.
P is Database Table owner Password.
C is System DSN.
For G, I and R use the Default as given.
F indicates the path of the Script.
L indicates the path were the log file is to be stored.
Finally to my relief the upgrade completed by running the above mentioned script!

Inputs from Alok Chowdhary

Read More about OBIEE Upgrade