What is the concept of scale in BPC?

[Former Member]

Hello SAP Gurus, I have a basic question. what exactly is the concept of scale in BPC?

Thanks.

[Jeffrey_Holdema · Accepted solution]

For presentation of large numbers financial reports are often scaled to thousands or millions depending on the currency. In the account dimension we can use a property called "SCALING" and set it to Yes or No. Then in a BPC Excel report the "Get and Scale Value" function [EVGTS|http://help.sap.com/saphelp_bpc75/helpdata/en/ef/824d0b838a4c73bd460ec9d689607f/content.htm] can be used to display the numbers scaled to the factor specified within the formula.

Syntax

EvGTS(AppName,ScaleValue,[dim:]member1,[dim:]member2,[dim:]memberN)

AppName u2014 The name of the application. This is required if the corresponding dimension does not exist in the active application.

ScaleValue u2014 If the scale property in the Account-type dimension is Y, then EvGTS uses this value. If the scale property is N, this value is ignored. The scale value can be set to 1, 100, 1000, or 1,000,000. The default value in report templates is one (1). When the scale value is 1 (units), this function works identically like the EvGET function.

Member1u2013n u2014 You can specify as many members that you want. Any dimension not specified in the formula is taken from the current view. If you supply only the period and not the year, EvGET uses the year from the Category's YEAR property. For example, EvGET(Finance, Jan,Budget,GlobalMotors, Revenue,AllProducts) uses the year specified in the Budget category YEAR property. If that year is 2008, the example gets data for the period Jan.2008.

If the same member name is used in more than one dimension, you must specify the dimension name. Use this syntax: dimension:member.

Example

The following example returns $500,000.00 from the database and presents it in the report as $500:

EvGTS(Finance,1000,Account.Sales,Entity.Sales,Jan.20008,Budget

Thanks and best regards,

[Jeffrey Holdeman|http://wiki.sdn.sap.com/wiki/display/profile/Jeffrey+Holdeman]

SAP Labs, LLC

BusinessObjects Division

Americas Applications Regional Implementation Group (RIG)

[Former Member · Accepted solution]

Thanks , that clarified it a lot!!

[Former Member]

Hello Experts,

please, tell me some decision of using SCALING in EVDRE FormatRange.

I see only that EVDRE know ACCOUNT.SCALING=1 and don't know =1000 or =Thousands or...