Questions with BPC Features

[Former Member]

Hi ALL,

I'm writing to ask a few questions of some features I expected to have with BPC, but yet I could find any of them.

I'm using BPC MS 10.0 SP11.

1. Can I know if there is any way to "lock" those cells in Input Templates which are "Calculated Only" or "Read Only" to users?
I found that there is "NO warning messages" when users enter any numbers in those "Calculated Only" or "Read Only" cells. And so, users will that their inputted numbers got cleared or re-calculated after saving her data, but with no idea why.

2. I know there is a feature to add comment to explain the number in Input Templates. Just, after adding the comments, there is no way to recognize there is actually comment entered in the Input Templates but only to go to "Web" to generate a report to review them. Is there actually a way to enable users recognizing those cells with comments entered?

3. I did use the function "EPMContextMember" to create some report headers for providing more information to users. Just, I can only show "Member Name" using this function but not its "Description". By how I can do that?

Appreciated any input!

Antony

[Former Member · Accepted solution]

Hi ALL,

For question 1, I have just found that I have to right-click the cells in "EPMFormattingSheet" and select "EPM" -> "Locked Selected Cells" to apply the Cell Locking function.

Still, I got a supplementary question with cell locking.
Provided if one has submitted her data by changing the Work Status, anyway to "Lock" those cells provided if she has no more rights modifying the numbers?

Question 2 and 3 remains open.

Cheers!

Antony

[Former Member · Accepted solution]

hi Antony,

Question 2:

You can use EPMCommentFullContext and EPMCommentPartialComment to retrieve the comment.

Or you can check Show as Microsoft Excel Comments to get the comments corresponding to a data region as a excel comment.

Question 3:

=EPMContextMember(Connection name, Dimension,Filter,Context member name)

the fourth parameter i.e Context member name if you set it to false it will get only ID of the member. it is set to true it will get member name as it is  displayed in the Context bar.

For more details use:

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

regards,

Shalini

[Former Member · Accepted solution]

Hi Shalini,

For question 3 it is solved! Thanks!

And for question 2, still, after enabling the "Show as Microsoft Excel Comments", I still could not see any recognition of the cell showing there is comment (guess there should be a red flag on the top right corner of the cell?).

Could you show me the details of doing so?

Antony

[Former Member · Accepted solution]

hi Antony,

It will come as a red flag with comments on the data cell associated with the specific data region where the comment is saved. You need to just enable Show as Microsoft Excel Comment option.

See the details in Page number 144-145 of the pdf :

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

You can get help from EPM Addin Help document button also.

You can try EPMCommentFullContext and EPMCommentPartialComment functions also to get the Comments.

I dont think so there is way to lock the data cell based on the workstatus.

Regards,

Shalini

.

[Former Member · Accepted solution]

Hi Shalini,

Unfortunately, after enabling that "Show as MS Excel Comment" option, still, after I save the comment, it doesn't come with the red flag tho I can retrieve the comment in Web.

Any hints?

P.S. Thanks for answering on the WorkStatus Lock. I just wonder how user will know if he/she cannot enter data coz of the WorkStatus then.. How you handle it in your projects?

Antony

[Former Member · Accepted solution]

hi Antony,

I am not sure why "Show as MS Excel Comment" is not working.

You can use EPMSaveComment as well to save and fetch tha comment if required.

Also i have not come across any scenario where we had to lock the data cell based on workstatus.

Regards,

Shalini

[Former Member · Accepted solution]

Hi Shalini,

In my newly installed machine, the option is finally working perfectly!

Thanks for your help and I will close this case.

Antony