Skip to Content
avatar image
Former Member

Best Practices for Creating OLAP Connection (BICS) in IDT

I have created several OLAP Connections (via BICS) for a Crystal Report I am building.  I don't have any issues creating the connection, rather a question regarding best practices when creating the connection, specifically the supplied userID and password.  We are using SAP authentication and do not have SSO configured.  When I first started creating my connections, I was supplying my own BW userID password and everything was fine.  My concern is that if my ID becomes locked, or my password must be changed, there will be issues (most likely errors) due to the fact that my own BW credentials have been supplied in the connection information.  I would have to go into each connection and change the credentials to the new PW.  To get around this issue we created a system user ID in BW (system ID's pw's don't expire) and then I changed my connections to use this ID instead of mine.  The issue here is I can't connect to the BW data with this user ID.

Has anyone run into this issue, and if so any ideas on how to remedy?

Thank you.

Josh Dunlap

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 14, 2012 at 10:11 AM


    I believe it has to be a BW dialogue user.

    The BI4 Administrators guide will also outline the roles required.

    by the way, this can't be considered a best-practice, because data will be secured according to the credentials of this hardcoded login. it's OK for development, but wouldn't be adequate for Production data security.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Marianne,

      Thank you for the info.  I agree with you that SSO is probably the best approach.  I hadn't tried that yet but just created a connection using SSO and it was pretty seamless. 

      Thanks again!

      Josh Dunlap

  • Sep 06, 2012 at 07:50 PM


    Do you have the new user id assigned in BO?. and assign rights



    Add comment
    10|10000 characters needed characters exceeded