Tag Archives: ALL POSTS

OBIEE This is the end?

…..not really, but ….

 As most of you might have notice my activity’s in the OBIEE community have been minimal during the last year or so.
How come?
I have accepted a new challenge in becoming the team lead for Microsoft BI at Ciber in the Netherlands .
This means I have little to none time left for OBIEE blogging.  And thinks like visiting the Rittman-Mead conference in Brighton this year are sadly also out of the question.
I will be closing the possibility of adding comments / question on this blog because I don’t have any time left to filter out the spam.
I hope to pick my OBIEE and other blogging activities up in the future but for now:
Good luck and hope to see you again!

Till Next Time

John

OBIEE en JDev in the same FWM home

Don't do it, it screws up your OBIEE weblogic instance.........

(especially when you are preparing for the Brighton 2012 BI congress.......)

8-(

Till Next Time

OBIEE install avoid RTD license problems

If you are not going to use RTD (Real Time Decisions) uncheck the box during installation:

image

This avoids extremely difficult discussions with Oracle over the license fee.

Till Next Time

OBIEE 11116 repository on MS-SQL I

We had to do a POC on some MS-SQL data. Instead of bringing an extra Oracle DB we used an existing MS-SQL instance.

1. Create a repository database:

We called ours “Repositories” Winking smile

image

2. Enable case-sensitive collation

ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS

3. Enable Row versioning

ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON

 

4. Allow TCP/IP access to the database:

image

(Bounce the service if you changed it!)

4b. If you have a firewall running check if the ms-sql port is open (1433 for a default instance)

5. Create a user (fi: REP_OWN)

image

6. make  the default database repositories:

image

7. Set the public and sysadmin role:

image

Now we can start with the actual repository:

8. Download and unzip de RCU.

9. Start the RCU.bat (..\rcuHome\BIN)

10. On the database connection details page:

image

11. Select the BI components:

image

12. Enter the passwords

image

13. Succes:

image

image

14. You can disable the REP_OWN account, the RCU has create dedicated logins:

image

Till Next Time

See you in Brighton !

Want to know if  the White Stork really brings the babies? See me and many others speak at the Rittman Mead BI-Forum http://www.rittmanmead.com/biforum2012

See you in Brighton!