Managing the Energy Data Management Profiles

Objective

After completing this lesson, you will be able to explain the use of the repository, interfaces, and monitoring in Energy Data Management.

Profile Import

Profile values can be imported using two procedures:

  • BAPIs (Business Application Programming Interface): Importing measurement data via a synchronous communication path (for example, a function call such as RFC).
  • IDocs (Intermediate Document): Importing data via an asynchronous communication path (for example, electronic data exchange).
Diagram showing SAP Data Model Elements for profile value import, including Business Partner, Connection Object, Installation, and Point of Delivery.

During profile value import, registers are identified by the following objects:

  • Point of delivery ID

    For example, DE2367093

  • Register code

    For example, EDM_TEST 1

  • Role category of a profile allocation

    For example, Measurement ( = 01)

  • Role of a profile allocation

    For example, Consumption measured ( = 0001)

You can use the File Upload app (via Point of Delivery) or File Upload via Profile app to import the profile data.

The following file types are available for profile value import:

  • ASC: ASCII
  • BIN: Binary
  • DBF: DBASE format
  • IBM: ASCII with IBM code page conversion (DOS)
  • WK1: Spreadsheet format
  • DAT: ASCII Data table with column tab
  • ISUPROFILE. Upload:

    You can use this BAPI to import profile values for a profile.

  • ISUPROFILE. Import:
    • You can also use this BAPI to import profile values.
    • The profile to be filled is determined by means of the point of delivery ID, the register code, the role, and the role category.

  • ISUPROFILE.Get:

    You can export a profile's values from the Energy Data Repository using this BAPI.

  • ISUPROFILE.GetfromPoD:

    You can also export profile values from the Energy Data Repository using this BAPI. Here, though, you can specify additional selection categories such as point of delivery, point of delivery ID, role, and role category.

Once the import process is complete, you can view the import status in the Profile Value Monitor app. A message informs the user whether or not the import was successful.

Monitor Profile Value Import

Information on the profile value import includes data about errors, such as corrected profile values, data about date and time, import data, for example, IDoc number and external reference, profile information, such as the Point of Delivery ID, and data about replacement value.

The following image shows examples of the data recorded:

A diagram of the data related to profile value import monitoring, including details about error, import, date/time, replacement value, and profile information details.

Profile Consistency Checks

Consistency checks check the profile values as they are imported into the system. Examples are:

  • Missing values
  • Out of range values
  • Overlapping values
Diagram showing consistency checks for overlapping, out-of-range, and missing time and value data.
  • Consistency checks are allocated to consistency check groups.
  • Consistency check groups are allocated in the profile header.
  • Profiles with missing values or periods can be imported if:
    • The missing values have the value "0" or
    • When a replacement value procedure group is specified in the profile header, the missing values are replaced with replacement values using the corresponding replacement value procedure
  • The missing values can be imported at a later date. The "0" values or the replacement values are overwritten with the actual values.

Consistency Check Groups

Diagram of consistency check groups: The following text provides the details

The example above shows three consistency check groups to which the following consistency checks are allocated:

  • Consistency check group 1: Performs the following check during profile value import:

    Overlapping values

  • Consistency check group 2: Performs the following two checks during profile value import:

    Missing values and out of range values

  • Consistency check group 3: Performs the following three checks during profile value import:

    Overlapping values, missing values, and out of range values

The Customizing path is as follows:

SAP Fiori app Home pageUser Profile iconApp FinderSAP MenuSearch in SAP MenuCustomizing- Execute ProjectSAP Reference IMGSAP UtilitiesEnergy Data ManagementInterface to External SystemsImport CheckDefine Consistency Check Groups for Profile Value Import

Profile Replacement Process

During the replacement value procedure, profile values are created to replace missing values.

Bar chart showing energy usage (kW) over time with missing intervals replaced through interpolation (midday on 5th May) and extrapolation (6th May).
  • The replacement value procedure is used for the following reasons:
    • Profile values do not exist for a certain time period (for example, due to a device breaking down or communication error).
    • To perform billing simulations for future time periods or for the creation of forecast schedules
  • First of all, the replacement value procedures are defined in Customizing. These replacement value procedure are then allocated to replacement value procedure groups. Replacement value procedure groups are allocated to a profile (in the profile header). This defines the replacement value procedures that are used to generate values for the allocated profile.
  • The replacement value group can be changed in the profile header after the profile header has been created.
  • Only the intervals with missing values are replaced. For example, if some intervals have values and others do not, the existing values are not overwritten.
  • It is only possible to generate replacement values for values with the status Value does not exist. (If the value is 0.00 but has a valid status, the value is NOT replaced.)
  • It is possible to delete values with the status Manually changed/extrapolated/interpolated using the Maintaining Profile Values app so that replacement values can be regenerated for these intervals.

Replacement Value Procedure

Bar chart showing power usage (kW) over time with missing values highlighted between 5th-6th May, illustrating the need to replace missing data.

Replacement value procedures are defined using the following input parameters:

  • Reference period
  • Reference profile
  • Profile role
  • Historical values: A time period is defined and historical values are taken from this period. These values can either come from a profile that requires values or from another profile (reference profile).

Error codes are defined for each replacement value procedure. These define all possible errors that can result from the procedures (for example, no historical data in the period required).

These replacement value procedures are allocated to replacement value procedure groups.

Replacement values are generated in the following scenarios:

Automatic interpolation during profile value import: You can activate the automatic interpolation of profile values during profile import. The procedures can also be activated from the Monitor Import of Profile Values screen (Menu: Edit -> Generate Replacement Values). Alternatively, use the button ....

  • Manual replacement of missing values using the profile values transaction
  • Interpolation and extrapolation can be executed using Execute mass changes in the profile values transaction
  • Automatic extrapolation using billing simulation
  • In the context of IS-U-Billing, it is possible for interval customers to execute a billing simulation based on the extrapolated profile values.
  • Replacement values can only be generated for the profile categories Quantity or Demand.

If the interpolation of missing profile values was executed automatically after the import of profile values, the event ReplacementValuesRequired for BOR object ISUPROFILE is issued. You use the replacement value event to define your own replacement value workflows, so that you can inform the person responsible that the interpolated profile values have to be checked or released, for example.

The following image shows examples of the Replacement Value procedure:

Example charts, each showing replacement value procedures: Linear distributes difference evenly, Maximum uses max value, Minimum uses min value around missing intervals.

There are eight replacement value procedures predefined by SAP. For profiles with only small amounts of data missing, values can be determined from the immediate environment (this means, the values before and after the missing values).

  • Linear replacement procedure: The difference between the last known value before the missing values, and the first known value after the missing values is distributed across the total number of missing intervals.
  • Maximum value replacement procedure: The missing values are replaced with the maximum value from the last known value before the missing values and the first known value after the missing values.
  • Minimum value replacement procedure: The missing values are replaced with the minimum value from the last known value before the missing values and the first known value after the missing values.
Diagram showing control meter replacement: copying missing values from Device 2's control register to Device 1's historical consumption profile.

CONTROL: Copy values from the profile of the control meter

Replacement Value Procedure Groups

Diagram showing Replacement Value Procedure Groups with procedures (HISTCOPY, MAXIMUM, MINIMUM) allocated to Group 1 for processing in SAP systems.

Multiple replacement value procedures can be allocated to a replacement value procedure group.

The replacement value procedures in a replacement value procedure group are prioritized, whereby the replacement value procedure with the highest priority is called first. If this replacement value procedure cannot replace the missing values (for example, due to missing environment data or data missing from a control meter), the replacement value procedure with the next highest priority is called (1 = highest priority, 9 = lowest priority).

The replacement value procedures in a replacement value procedure group are valid for a certain number of missing values.

If the number of values to be replaced lies between 1 and 3, for example, the values are replaced using the appropriate procedure.

The following parameters define replacement value procedures:

  • Replacement value procedure (mandatory)
  • Function module for replacement value creation: Replacement value procedures are implemented as function modules. Each replacement value procedure is allocated to a function module that creates replacement values. All function modules that you enter here must have the same interface as function module ISU_EDM_REP_METH_LINEAR.
  • Function module for determination of reference period: This function module is called during the replacement value procedure and determines reference periods for the profile such as seasons, day groups, and TOU groups. The function module provided by the customer allocates the profile from the RTP interface to the replacement procedure. An interface is defined in the sample function module: ISU_EDM_REF_TIME_SAMPLE.
  • Reference profile: This is a reference profile for the replacement value procedure.
  • Profile allocation role of the reference profile: This is a profile role for the replacement value procedure. You can allocate reference profiles indirectly using roles. During the replacement value procedure, the profile that is allocated to the interval meter with the specified role is transferred to the procedure.
  • Start of reference period: If the procedure is based on a historical profile, the values used come from the start of this reference period (yesterday, last week, last month, and so on).
  • Duration of reference period: Self-explanatory
  • Reference period corresponds to replacement period: If you select this field, the duration of the reference period corresponds to the duration of the replacement period. If you select this field, entries in the Duration of Reference Period field do not take effect.
  • Replacement value procedure valid for consumption/demand profiles: Every procedure must be valid for either consumption profiles or demand profiles or both.
  • Procedure valid for interpolation/extrapolation of profile values: Every procedure must be valid for interpolation or extrapolation or both.
  • Manual entries required for replacement value procedure: If you select this field, this replacement value procedure cannot be used for profile value import or billing simulation.
  • Description of replacement value procedure: Self-explanatory
  • Error codes for replacement value procedure: Defines the possible types of error that can occur when replacement values are created.

Each replacement value procedure group contains interpolation and/or extrapolation processes. The following parameters define replacement value procedures:

  • Definition of replacement value procedure group
    • Replacement value procedure group after profile value import: The procedure group is automatically called if the system determines that values are missing after a profile value import.
    • Replacement value procedure group valid for consumption/demand profiles: Every procedure group must be valid for either consumption profiles or demand profiles or both.
    • Description of replacement value procedure group
  • Allocation of replacement value procedure to group
    • Replacement value process: Interpolation or extrapolation of profile values
    • Priority of replacement value procedure (RVP) in RVP group: This field defines the priority of a replacement value procedure in a replacement value procedure group. The replacement value procedure with the highest priority is always called first (1 = highest priority, 9 = lowest priority).
    • Minimum/maximum number of values: Minimum/maximum number of values that can be replaced using values from this procedure.
    • Replacement value procedure

Error codes for replacement value procedures are defined by process

  • Description of Error Code for Replacement Value Procedure: This field describes the type of error that may occur during replacement value creation.
  • Actions for Error Codes for Replacement Value Procedures

    Exit processing; do not save values

    Exit Processing, save values (This means, save all values - even if only half of the values were generated.)

    Continue processing, delete values

    Continue processing, use values

  • The Continue processing actions should not be used if there are no more procedures. This is because the last known values are always saved and these could potentially all be zero.

Synthetic Profile

Graph showing load contribution by customer types (interval, non-interval, street lighting) with total load shape and losses over days in 2005.

Synthetic profiles (standard load profiles) are used in some energy markets if customer consumption is not determined using an interval reading.

In Germany, for example, the German Electricity Association (VDEW) has a number of different customer groups. In the USA, customers are grouped together based on their consumption patterns. In order to do this, interval meters are installed at a representative customer from each group for a specific period of time. Overall consumption patterns are then calculated using these sample measurements.

A Synthetic Profile is a profile that contains values generated on the basis of predefined periods (defined by day and season groups) and corresponding day and annual profiles. It is used when no interval readings are available to classify the consumption patterns of groups of customers. Customers groups (those customers with similar consumption patterns) are assigned the same synthetic profile.

Two further characteristics of a synthetic profile that will be discussed in this unit are:

  • Dynamic modification factors
  • Usage factors

Synthetic profiles can be made up of hierarchy structures. Components within this hierarchy are:

  • Season groups
  • Day groups
  • Profiles

Season, day, and time-of-use groups can be adjusted in Customizing for SAP Utilities under Energy Data ManagementBasic Settings

You must make day, season, and TOU settings before you can generate synthetic profiles.

Diagram explaining customizable season types and groups, showing season periods, divisions, year allocations, and synthetic profile links.
  • Season types describe a recurring period within a year. Season periods are allocated to a season type. In the example above, the following season types have been customized:
    • Season type Summer (0001) describes the season period from April 1st to September 30th.
    • Season type Winter (0002) describes the season period from October 1st to Decemeber 31st. (consecutive number 1) and the period from January 1st to March 31st. (consecutive number 2).
  • Season groups describe the division of the year into season types.
    • The season periods allocated to the season types in the season group must total one year (January 1st to December 31st) and cannot overlap.
    • For example, to divide a year into summer and winter, define a season group that contains the season types summer (to which you allocate the season period April 1st to September 30th)and winter (to which you allocate the season periods October 1st to December 31st and January 1st to March 31st).
Diagram illustrating customizable day types and day groups. Weekdays, weekends, and all days are categorized based on factory calendar and public holidays.

Day types define days based on the factory calendar.

In the Factory Calendar, Monday through Friday are defined as working days and Saturday, Sunday, and public holidays are defined as non-working or weekend days. A factory calendar is based on a public holiday calendar.

In the example above, the week is divided into weekdays and weekend days and the following day types are defined:

  • Weekday with reference to the workdays in factory calendar 01, this means Monday through Friday.
  • Weekend with reference to the public holidays in factory calendar 01, which means Saturday, Sunday, and public holidays.
  • Other day types can also be customized.

Day groups contain different day types.

  • Day group 1 includes weekdays (day type 0001) and weekends (day type 0002).
  • Day group 2 includes all days (day type 0003).

Note

If different day types are defined based on different factory calendars, all of the factory calendars must refer to the same public holiday calendars.

You can define exceptions for day types so that regional or company-specific non-working days can be taken into account.

The day type exceptions are also allocated to day groups and can be selected for synthetic profiles or in the RTP interface at installation level.

Diagram illustrating customizable Time-of-Use (TOU) Types and Groups, showing On-Peak and Off-Peak periods allocated within TOU Group 1.

Time of Use Groups consist of Time of Use Types.

Time of Use Types are defined and assigned to a Time of Use Group. For example:

  • The TOU period from 08:00:00 to 17:59:59 is allocated to TOU type 0001 (on-peak rate period)
  • TOU periods from 00:00:00 to 07:59:59 and 18:00:00 to 23:59:59 are allocated to TOU type 0002 (off-peak rate period)

In order to set up the TOU Group, the Time of Use Types On-Peak and Off-Peak are allocated to a TOU Group. In the above example, TOU Group On-Off Peak consists of on- and off-peak time periods as defined in the TOU type.

Graph showing the generation of synthetic profiles across winter and summer, depicting different day profiles (101-104) for weekends and working days.

Synthetic profile values are determined using reference measurements or statistical methods and are saved as a day profile in the Energy Data Repository.

Based on the allocation of season, day and TOU groups, a synthetic profile structure is generated.

During the generation of the synthetic profile, the day profiles (standard load profiles) are determined according to the hierarchy. The profile values are then transferred to the synthetic profile according to the hierarchy settings.

As an alternative to day profiles, you can also allocate year or elementary profiles to a synthetic profile. Once a profile has been allocated to a synthetic profile and the synthetic profile has been generated, the day profile, year profile, or elementary profile can no longer be changed manually or by means of a mass change.

However, if an elementary profile is allocated to the synthetic profile, and the elementary profile is provided profile values on a regular basis from an automated meter reading system, the synthetic profile is generated automatically.

Chart comparing synthetic load profiles, with and without dynamic modification, showing adjusted seasonal characteristics in load shape

Dynamic Modification Factors are used to modify a customer or customer group's synthetic profile to represent the temperature impacts throughout the year. This process is known as dynamic modification and guarantees a typically stable load shape.

Dynamic modification factors are generated in EDM.

Note

SAP delivers a dynamic modification function. This function complies with the standards of the German Electricity Association (VDEW).

You can find this function in Customizing under SAP Fiori app: Home pageUser Profile iconApp FinderSAP MenuSearch in SAP MenuCustomizing – Execute ProjectSAP Reference IMGSAP UtilitiesToolsSystem ModificationsUser-Defined Enhancements for Energy Data ManagementDynamic Modification Function for Synthetic ProfilesDefine Functions for Calculating Dynamic Modification Factors.

Synthetic profile values can be normed in relation to a given consumption amount, or a fixed reference value, for a given time period of time. In this way a total consumption is used to create a synthetic profile based on the day profiles attached to it.

Normalization is possible for one year or one month. You can norm a synthetic profile for a year, for example, where the sum of the values is 1000 kWh (reference value) over the period.

Note

Values can only be generated for a period many times greater than the period length for norming.

Synthetic profiles are allocated to the installation using profile roles.

Multiple synthetic profiles can be allocated to one installation. For example, synthetic profiles can be used for both billing and settlement.

Illustration of usage factor calculation using synthetic load profiles, showing customer consumption, normed profile, and seasonal variations.

The usage factor represents the relationship between customer consumption and normed consumption values from the synthetic load profile.

In the example above, the synthetic profile is normed at 1000 kWh. The actual consumption of the customer is 900 kWh. The usage factor is automatically determined by dividing the customer consumption by the normed value of the synthetic profile:

Usage factor = 900 kWh / 1000 kWh = 0.9

Usage factor is updated:

Usage factors are automatically calculated and updated by means of consumption quantity determination in IS-U Billing. The billing period in which the consumption accumulates is taken into consideration. It is possible to specify for each synthetic profile of the installation whether or not the consumption quantity determination updates the usage factor.

Select the Load Profile button in the Display/Change app.

  • Choose Create.
  • Enter a start and end validity date for the allocation.
  • Enter the load profile to be allocated.
  • Enter the usage factor.

Profile Display/Change

You can access the Display/Change Profile Values app for displaying and maintaining profile values in the Energy Data Management

  • You can display profile values in table form or as a graphic.
  • The changeover to summer-time is taken into account in EDM.

    If profile values are managed in 15-minute intervals, you have the following scenario:

    • In Spring, there are four fewer time intervals on the day of changeover, because 03:00 directly follows 01:45 (therefore, the time intervals 02:00 to 02:45 are missing).
    • In Autumn, there are four more time intervals on the day of changeover. This is because there are two intervals for 02:00, 02:15, 02:30, and 02:45.
  • The changeover to other time zones is also taken into account in EDM.The database stores all values in Universal Time Coordinated (UTC). When the local system time is set to Greenwich Mean Time (GMT), for example, the system displays the UTC time + 1 hour to show the GMT time.
  • When you display the profile values in a graphic, there are numerous formatting options. Right-click the mouse on the graphic to access the different diagram options.
  • In the Change Profile Values app, you can change values in one of two ways:
    • Single value change
    • Mass change

    In this example, the profile value on 01.01.2005 was changed manually at 07:00:00 from 12.04 to 15.00. As a result, the status of the profile value has changed. The new status specifies that the values was changed manually.

    As a result, the status of the profile value has changed. The new status specifies that the values was changed manually.

    Diagram illustrating single change to profile value. The following text provides more detail.
  • In the Carry Out Mass Change transaction, you can change several profile values at once by making the following settings:
    • To be executed:
      • Add, subtract, multiply, divide, replace
      • Delete values, protect values, undo value protect, lock values, release values, interpolate values, extrapolate values
    • With value: Enter the value here that must be used to carry out the mathematical operation (for example, add value x to the previous profile values or multiply the previous profile values by value x).
    • To values from and to: Here, you enter the period (date and time) for which the profile values are to be changed.

    In the following image, a mass change took place for the profile values on January 1st 2005 between 00:00:00: and 10:00:00, in which the value 10 was added to each of the original profile values. As a result, the status of the profile values has also changed. The new status specifies that the values have been manually changed

  • Diagram illustrating mass change to profile value. The following text provides more detail.
  • You can define how the status of profile values is displayed in tabular and graphical form. Make the settings in Customizing for Energy Data Management under SAP Fiori appHome PageUser Profile iconApp FinderSAP MenuSearch in SAP MenuCustomizing - Execute ProjectSAP Reference IMGSAP UtilitiesEnergy Data ManagementProfile ManagementDisplay FunctionDefine System Status Display for Profile Values.
  • You define the status display using the following parameters:
    • Status: ID of the status predefined by SAP
    • Status symbol for tabular display: Here you define which symbol is used to display the status of a profile value for the tabular display. You can use the input help function to select a symbol, or you can define your own.
    • Priority of status for profiles displayed as tables and graphics: Here you define which status is displayed when a profile value has more than one status. You can use the input help function to find out the permissible value range for the priority allocation (1 = highest priority, 99 = lowest priority).
    • Color of status for graphical profile display: Here you define the color in which the status of a profile value is displayed for the graphical profile display. You can use the input help function to find out the color numbers of the red, green, blue values (RGB values). You can use the input help function to find out the permissible value range for the color number allocation.
  • You can define reasons for creating profile versions.

    To do this, you must make the settings in Customizing for Energy Data Management under SAP Fiori app:

    Home pageUser Profile iconApp FinderSAP MenuSearch in SAP MenuCustomizing - Execute ProjectSAP Reference IMGSAP UtilitiesEnergy Data ManagementProfile ManagementProfile VersionsDefine Creation Reason for Profile Versions.
  • You can also define the creation of a version based on the profile type. You can define, for example, that if the values of a Historical profile type are changed, then a version is always created, and if the values of a Forecast profile type are changed, then a version is never created.

    You make these settings in Customizing for Energy Data Management under SAP Fiori app: Home pageUser Profile iconApp FinderSAP MenuSearch in SAP MenuCustomizing - Execute ProjectSAP Reference IMGSAP UtilitiesEnergy Data ManagementProfile ManagementProfile VersionsDefine Creation of Profile Version

    These settings are only applied when you change profile values manually using the Change Profile Values app.

    Image showing display of profile versions
  • If versions of profile values exist, you can display them using the Display/Change Profile Values app. In doing so, you can display several versions in parallel. You can select or hide versions.

Profile Formula

Formula profiles contain values that were determined on the basis of a calculation rule.

  • The calculation rule is mapped in a formula.
  • You can use the formula profiles to map constant dependencies for profiles on a long-term basis.

Formula profiles, like all other profiles, are created using the Create Profile Header app. You must choose the Formula profile type in the profile header. You can then enter the appropriate details that are needed for formula profiles.

A formula is a calculation rule that converts the different input parameters (profile values) into output parameters (formula profile values), according to a mathematical algorithm.

Formulas:

  • form the basis of the profile calculation, in which the mathematical dependencies are mapped. Are implemented as function modules and allocated in the profile header.
  • have input and output parameters, the amount and category of which are defined in the formula definition.
  • are delivered by SAP and can be adjusted in Customizing.
  • are used in the interface for billing.

You can create your own formulas and write the documentation for them. In Customizing, you can define formulas in addition to those predefined by SAP:

SAP Fiori app Home pageUser Profile iconApp FinderSAP MenuSearch in SAP MenuCustomizing – Execute ProjectSAP Reference IMGSAP UtilitiesToolsSystem modificationsUser-Defined Enhancements for Energy Data ManagementFormulasDefine Formula

Parameter definitions:

  • Parameter number: Defines the number of input and output parameters in the formula.
  • Parameter type: Input or Output Parameters
  • Parameter ID: Description of the formula parameter
  • Profile value category: Classifies values that you manage in the profile.
  • ID Formula variable: After you allocate a variable, you have the option to determine variable values from the IS-U environment and to use these in the formula profile calculation.
Graph showing a formula example (LIMIT01) with input parameters and output parameters for load profiles above/below demand baselines.
  • Example Formula: LIMIT01
  • Input parameters:
    • I01: Measured load profile: Quantity
    • I02: First baseline value: Quantity
    • I03: Second baseline value: Quantity
  • Output parameters:
    • 001: Portion below first baseline: Quantity
    • 002: Portion above first baseline: Quantity
    • 003: Portion above second baseline: Quantity
    • 004: Demand above baseline: Demand
  • Function module:

    ISU_EDM_FORMULA_0004

  • Formula description: Value determination above and below a demand baseline.

The following prerequisites apply for the use of different interval lengths of input and output parameters in the formula allocation:

  • All output parameters must have the same interval length
  • Interval lengths must be equidistant.
  • Parameter "Number of Influential Intervals" for input and output parameters must be equal to zero.
  • Interval lengths for input and output parameters must be an exact multiple of each other.

If you use day value profiles, the following prerequisites also apply:

  • Input and output parameters permit only the combination of the interval length types, DAY and MINUTES.
  • If you use more than one day value profile in the formula allocation, the day offset must be the same in all input and output parameters of the type Day Value Profile.
  • If you use at least two day value profiles in the formula allocation, the time zone must be the same in all input and output parameters of the type Day Value Profile.

The four most important elements of the formula profile are:

  • Formula
  • Status group
  • Input parameter
  • Output parameter

Profiles are allocated to the input and output parameters within the formula profile.

When you create a formula profile using the Create Profile Header app, you must allocate the status group. Status groups define the status of the input parameters when converted into output parameters.

Within the status group, the status and priority determine which business process (action) to use. Once the status has been determined - with the highest priority for the output parameters of a formula - the action allocated to this status is determined and executed.

The meaning of the individual status group elements:

Status refers to the status of the input parameter (for example, no value, value is valid, value is estimated, and so on).

Illustration showing mapping of actions to statuses in SAP, where actions like Import valid value are linked to statuses like Value missing.

External status of a measured value: Status provided by an external system (AMR, for example). The MSCONS status (46=supplied quantity, 99=estimated quantity, and so on) could also be interpreted as an external status.

  • Internal status of a measured value: Status with which a measured value is maintained in the EDM system
  • Business process: The SAP system contains central table of business processes that are valid for all applications and can be used by all applications. These business processes are maintained by SAP and cannot be changed.
  • Information on user statuses: You should only define a user status if the number of system statuses or the level of detail of the system statuses is not sufficient, or if you want to add more information to the profile values.

You make enhancements in SAP Basis Customizing using transactions BS12, BS32, and BS22.

Diagram showing the formula profile allocated to the IMPORT status group

In the example above, the formula profile is allocated to the IMPORT status group. The status groups are set up in Customizing.

The following tables shows the IMPORT status group contains the following statuses, priorities, and actions:

StatusStatus PriorityAction
IU012–Value is Valid1UI12-Import Valid Value
IU013–Value was Estimated2UI13-Import Estimated Value

Because the status ‚Value is Valid, has the highest priority, the action‚Import Valid Value, is performed.

In this Customizing activity, you define and prioritize statuses and actions and arrange them into status groups. Status groups are used in profile calculation. When the status is determined for the result value of a formula, the action with the highest priority of all input parameters is determined.

Customizing:

SAP Fiori app Home pageUser Profile iconApp FinderSAP MenuSearch in SAP MenuCustomizing – Execute ProjectSAP Reference IMGSAP UtilitiesEnergy Data ManagementProfile Management Formula ProfilesProfile CalculationDefine Status Group and Statuses for Status Group
  • Status group description
  • Status for status group
    • Status: Key that informs you of the current status of an object
    • Status priority: Defines which status of a status group is determined for the result value of a formula
    • Action: Defines which business action is to be executed on the basis of the priority and status

For each profile allocated to the input and output parameters in the formula, specify the following information:

  • No calculation: If you select this field, the formula allocation is not calculated, although calculation-triggering events (such as changed profile values) have taken place.
  • No status: If you select this field, the statuses of this input parameter are not taken into account for status determination for the values of the output profile (this means the formula profile).
  • Consecutive number
  • Profile number
  • Validity period (from-to) of parameter allocation

When a formula has multiple output parameters, each formula profile must be defined individually for the corresponding output parameter. This means that a separate profile header is created for each output parameter.

A formula from the same category can exist more than once in the system. The number of the formula allocation is used to differentiate between the individual formulas.

When you create a formula profile header, a formula allocation number is automatically generated. When there are multiple output parameters defined in the formula, you must create a formula profile for each output parameter.

You can use the input help (F4) function for formula allocation to display all formula allocations that do not yet have output parameters, and have the same interval lengths.

Diagram showing the formula COPY01 copying one profile into two profile groups

In the above example, formula COPY01 is used to copy one profile into two output profiles:

  • Formula COPY01 has an input parameter, to which a consumption profile (load shape) is allocated
  • Formula COPY01 has two output parameters
    • Output parameter 1 is allocated a copy of the consumption profile
    • Output parameter 2 is allocated a profile, in which the consumption values have been converted into demand averages
Diagram showing dependent formula allocations in SAP, illustrating inputs, hierarchical outputs, and formula calculations using SUM01 and LIMIT01 functions.

You can create complex formula allocation hierarchies that are taken into account in the formula calculation. The calculation mechanism takes into account lower-level formula allocations in the hierarchy when higher-level allocations are flagged for calculation by the calculation-triggering events.

You can use the Calculation Workbench to present formula allocation hierarchies in a graphic.

The EDM Calculation Workbench app is the gateway to calculating, processing and monitoring formula profile calculations.

Process formula allocation:

  • Display formula allocation button: shows the allocation via the Display profile header screen.
  • Calculate formula allocation button (synchronous calculation): You can calculate a formula allocation synchronously for a certain period. This also includes all inactive, dependent formula allocations with triggering functions. Enter the formula allocation and choose Calculate Formula Allocation. Selected formula allocation and all inactive formula allocations beneath it in the hierarchy are calculated. This allows the user to make single formula calculations. After the profile has been calculated, in the profile header, Details tab page, you can see the calculated-to date, which shows the last date the formula was calculated.
  • Flag for calculation button: generates a calculation trigger
  • Hierarchy display button: allows the user to see the formula allocation in a graphic, to better understand the relation between the profiles

The following applies to the Calculation trigger:

  • It must be compressed to run the formula calculations.
  • Because only completed formula allocations and not individual profiles are calculated, the temporary triggers are compressed at the level of the total formula allocation. Compression of the calculation trigger is a prerequisite for asynchronous calculation of formula allocation.
  • The calculation triggers are compressed regarding the formula allocation number, and the from- and to-date.
  • Authorized users can delete calculation triggers.
  • To calculate formula allocations that are connected as regards time and hierarchy in parallel, without causing locks, the data must first be put into an appropriate form as regards time and hierarchy.
  • Unlock Compression: The compression is locked while the calculation trigger is being compressed, so that no other compression can be started at the same time. If errors occur during the process, compression remains to locked. You can, however, remove the lock manually.
  • Monitoring calculation triggers: Allows user to monitor the compression.

The following applies to Asynchronous Calculation:

  • Asynchronous Calculation is the scheduled calculation of formula profiles. The calculation run considers all formula allocations, for which calculation triggers exist.
  • Formula profile calculation analyzes the dependent formula allocations based on the compressed calculation triggers, and starts parallel calculation of the profiles
  • It is executed in the background on the specified servers as many times as the number of jobs you have selected per server
  • It is performed on several servers and processors per server for optimum system performance
  • It is locked for other users while a calculation run is taking place. If a calculation run has not been successfully completed, the lock is not removed from the calculation run. When monitoring the calculation, you can remove the lock and restart the calculation run.

Note

As a prerequisite for profile calculation, you must compress the calculation trigger.

The following applies to Current Calculation Run:

  • Display information about the current calculation run
  • Header data:

    Calculation run number, Restart number, Creation date, User ID of creator

  • Status: Monitor status of the run, or manually change the status of the calculation run
  • Parallel processing:

    Interval length or number of intervals, server name, and number of jobs

  • For more information on the calculation run, choose Job Overview or Action Log.

Profile Archiving

You can archive profile values that are no longer required online. Profile values are deleted from the database and written to archive files. You can display these archived values.

You can also archive profiles that belong to the formula profiles category (see unit Formula Profiles). In the process, a check takes place during formula profile calculation to determine whether the calculation period is smaller than or equal to the archive-to date in the profile header of the input and output profiles.

The profile header information remains. The last archiving date is displayed in the profile header (field: Profile Values Archived to).

Customizing:

  • Before you start the archiving run for the first time, you must first activate the archive information structures for the individual document types (in this case, the document type is EDM profile values). You make these settings in Customizing for SAP Utilities under ToolsArchivingActivate Info Structure for Archiving.
  • Archive information structure SAP_ISU_PROFV

The diagram shows the process of analyzing whether values can be archives.The text provides more detail.

You want to archive profile values after a certain amount of time (retention period in system). To do this, you define the retention period of profile values in Customizing for SAP Utilities under ToolsArchivingDefine Retention Period for Archiving Objects.

Profile values are analyzed to find out whether or not they can be archived. This analysis is as follows:

  1. Profile value selection: First you must restrict the amount of profile values to be archived. To do this, enter the profile values that you want to archive.
  2. Determination of the final date for archiving:

    The system determines the final date for archiving from the retention period defined in days in Customizing. This means that only those documents that are older than the retention period in Customizing (documents that have been in the system for longer) can be archived. To determine the final date for archiving profile values, the retention period of archiving object ISU_BILL (billing document header) is also used. You can only archive the profile values if the billing of the associated installation is complete, and the billing document can no longer be reversed.

Manage Lifecycle of Energy Data Profiles

1. Storyline

1.1 Story

Embark on a journey with SAP to discover how SAP solutions can help you transform your business. This offline demo will showcase our portfolio with a focus on the Utilities Smart Meter Rollout. Get hands-on with Procurement Initiation, seeing first-hand how we streamline acquisition of AMI smart meters. Experience Service Order Creation, delivering clear, comprehensive task lists for meter replacements. Engage with Execution and Confirmation, demonstrating efficient field service operations. Finally, navigate Post-Replacement Verification, ensuring each installed meter functions correctly. This persona-based, benefits-driven demo aims to address business needs with clarity and comprehensibility.

1.2 Acting Persona

Sarah Miller:

Note the following needs:

  • A thorough understanding of the company's products or services to effectively respond to customer questions and concerns​
  • Strong problem-solving abilities to manage complaints and resolve customer issues efficiently​
  • Patience and empathetic listening skills​

Note the following challenges:

  • Handling certain customer complaints​
  • Staying informed about the continuously evolving product line or services provided by the company​
  • Maintaining a balance between delivering high-quality service and working efficiently​

1.3 Value Drivers

  • Improve cycle time for new contract creation

    Improve cycle time for new contract creation by incorporating preconfigured settings to enable switching of contracts in an easy manner

  • Reduce IT spend

    Reduce IT spend by supporting enormous volume of transactions that are generated in the deregulated utilities industry in an effective manner

  • Reduce days sales outstanding

    Reduce days sales outstanding by moving to a pre-paid billing system that reduces the credit provided by utilities to customers

2.2 Key Takeaways

  • The SAP demo showcased streamlining and centralizing energy data profiles, enhancing data visibility, accessibility, and accuracy.
  • The demonstrated automation of data lifecycle not only boosts efficiency but also reduces potential error, ensuring data reliability.
  • With built-in analysis tools, the solution allows smarter decision-making based on real-time energy data.
  • Proactive management of energy resources, offered by the solution, will effectively reduce waste, lower costs, and ensure environmental compliance.
  • The demo indicated the potential to align energy management with broader business objectives, enhancing overall operational performance.

3.Pre-demo Steps and Guidelines

3.1. Prerequisites and Pre-Demo Steps

  1. Navigation: Click on the tile to create master data.Screenshot showing that the 'Create Master Data' tile is selected
  2. Select and enter the required fields.Screenshot of the Create Complete Set of Business Data page with fields for input
    1. Enter Country : US
    2. Select electric contract.
    3. Select Electricsmart meter.
    4. Enter move-in date 01/01/2024.
    5. Enter first and last name.
    6. Press Enter.
    7. Click Execute.
  3. More details for output:Screenshot showing the IDs generated

    Click on expand.

  4. Note the IDs generated.Screenshot showing the expanded hierarchy, showing the IDs generated

    Note the Business partner number and Installation number.

3.2. Master Data and Additional Information

Profile for Consumption forecast

Use the below profile #10000783 for Consumption Forecast.

Steps

  1. 4.1. Billing and Invoicing Cycle

    Business activity pertains to the actions carried out by enterprises as they produce goods or provide services for consumers. It encompasses a wide range of operations from ideation, resource procurement to production, marketing, and customer engagement. The scope of business activity spans across various industries and sectors globally, influencing financial movements and macroeconomic conditions.

    4.1.1. Profile Management

    Note the following benefits:

    • Enhanced operational efficiency through device-profile assignment
    • Enhanced device management with profile assignment features

    Persona: Sarah Miller

  2. 4.1.1Review Installation:

    Customer agent checks the meter associated with the installation.

    Screenshot showing meter and register data linked to the installation for customer review.
    1. Navigation:

      1. Click on the Energy Data Management space.
      2. Click on the tile, Display Installation.
      Screenshot showing the Display Installation tile is selected
    2. Enter the input.

      Enter the installation noted earlier.

      Screenshot showing the number is entered in the Installation field
    3. Billing periods:

      Click on Devices.

      SAP utility installation screen showing the Devices button is highlighted
    4. Review the device data.

      1. Note the device number.
      2. Review the register data to be AMI related.
      Interface showing device and register data, which are highlighted in different sections
  3. 4.1.1Manage Profile Header

    Customer Agent creates and assigns profile to device.

    Screenshot showing profile creation and assignment to devices with register details
    1. Navigation: Select theCreate Profile Header tile on the main Energy Data Management page.

    2. Enter input:

      1. Enter the Profile Description.
      2. Select the division, Electric.
      3. Select TOU Billable.
      4. Scroll down.
      Screenshot of the Create Profile Header screen showing profile header fields, creation options, and data input sections
    3. Enter the input:

      1. Select Profile type as Historical profile.
      2. Select the check group as Checks for status of profile values.
      3. Select RVP group as REPLACE MISSING VALUES.
      4. Enter Valid from date as 01/01/2024.
      5. Enter Timezone as UTC.
      6. Select Interval Length as 60 minutes.
      7. Select PV category as QUANTITY.
      8. Enter Measuring Unit as kwh.
      9. Enter Decimal places as 2.
      10. Click Save.
    4. Note the profile number.

      Screenshot highlighting the Profile Number, which is displayed at the bottom
    5. Navigate for profile allocation:

      1. Click on Goto.
      2. Select Profile Allocation from the GoTo dropdown menu.
      3. Then, select Change.
    6. Selection of dates:

      1. Enter selection start date as 01/01/2024.
      2. Enter selection end date of current date.
      3. Press ENTER.
      Screenshot showing selection dates, attributes, and profile allocation sections
    7. Add role to allocation.

      1. Select Consumption measured.
      2. Click the plus icon +.
      3. Review the From Date as 01/01/2024.
      4. Review the To Date as 12/31/9999.
      5. Enter the device number that was noted earlier.
      6. Press ENTER.
      7. Click Save.
      8. Click on Refresh.
      The screenshot shows the allocation profile section. The steps outlined in the text are highlighted.
    8. Click on Register to select the register.

    9. Add forecast role.

      1. Select the role, Consumption Forecast.
      2. Click the plus icon +.
      3. Review the from-date as 01/01/2024.
      4. Review the to-date as 12/31/9999.
      5. Enter the profile mentioned in the Master Data section.
      6. Press ENTER.
      7. Click Save.
      8. Review two profiles under register.
      Screenshot showing the profile allocation and consumption forecast details
  4. 4.1.2. Consumption Measurement for Billing

    Note the following benefits:

    • Enhanced accuracy in billing calculations through customer agent uploads of profile values
    • Streamlined billing procedures through customer-agent uploaded profile values

    Persona: Sarah Miller

  5. 4.1.2 Upload Profile Values:

    The customer agent uploads the values to the profile.

    The Upload Profile Values screen
    1. Prepare file.https://content-discovery.int.sap/api/content-store-integration/v1/file-proxy/actions/download?file-path=https://acms-gateway.cfapps.eu10-004.hana.ondemand.com/content/api/v2/workspheres/2b6dd77b-7f54-423e-a3d3-4c5f8ecb09da/releases/292/entities/demo_scenario/fields/b557278a-8681-4c1d-a345-0746e9399927/file/9894dcdb-6218-4f46-a54e-eb5f7654ef84&file-type=application/zip&file-length=7202&acms-worksphere=demo-store

      1. Open the file from the attachments in Content Discovery.
      2. Click to replace values.
      3. Enter the existing profile number in the field.
      4. Enter the profile number noted earlier that you created in the field.
      5. Click to replace.
      6. Save the changes.
      7. If you have different dates, update the dates accordingly.
      Screenshot highlighting the numbered steps (as described in text) for uploading values to a customer profile file
    2. Navigation: In the Energy Data Management space, select the File Upload Via Profile tile to upload profile values. If this tile is not available in this session, please search for it.

    3. Enter input in the fields:

      1. Enter File Type as ASC.
      2. Enter External Reference as SAPBAPI.
      3. Enter the Source System as SAPBAPI.
      4. Click Execute.
      Screenshot showing data entry for the upload of profile values, with steps labeled 1-4, as described in the text
    4. Click Continue on the Information popup.

    5. Select F4 help.

      Screenshot showing Choose the file you would like to upload prompt with highlighted Help button
    6. Click OK on the File Upload popup that appears.

    7. Select the file.

      1. Select the file you saved from the attachments for billing (Template file for profile values for Jan billing.txt).
      2. Click Open.
      Window showing that a file and the Open button are highlighted
    8. Click Continue on the File Selection popup.

    9. Review the message.

      1. The message reports that profile values were transferred
      2. Click the Back icon < .
  6. 4.1.2 Review Profile Values.

    The customer agent reviews the uploaded values.

    Screenshot showing profile value import information with column and row details
    1. Navigation: Click on the Profile Value Monitor tile on the Energy Data Management page.

    2. Enter the input:

      1. Enter the Profile number.
      2. Click Execute.
      Screenshot showing profile value import options with search results and Execute button
    3. Review the file upload.

      Review the from and to dates of the import.

      Screenshot showing import data table with highlighted from and to date fields
    4. Navigation: Click on the Display Profile Values tile on the Energy Data Management page.

    5. Selection of dates:

      1. Enter the profile number.
      2. Enter the from date asJan 1 2024 as the values uploaded.
      3. Enter to date as Jan 31 2024 as the values uploaded.
      4. Click Continue.
      Display Profile Values screen with numbered steps, dropdowns, and a Continue button
    6. Review the values:

      1. Select the profile.
      2. Review the values for each day.
      3. Review the values for each interval.
      4. You can check other calculations of the values like the average.
      Display Profile Values screen highlighting different sections of profile value data, as outlined in the text
  7. 4.1.3. Invoicing Customer

    Note the following benefits:

    • Enhanced efficiency in financial processes through billing simulation and invoicing
    • Enhanced accuracy in financial forecasting through billing simulation and invoicing

    Persona: Sarah Miller, Customer Service Representative

  8. 4.1.3Simulate Billing and Invoicing:

    The customer agent simulates the bill and invoice.

    The Billing Simulation screen showing status, billing types, selection criteria, and runtime details
    1. Navigation:

      1. Click on the Meter Reading & Billing space.
      2. Click on the Billing & Invoicing page.
      3. Click on the Billing Simulation tile.
      Screenshot showing that on the Meter Reading and Billing space, Billing and Invoicing is selected from the dropdown, and the Billing Simulation tile is selected.
    2. Enter the input:

      1. Select Simulation.
      2. Enter the date, Jan 1 2024.
      3. Enter the date, Jan 31 2024.
      4. Select Installation.
      5. Enter the installation data.
      6. Click Bill/Simulate.
      Screenshot showing data in numerous fields, numbered 1-6, as described in the preceding text
    3. Review output.

      Click on the Display Document tab.

    4. Enter input on the Display Document popup.

      1. Document number will be auto populated.
      2. Click Continue.
    5. Review consumption.

      1. Review the ON Peak OFF peak quantities and total price.
      2. Click the Back icon <.
      Screenshot showing billing overview, including consumption details
    6. Invoicing:

      Click on Invoice Simulation.

      Screenshot showing that Invoice Simulation is selected on the Automatic Billing and Simulation screen
    7. Input for invoicing

      1. A popup, Invoicing Simulation, opens. The Billing doc will be auto-populated.
      2. Click Continue.
    8. Print the document.

      Click on Display print document.

    9. Display print document.

      1. A Print Document Display popup appears. The Document number will be auto-populated.
      2. Click Continue.
    10. Simulate the bill:

      Click on Simulate Bill.

      The screenshot shows the contract account document data and billing overview. The Simulate Bill button is selected.
    11. Print parameters:

      1. A Choose print parameter popup appears. The input fields are auto-populated.
      2. Click Continue.
    12. Final output:

      Review the values on the final invoice print.

      Screenshot of an Invoice print
  9. 4.2. Manage Meter Reading and Consumption​

    Business activity refers to the operational actions undertaken by a company to generate profits. These activities encompass a broad spectrum, including production, sales, services, research and development, and administrative tasks. In essence, any action that is directly or indirectly related to the provision of goods and services to a market is considered as business activity.

    4.2.1. Consumption measurement

    Note the following benefits:

    • Enhanced data visualization through file interpolation
    • Enhanced document handling with diverse file upload capability for seamless interpolation

    Persona: Sarah Miller, Customer Service Representative

  10. 4.2.1 Interpolating Minimum Values

    The customer agent uploads the file to showcase the interpolation feature.

    The Display Profile Values screen
    1. Prepare the file.

      1. Open the file from attachments in Content Discovery.
      2. Select to replace values.
      3. Enter the existing profile number.
      4. Enter the new profile number < keep the zeros>.
      5. Click on Replace All.
      6. Click Save.
      7. If your dates are different, replace the dates as well.
      The file selection screen
    2. Navigation: Click on the File Upload via Profile tile on the Energy Data Management page.

    3. Enter the input:

      1. Enter the File Type.
      2. Enter External Reference.
      3. Enter the Source System.
      4. Click Execute.
      Screenshot shows input in the fields for file type, external ref, and source system. The Execute button is selected.
    4. Select F4 help on the File Selection popup.

    5. Select the prepared file.

      1. Select the file.
      2. Click to open.
      Screenshot showing the file is selected
    6. The File Selection popup opens. Click Continue.

    7. Output message:

      1. A message appears reporting missing values.
      2. Click the Back icon <.
      Output message reporting errors displayed on screen
    8. Navigation: Click on the Display Profile Values tile on the Energy Data Management screen.

    9. Review the values.

      1. Enter the profile number.
      2. Enter the selection date as Feb 1.
      3. Press ENTER.
      4. Select the profile.
      5. The minimum of the known edge values are populated for the missing intervals.
      Screenshot showing profile data, selection details, and time interval values
  11. 4.2.1 Interpolating Maximum Values:

    The customer agent uploads the file to showcase the interpolation feature.

    Screenshot showing profile values and consumption details
    1. Prepare the file.

      1. Open the file from attachments in Content Discovery.
      2. Select to replace values.
      3. Enter the existing profile number in the input field.
      4. Enter the new profile number in the input field.
      5. Click on Replace All.
      6. Click on Save.
      7. If the dates are different, you can change the dates as well.
    2. Navigation: Click on the File Upload via Profile tile in the Energy Data Management space.

    3. Enter the following input on the Upload Profile Values by Profile Number screen.

      1. Enter the File Type.
      2. Enter External Reference.
      3. Enter the Source System.
      4. Click on Execute.
    4. Search for the file:

      Select F4 Help on the File Selection popup.

    5. Select the file.

      1. Select the file.
      2. Click Open.
    6. Click Continue on the File Selection popup.

    7. Output message:

      A message appears, as shown in the following image. This message is right due to missing values.

      Screenshot of output message reporting errors
    8. Navigation: Click on the Display Profile Values tile in the Energy Data Management section.

    9. Review the values:

      1. Enter the profile number.
      2. Enter the selection date as Feb 2 2024.
      3. Press ENTER.
      4. Select the profile.
      5. The maximum of the known edge values are populated for the missing intervals.
      Screenshot showing profile values with date, interval, and consumption details highlighted
  12. 4.2.1 Interpolation Linear

    The customer agent uploads the file to showcase the interpolation feature.

    Display Profile Values screen
    1. Prepare file.

      1. Open the file from attachments in Content Discovery for interpolation Linear values.
      2. Select to replace values.
      3. Enter the existing profile.
      4. Enter the new profile.
      5. Click Replace All.
      6. Save the file.
      7. If the dates are different, you can change the dates as well.
    2. Navigation: Click on the File Upload via Profile tile.

    3. Enter the following input:

      1. Enter the File Type.
      2. Enter External Reference.
      3. Enter Source System.
      4. Click Execute.
    4. Search for the file:

      Select F4 help.

    5. File selection:

      1. Select the file.
      2. Click Open.
    6. Continue:

      Click Continue on the File Selection popup that appears.

    7. Output messages

      A message appears reporting errors. This message is right due to missing values.

    8. Navigation: Click on the Display Profile Values tile.

    9. Review values:

      1. Enter the profile number.
      2. Enter the Selection date, Feb 3 2024.
      3. Press ENTER.
      4. Select the profile.
      5. The known edge values are populated linearly for the missing intervals.
      Screenshot showing input in the fields (numbered 1-5 on the Display Profile Values page
    10. Navigation: Click on the Profile Value Monitor tile.

    11. Enter the input:

      1. Enter the profile number.
      2. Click Execute.
    12. Profile upload logs:

      Review all the profile uploads and the dates of the values.

      Screenshot showing profile values, data delivery info, and highlighted details
  13. 4.2.1 Extrapolating Consumption Values:

    The customer agent performs the extrapolation of profile values.

    Interface displaying profile values, business partner, contract account, and consumption data
    1. Navigation: Click on the Display Profile Values tile.

    2. Select profile selection date.

      1. Select the BP tab.
      2. Enter the Business partner noted earlier in the field.
      3. Enter the selection dates as Mar 1 to Mar 31 2024.
      4. Press ENTER.
      5. Select both the profiles.
    3. Extrapolate:

      1. Click the profile number you noted earlier that you created.
      2. Click on the icon for mass changes.
      Screenshot showing the profile number and the icon for mass changes are selected on the Change Profile Values screen
    4. Enter the input for extrapolation on the Carry Out Mass Change popup.

      1. Select Operation as Extrapolate values.
      2. Enter the dates as Mar1 to Mar 31 2024 in the fields.
      3. Click Continue.
    5. Values extrapolated:

      1. The values are extrapolated from the existing profile.
      2. Click Save.
      Screenshot highlighting the profile values in a column and the Save button
    6. New profile version:

      Click Yes to create new profile version on the Version management popup.

      Screenshot showing version management popup, asking to create a profile version. ''Yes'' is selected.

Manage Business Process Exceptions

1. Storyline

1.1 Story

Embark on a journey with SAP through a persona-based, benefits-driven offline demo. Witness first-hand the versatility of SAP solutions as they seamlessly perform functions such as validation checks, business rule framework configuration, and profile data import. Engage in the transformative process of automatic corrections and business process exception management. Discover how SAP solutions can help you transform your business by enhancing the validation checks, optimizing business process analyses, and managing KPIs and reports. Detailed steps guide you through, from profile import to the execution of Business Process Analysis and Utilities Exception Management application. Explore how automatic corrections update profile status and values, thereby offering a streamlined solution for your business needs.

1.2 Acting Persona

Fred Farley, customer service agent:

Note the following needs:

  • Familiarity with using enterprise applications and customer service tools
  • Patience to handle difficult or complex customer situations
  • Resourcefulness in finding solutions and addressing customer concerns

Note the following challenges:

  • New users might find Fiori complex initially
  • Accessing and processing real-time data can lead to performance lags, impacting the agent's efficiency
  • While personalization is a key feature, it may be challenging for agents to configure their dashboards effectively

1.3 Value Drivers

  • Reduce meter reading and data administration cost

    Reduce meter reading and data administration cost by streamlining and automating meter related collection and processing functions

  • Reduce inaccurate utility bills

    Reduce inaccurate utility bills by applying sophisticated quality checks and algorithms to handle implausible meter readings

  • Reduce customer churn

    Reduce customer churn by leveraging meter data for offering more individualized and timely services and products

  • Reduce meter reading to invoice cycle time

    Reduce meter reading to invoice cycle time by receiving meter readings remotely, on schedule, or on demand

2.2. Key Take Aways

Real-time analytics provide immediate insights without latency, optimizing operational data usage. Instant access to meter process information helps identify gaps and boost efficiency. The integrated exception management solution aligns with core processes, while the rules engine automates exception handling, increasing back-office productivity.

Steps

  1. 3.1. Import Profile Values and Automatic Correction

    This displays a comprehensive workflow for managing profile data and exceptions. It begins with an overview of validation checks and estimation procedures via the profile header. Optionally, users can explore Business Rule Framework+ configurations for validation enhancements. Profile data is then imported using a standard API, with failing values highlighted, followed by analysis through Profile Monitoring. Business Process Analysis categorizes exceptions and assigns them to relevant departments. The Utilities Exception Management application offers the ability to view and drill into exceptions by error type and initiate automatic corrections. Finally, updates and corrections are reviewed in Profile Monitoring.

    3.1.1. Master Data Validation

    Note the following benefits:

    • Enhanced data accuracy
    • Improved data integrity

    Persona: Fred Farley, customer service agent

  2. 3.1.1 Create Master Data and Validate Profile Header

    The Fiori Agent Create the Master Data with Interval Meter for Deregulated Scenario, and reviews the Profile Header details and highlights the key functions that are used to validate imported values and estimate missing values.

    Screen displaying a profile header configuration
    1. Click on the Master Data Utilities tab to navigate to the Master Data Utilities space.

      Screenshot of the Utility Billing and Data Management homepage with the Master Data Utilities tab highlighted
    2. To launch the Create MD Dereg app, click on the Create MD Dereg tile.

      The Create MD Dereg tile is highlighted.
    3. Master data setup:

      1. Select Country as US.
      2. Enter Move-in Date as first date of previous month.
      3. Enter First Name.
      4. Enter Last Name.
      5. Enter Rate Category as U-E-R-RS.
      6. Enter Device Category as METER-AMI-BPL.
      7. Select the checkbox for Interval Meter (EDM).
      8. Click on Execute.
      The Master Data Setup screen shows the fields highlighted with input, as described in the preceding text
    4. Data environment screen:

      1. Master data is created successfully.
      2. Double-click on the Installation number.
      Data Environment interface showing a hierarchical data structure with nodes labeled Business Partner, Contract Account, Utility Contract, and more
    5. Display installation:

      Click on Billing Periods.

      Screenshot of the Display Installation page showing that Billing Periods is selected
    6. Click on the Profiles tab.

      Screenshot showing the Profiles tab is selected on the Billing View of Installation screen
    7. Double-click on the profile number. Make a note of the profile number.

      Screenshot showing the profile number is selected
    8. Profile header:

      1. Profile header details are displayed.
      2. Cons check group Validation (BRF+) is what is used to validate imported values. BRF+ rule engine was used to assist with the validation process RVP group Residential Estimate and Forecast is what is used to estimate missing values.
      3. Click on the SAP logo to navigate to the home page.
      Interface showing profile header and general data fields for profile configuration
  3. 3.1.2. Business Rule Framework Plus Details

    Note the following benefits:

    • Simplified configuration
    • Increased efficiency

    Customer service agent: Fred Farley

  4. 3.1.2 Business Rule Engine Function for Validation

    The Fiori Agent reviews the configured business rules and functions.

    Interface displaying function CONSISTENCY_CHECK with assigned context parameters and simulation mode settings for rule validation
    1. To navigate to Business Process Exception Management, click on the Business Process Exception Management tab on the home page.

    2. To launch the Business Rule Framework app, click on the Business Rule Framework tile.

    3. Select Favorites.

      Click on the dropdown to select Favorites.

    4. Select Favorites from the list.

      Screenshot showing that Favorites is selected from the dropdown
    5. Expand the Utils. EDM Repl. Con node.

      Screenshot showing the Utils. EDM Repl. Con node is selected on the BRFplus page
    6. Navigate:

      1. Then, expand the Function dropdown.
      2. Double-click on Consistency Check.
    7. Consistency check:

      1. The Signature tab defines the Context details, which includes input parameters that are required to execute the Consistency Check function and Result Data Object.
      2. Click the Assigned Rulesets tab.
      Screenshot showing the function CONSISTENCY_CHECK with the Assigned Rulesets tab and the Context details area highlighted
    8. Assigned ruleset:

      Click Ruleset CONS_CHECK_RS, which defines the rules that will be executed.

      Screenshot showing that the CONS_CHECK_RS ruleset is selected
    9. Expression:

      1. There is one Rule Consistency Check Parameters defined in the Ruleset. The Rule captures the statuses required, installation number associated to the object being validated, and expression to capture the parameters required for validation.
      2. Click the expression Cons. Check Param.
    10. Consistency check parameters:

      Expression is a decision table that defines the Consistency Check type and the parameters associated to each check. (Scroll to the right to see more details)

      Screenshot of the Decision Table showing table contents with highlighted parameters and status values
  5. 3.1.3. Import and Monitor Profile Values

    Note the following benefits:

    • Early error detection
    • Enhanced monitoring
    • Efficiency in troubleshooting
    • Improved data quality

    Persona: Fred Farley, customer service agent

  6. 3.1.3Import Profile Values

    The Fiori Agent imports the profile values using a spreadsheet.

    Screens of the Import Profile Values section displaying a message to report import of value with errors
    1. Click on the Energy Data Management tab to navigate to the Energy Data Management space.

    2. Click on the Import Profile Spreadsheet tab to launch the Import Profile Spreadsheet app.

      This section of the demo demonstrates the Import of the profile values using a spreadsheet and Monitoring the import. The import transaction uses the standard API to import profile values.

    3. Enter the details:

      1. Enter data in theExternal Reference field. This is used as reference when monitoring the imports.
      2. Enter data in the Source System field. This is used to define what type of system was used to import the profile data.
      3. Click Execute.
      Interface showing Import Profile Values - Row Based with fields for External Reference, Source System, and an Execute button highlighted
    4. File selection:

      In the File Selection popup, click the dropdown to browse and find the file to upload.

    5. Click on the popup.

      The screenshot shows the file upload dialog box displaying a message, The application wants to upload a file to the SAP system.''
    6. Browse and select the file.

      Navigate to the path on local system where excel is saved.

      Note

      Download the template attached to the script in Content Discovery and save it to your local system first.
    7. Open the file.

      Right-click on the spreadsheet with the mouse and click Open to open the spreadsheet to view/edit the data.

      The screenshot shows the file is selected, triggering a menu where ''Open'' is selected.
    8. Edit:

      1. Update the Profile number in the sheet copied from previous steps. Also, update the date as the move-in date of master data created. (if already not done).
      2. One of the profile values is more than 45 which will fail the Spike check.
      3. Save the file.
      Excel spreadsheet showing data columns labeled Profile, Date, Time, Value, and Status, with numbered callouts highlighting rows and toolbar
    9. Continue:

      Click on Open to import the spreadsheet:

    10. On the File Selection popup, click on Continue.

    11. Check messages:

      1. Profile values imported, message stating that there is an error for 1 Profile.
      2. Click on the SAP logo to navigate to the home page.
      Screenshot showing a message verifying that the profile values are imported
  7. 3.1.3 Monitor Profile Values

    Fiori Agent monitors the imported profile values

    Profile values table displaying hourly consumption data for 12/09/2024
    1. Click on the Energy Data Management tab.

    2. To launch the Profile Value Monitor app, click on the Profile Value Monitor tile.

    3. Click on Execute.

      SAP screen showing monitoring options for Profile Value Import with filter fields and Execute button
    4. Check the import document number:

      The Monitoring for Profile Import screen provides details on the imported profiles. The details are as follows:

      • Import the document number to identify the actual import for the profile values
      • Date and time the profiles were imported and the period start date/time and end date/time
      • System Source and External Reference
      • Imported profile number and/or Point of Delivery
      • Status of the import
        • Green: imported with no errors
        • Yellow: imported with errors
        • Red: failed import

      Check boxes defining what occurred during the import:

      • Cons.: Passed consistency check
      • Corr.: Corrected after the import
      • Imp.: Imported profile values
      • RVPrf.: Replacement Value is required
      • Succ. RVC: Replacement value successful
      • TE: Temporary error, e.g. profile is locked
      • Term.: Import was terminated. This could be due to incorrect data or the configuration was set to not import values if a check failed

      1. Double-click on the import document no.

      Monitoring for Profile Import interface showing that Import document no. is selected
    5. Check details:

      Profile import that failed Consistency Check: the details will be captured against imported document by Double on Import document no.

      1. Consistency log will capture the Consistency Check(s) that failed, and the attributes associated to failed check.
      2. Scroll to the right we configured the check to capture the failed values
      3. Click Cancel to go back to the main screen.
      Screenshot of the Consistency Log for Import window with the steps 1-3 (as described in the text) highlighted
    6. To navigate to the profile, double-click the Profile number to view the imported profile values.

      The profile number is selected
    7. Profile Values

      1. Display Profile Values will display the profile values that were imported, date/time, status and value
      2. Double-click Status to view the status details
      Screenshot of the Display Profile Values with the status and data of the profile values highlighted
    8. Status overview

      1. The Status Overview popup will display status details; User status (Spike Fail) and System status (Valid Value)
      2. Click Cancel to go back to the main screen.
    9. Double-click Status to view the status details.

      Display Profile Values interface showing consumption data, with Status highlighted
    10. Status overview:

      1. Status Overview will display status details; User status (Imported Values) and System status (Valid Value)
      2. Click Cancel.
      Popup for the Status Overview for the Profile Value
    11. Click on the SAP logo to navigate to the home page.

  8. 3.1.4. Business Process Exception Management

    Note the following benefits:

    • Detailed Analysis: The ability to drill into specific case details provides in-depth understanding
    • Detailed insights into exceptions support informed decision-making and strategic planning

    Persona: Fed Farley, customer service agent

  9. 3.1.4 Business Process Analysis

    The Fiori agent analyzes the application logs for a business process and converts the exception into Clarification cases.

    The Business Process Analysis screen
    1. To navigate to Business Process Exception Management, click on the Business Process Exception Management tab.

    2. To launch the Business Process Analysis app, click on the Business Process Analysis tile.

    3. Selection screen:

      Click on the dropdown to select the Business Process Area.

      Screenshot showing that the Business Process Area dropdown is selected
    4. The Business Process Area window opens.

      1. Click to selectEEDM.
      2. Then, click OK.
    5. Selection screen:

      Click the Business Process dropdown to select the Business Process.

    6. Business Process:

      1. Click to select Business Process EEDM0001.
      2. Click OK.
      Screenshot showing that the business process code, EEDM0001, is selected
    7. To scroll down, click the scrollbar and scroll down.

    8. Execute:

      1. Select checkboxes for Prepare Jobs and Create Clarification Cases.
      2. Click on Execute.
    9. Check jobs:

      1. Business Process Analysis captures and analyses the application logs related to the Business Process selected. The Analysis includes providing statistical details and converts the exception into a Clarification Case.
      2. Click on No. Messages - this provides details of the application messages.
      Screenshot showing No. Messages is selected
    10. Check messages:

      1. Business Process Analysis logs define the application logs that were analyzed and how many Clarification cases created
      2. Click on the SAP Logo to navigate to home page.
      Screenshot showing a log of 83 messages in Business Process Analysis
  10. 3.1.4 Display Clarification Case

    The Fiori Agent reviews the clarification case that defines details of the exception and the business processes required to perform the correction.

    SAP Display Case interface shows details about a business process in the IS-U Energy Data Management system
    1. To navigate to the Business Process Exception Management space, click on the Business Process Exception Management tab.

    2. Click Refresh on the Utilities Exception Management application to update the KPI numbers.

    3. Launch the Utilities Exception Management tile.

      Click on the Utilities Exception Management tile to view the exception created

    4. Filter:

      Click the dropdown to view exceptions Original Date.

      The Business Process Exception Management interface shows a bar chart showing case assignments by department in SAP Utilities Exception Management. The dropdown is highlighted as selected.
    5. Select the 'Group By Original Date Open/New' option from the dropdown.

    6. Bar chart:

      Click on the bar for latest date, which will include the Exception created by the import profile value process.

      Bar chart displaying case data
    7. To view the Clarification Cases created, select List Cases.

    8. Jump To Function:

      1. Click to highlight the Case Number row to view the Clarification Case details.
      2. Click to view the transactions that can be processed against the Clarification Case.
      Business Process Exception Management dashboard displaying a table of two list cases with the rows highlighted, as explained in the text
    9. To display the Clarification Case details, click on Display Case in the Jump To dropdown..

    10. Procs tab:

      Click to review the business processes required to solve the exception.

      Interface displaying case details including business partner info, contract account, installation, message variable, and priority status as high.
    11. Edit Case

      The Process tab defines the business processes that will assist with the correction process.

      1. It's important to note that the business process which has the Column Auto. Process set can be executed via the automatic process. EDM BPEM Auto Correct utilizes BRF+ to analyze the data and determine the correction process.
      2. Click Edit to execute the manual business processes.
      The Auto.Process column and the Edit button are highlighted.
    12. Monitoring

      Click on the icon for EDM Import Monitoring. This will display the Consistency log.

      Screenshot showing that the EDM Import Monitoring icon is selected
    13. Consistency log:

      1. Incoporated the Consistency Log within the Clarification Case to provide additional details to assist with the correction process
      2. Click Enter to go back to the main screen.
      Screenshot showing the Consistency Log popup
    14. Save:

      1. Note down the Case Number.
      2. Click Save to save changes.
      SAP system interface showing a Change Clarification Case with case details, status, due date, processor, and a table of linked objects, with the case number and Save buttons highlighted
    15. On the Information popup, click Exit to go back to List Cases.

  11. 3.1.4Run Automatic Process

    The Fiori agent executes a business process automatically to resolve the exception.

    The Display Logs screen
    1. Navigate: Click here to apply filters.

      The SAP Utilities Exception Management screen displays a table of case details, including case number, status, priority, and due dates. It appears that part of the toolbar is selected above the list of the list cases, as explained in the preceding step.
    2. Click on the Filter icon at the top of the screen.

    3. On the Filter popup, select Case Number.

    4. Search for case:

      1. Enter the case number that was noted down in the previous step.
      2. Click on Search.
      A popup showing the Case Number and the search button selected on the popup
    5. Select case:

      1. Select the case.
      2. Click OK.
      Popup showing that the case is selected and the Ok button is selected
    6. Jump to:

      1. Select the Case Record.
      2. Click on Jump To.
      A dashboard screenshot of SAP Utilities Exception Management, displaying case details: The case record row and the Jump to buttons are selected
    7. Automatic BPEM Process

      To execute the automatic business process, select Automatic BPEM Process on the Jump to dropdown.

    8. Run Processes:

      1. It's important note that the processes is executed automatically via the daily batch process. Demonstration purposes: executing the transaction online to illustrate the Automatic function
      2. Click the check box to select the record.
      3. Click Run Processes.
      A screenshot of the SAP Automatic BPEM Process page with the check box and the Run Processes button selected
    9. Check Logs

      1. The Automatic Business Process is completed. The log details will be captured to determine if the process was successful. The Green status defines that it is successful.
      2. Click on the SAP logo to navigate to the home page
      Screenshot of a system log showing detailed information and green to denote success
  12. 3.1.4 Profile Value Monitor

    The Fiori Agent monitors the profile values after the automatic correction.

    Display Profile Values interface showing consumption measurement data

    1. To navigate to Energy Data Management, click on the Energy Data Management tab.

    2. To launch Profile Value Monitor, click on the Profile Value Monitor tile.

    3. Click on Execute.

    4. Navigate to the profile:

      1. It's important to note the updates to the Import Doument no.. The updates status has been updated to green, which states the import is complete and the Corr. check box is set to indicate the correction has completed the import process.
      2. Double-click Profile to view the interval values.
      The Monitoring for Profile Values Import interface: The Profile is selected.
    5. Profile Values

      Display Profile Values illustrates the following changes;

      • User status has changed
      • Profile value that failed validation: There is a new system status.
      • Profile value that failed validation: The value has changed.

      Double-click the status on the previously failed validation profile value.

      Display Profile Values screen showing that the status has been changed
    6. The Status Overview popup opens. It displays the following:

      1. Status Overview will display status details; User status (Completed Validation) and System status (Value was interpolated).
      2. Click Cancel to go back to the previous screen.
    7. Click the SAP logo to navigate to the home page.

    8. Fiori Launchpad:

      SAP Fiori launchpad screenshot