Skip to Content
0

SAP WebI 4.2 Commentary Service

Nov 15, 2016 at 01:57 PM

624

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Manikandan Elumalai Nov 15, 2016 at 07:24 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 16, 2016 at 12:49 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Thomas Nielsen Nov 16, 2016 at 01:56 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Andrés Barros Dec 20, 2017 at 12:26 PM
0

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!

Share
10 |10000 characters needed characters left characters exceeded
Andrés Barros Dec 20, 2017 at 03:03 PM
0

It works!!!

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

Share
10 |10000 characters needed characters left characters exceeded