SAP WebI 4.2 Commentary Service

[Former Member]

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.

[abarros123]

It works!!!

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

[abarros123]

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!

[Verakso]

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.

[Former Member]

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?

[former_member182521]

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