EvCOM

The EvCOM function references another cell and sends its value, a textual comment, to the database when specified.

EvCOM(CommentRange,AppName,Member1,Member2,and so on)

CommentRange — The cell reference of the input cell.

Insert AppName

Insert Member1–N

 

How to Add Comments in BPC

BPC Elite is coming to Europe - Aug 1-5, 2011 in Walldorf

After I have gotten many requests from various of our European partners, it is finally happening: BPC Elite Partner Enablement is coming to Europe - thanks to Thomas Pfiester from the EPM Practice in EMEA.


From August 1-5, 2011, BPC Elite will be hosted at the international headquarters of SAP in Walldorf, Germany. Pre-register here!

The planned agenda is very similar to the BPC Elite sessions held in Palo Alto and Shanghai before. The main difference is that the training is condensed into one week rather than 2 full weeks.

MONDAY	TUESDAY	WEDNESDAY	THURSDAY	FRIDAY
Introducing Overview and Features	BW Concepts	Consolidation Concepts	EVDRE Best Practices and Run Time Tracing	EPM 10
			Script Logic Tips and Tricks	Exam
EPM Road Map	Process Automation	Planning Concepts	ABAP and BAdI Usage
SAP SAP BusinessObjects Planning and Consolidation Delivery	Transports and Lifecylce Management		Performance Tuning

On Monday and Wednesday are social events incl. dinner


BPC Elite veterans Sheldon Edelstein and Bruno Ranchy from the US will join the EMEA team to help make this first EMEA Elite enablement session as successful as the previous four. For feedback from previous sessions see: http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24376

SAP BPC 10.0 NW MEGA ELITE Enablement

Dates: Monday, November 14th at 8 a.m. to Friday, November 18th at 3 p.m.

Registration begins: 8 a.m.
BPC Jumpstart Session: 9 a.m.
Event Kick-off: 10 a.m.

Location:
SAP Newtown Square
3999 West Chester Pike
Newtown Square, PA 19073
Phone: +1-610-661-1000

Training fees: $1,950 USD/per person.

More information: http://www.kcimanagement.com/clients/sap/11440/reg/reg-en.html

Hierarchies , Parenth1, Parenth2, . . .Parenthn

How hierarchies are treated in MS version of BPC.

1. There is no hierarchy in MS version of BPC.
2. Hierarchy is treated as BW hierarchy.
3. Hierarchy is treated as a measure.
4. Each hierarchy is treated as a separate dimension in the DB.
5. The correct answer is separate dimension in the DB. So keep the hierarchies minimum in MS version.
6. You can have more than one hierarchy for the same dimension.
7. To define a hierarchy add the Paranet property as a column directly in a dimension member sheet via Maintain Dimension Members.
8. Hierarchies should be named as ParentHn where n is the no of the hierarchy. For example if you have 2 hierarchies then you create as Parenth1 and Parenth2.
9. Hierarchies are stored as SAP Net weaver BW Hierarchies in BPC Net weaver version .
10. Hierarchies are stored as a separate dimension in MS version BPC.
11. The order of the hierarchies are not important like Parenth1,Parenth3,Parenth2.
12. But you should not skip a hierarchy like Parenth1, Parenth3.

Dimesions & Properties . . .

What is process Dimension functionality: When you create/change a dimension all the changes are updated to the database – BW cube. After you create the dimension you have to process the dimension in the BPC admin console to update the DB.

Dimension field names can be max 20 chars.

Dimension properties length if it is less than or equal to 60 will be stored as a BI attributes.

More than 60 will be stored as a string in BW.


There is no limit of the length of the properties.


In BPC you can only increase the size of the property and you can’t reduce the size. This is very important.


It is not possible to delete the member until it is deleted from all applications where it is used.Same as deleting the master data in BW.


If the property length is more than 60 it can’t be used in script logic calculations.

Renaming a existing member is not possible in netweaver BW. Copy and use it.