on 02-19-2013 1:04 PM
Hi Experts,
How can I upload comments in BPC 10 Netweaver SP8 using Flatfile?
Is there any guide or steps on how to do this?
Regards,
Jayson
Hey Jayson,
You can do that by writing an ABAP program.
Comment table follows a fixed naming convention. BPC automatically creates tables /1CPMB/XXYYYCMT and /1CPMB/XXYYYCMTA to store comments in SAP.
In order to see the comments table, you need Appset prefix(XX) and Application prefix(YYY), which you can get from tables like UJA_APPSET_INFO and UJA_APPL.
If you want to follow an easy approach try to debug class CL_UJC_CMTMANAGER and use method cl_ujc_cmt_dao->ADD_CMT().
Let me know if it worked.
Thanks,
Deepanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Jayson.
Could you solve your problem?
Was you issue save comments in a BPC report or during the initial load?
I am facing a similar probem, the client needs to load comments from excel, and obviously watch them in the reports. They load files every month and generally have comments in each one.
Greetings.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jayson,
Give the connection name in EPMSavecomment though it is optional , try it
Regards,
Shrikant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your replies.
Actually, I just want to Upload the comments that was created during planning session.
it is in an Excel, but our users need it to be uploaded and retrieved together with the corresponding Data.
I thought it was possible in BPC 10 NW. But based on your comments, it wasnt.
maybe you can help me on how can I make a dynamic comments with 3 dynamic dimension members in template.
Please see error below:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jayson,
There is no such out of the box tool in BPC.
Can you please elaborate how you envision it and maybe we'll be able to guide you how to achieve it.
Gersh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bishwajit,
There is no "out f the box", but there are always workarounds.
For example, one can run a DM Package that will call a script that has BADI which can write comments.
Another option can be, routine BADI in data loads.
Still main question is: how to map comments to "cells" they belong to? Comments can be assigned to Nodes, you can have multiple comments for one member, comments can have key words, etc.
When all those questions are answered then it will be easy to come up with a "simple workaround".
Gersh
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.