Skip to Content
author's profile photo Former Member
Former Member

What is the concept of scale in BPC?

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

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 30, 2010 at 03:02 PM

    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)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2011 at 11:52 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.