Skip to Content
avatar image
Former Member

HOW TO USE EPM FUNCTIONS

HELLO, I want to create a report in SAP BPC using excel. I have 4 type of activities in in Dimensions Type of activity : 1 - 2 - 3 and 4. And each type of activity has his own services in the Dimension ENTITY . For instance the type of activity 1 has 15 differents services; the 2 has 12; the 3 has 5 and the 4 has 8. When I choose the type of activity 1, I want only his services to be displayed.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Nov 15, 2016 at 06:02 AM

    Hi Serge,

    Your description is quite confusing.....but you have 2 dimensions....Activity dimension and Entity dimension...So you want to link the activities to the services in the Entity dimension? This is what you require? You can create a property in Entity dimension for activities, and link them...

    Then for reporting use EPM function Dimension override or Link to property from Edit Report.....

    Refer to this EPM guide for more information....

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

    Regards,

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 15, 2016 at 11:56 AM

    I have many dimensions , I have Dimension Entity, Activity,Type of avtivity, Project, Account, Period and so on. I want to create a report by using the 2 dimensions, Entity and type of activity. In Entity I have the different services which to each type of activity. I have 4 type of activities in Dimensions Type of activity : 1 - 2 - 3 and 4. IN dimension Entity I have differents services like 01-14; 01-13; 01-12; 01-10

    In the type of activity 1 I have these services: 01-14; 01-13; 01-12; 01-11; 01-10; 01-09; 01-08; 01-07

    In the type of activity 2 I have these services: 01-08; 01-07; 02-04; 02-05; 02-09; 02-12

    In the type of activity 3 I have these services: 02-11; 02-14; 02-15; 02-06

    In the type of activity 4 I have these services:02-17; 02-01; 02-15; 01-14; 01-13

    for the cell of type of activity I create this formula : EPMContextMember(;"TYPE_ACTIVITE";"PARENTH2=G1") . G1 is composed of 1; 2; 3 and 4

    For the cell of services, I want to have this. When I chose type of activity 1, I want all the services which belong to 1 to be displayed.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2016 at 12:34 PM

    Just to add:

    If you use TYPE_ACTIVITE in the row axis of your report (in addition to ENTITY) you can establish relation: TYPE_ACTIVITE member will be delivered from the property of ENTITY member.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2016 at 11:20 AM

    @Vadim Kalinin : Can you explain more about your idea with examples

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2016 at 11:23 AM

    When I use the Excel Pivotable, I get when I want , Is there an EPM function which can do the function of Excel Pivotable

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05, 2017 at 03:58 PM

    Hello,

    I have created interfaces of revenues MPR and interfaces of expenses MPE. I would like to create a summary table wich contains all the data entered of MPR and MPE

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry, but do you really think it's possible to help you with the information provided?

      This new question is not related to the original discussion!

      Please post a new question with detailed explanation and some screenshots.