Skip to Content
avatar image
Former Member

SAP WebI 4.2 Commentary Service

Hello BI experts,

I'm facing an issue with the commentary service now available in the 4.2 version of the SAP BI Platform.

Steps I went through to be able to use the commentary feature:

- Created a dedicated APS for the commentary service,

- Assigned the appropriate rights at both the application and the folder level,

- Configured the commentary service to use the AUDIT DB (SQL Anywhere) and Created a 32-bit ODBC driver to point on the same database.

As of right now, the commentary service is not greyed out in WebI no more; however, I receive an error message when I try to insert a comment (WIS 00083) and thus no entry inserted in the database.

If you have already faced this issue, please provide some help !

Thank you in advance for your support.

Cheers.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 15, 2016 at 07:24 PM

    Did you add the Commentary Service in one of your APS?.

    Check here for the step by step configuration

    http://visualbi.com/blogs/business-intelligence/extending-bi-4-2-commentary-feature-audit-schema/

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 16, 2016 at 12:49 PM

    Hi Manikandan,

    Thanks for the prompt reply.

    I actually created an APS dedicated to serve the Commentary Service, but I still encounter the same problem.

    Any other clue of why woudn't it still work?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2016 at 01:56 PM

    Maybe I remember it wrong, but if you plan to use Commentary and store it in the Audit DB, there is no use to setup and create a new driver for that, if you already had Audit DB enabled.

    You should only create a new connection if you where planning on storing the commentary in another database, which there seems to be some different opinions from SAP whether this is the best practice or not.

    Unfortunatly, I my self had not been successfull in trying to create and use a seperate database for comments, so I have been using the standard "Use Audit DB" option and that should work fine.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2017 at 12:26 PM

    We are still having the same issue we have tried the following thing:

    -We have copied the DB from 64 to 32 bits (Adaptative Server Enterprise)

    -We have created a dedicated APS server.

    -We are using an Audit Server type Sybase.

    At this moment we have the "Use Audit DB" option enabled so the system should use the Audit DB to store the Comments.

    Did you know any other solution?

    Thank you in advance!

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2017 at 03:03 PM

    It works!!!

    Once you create the ODBC you must execute it in the Interactive SQL!!

    Add comment
    10|10000 characters needed characters exceeded