Diary of a Confused DBA…..

SAP, SAP Basis, Database – Installation, tuning and real experience sharing

5. BI 7 post to post install – Journey of Basis to BI admin

with 2 comments


After a long time I am back once again to share my notebook pages. I remember once almost 3 yrs back I faced an Oracle DBA interview, who asked about the index organisation in a star schema – fact table.
Frankly that was the first moment when I realised that even if I gathered a long experience on Oracle database but I have no or very little idea about the data warehousing and business intelligence. In fact I didn’t get a chance to work or understand this as there was no such setup available. It was one day in April 2009, in a lecture session I learned that there are something called technical content in BI, which helps you keep track the on the behaviour and performance of the BI cubes defined and being used. The man presenting the session also told that once the BI technical content is configured and activated faultlessly, performance of the cubes and other BI business objects can be seen right from the transaction ST03n. As I am always interested about tuning of large database , this triggered my wish to learn tuning of a data warehouse in some form or other.
So you understood that this page will tell you in detail the how to activate and use the BI technical content.Although the same is available from different other Internet document source but here I recorded in detail the difficulties I faced in this job along with the screen shots and the different valuable  resources.

Generate BW Technical Content in SPRO

Generate BW Technical Content in SPRO

So What I did actually? for activation of the BI technical content you need to go thru the following path in the SPRO. Refer to the image above for the same.

SPRO->Display IMG->SAP NetWeaver->Business Intelligence->Settings for BI Content->Business Intelligence->BI Administration Cockpit->Activate Technical Content in SAP NetWeaver BI.

And as soon as I did the same , to my dismay and a mouthfull of bitterness, I landed up in the log screen with a huge nos of red bullets ..i.e. error messages. So what was the path? What I saw? Refer to the screen below.

Although the proverv goes failures are the pillars of success the real fact of life is nobody wants to fail…in the mission……..
I have yet to update/insert  all the screenshot in this page.

Written by soumen

July 7, 2009 at 4:28 am

2 Responses

Subscribe to comments with RSS.

  1. hii
    its really great can u tell me what is ddic password wn i am selecting all software unit during installation is it is 19920706 or a master password which i have given during installation

    waithing for reply

    regards
    amit mishra

    AMIT

    September 26, 2009 at 7:44 am

  2. Dear Amit,

    This is the master password you gave during installation.

    Thanks and regards,

    Soumen

    soumen

    September 30, 2009 at 1:23 am


Leave a Reply