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

Mapping ..help required!!!!!!

Hi ,

I am new to BPC and Now we are using BPC NW 7.5 version.

I have actual data in BW with no entity ..below is data format in my cube .

account---profit center---time --amount

acc1---101--2007.01--10000

acc2---102--2007.01--20000

we have profit center dimension in BPC ( P_PC ) and entity is one of the property in this dimension and we are manually updating this dimension.

id --dec---entity

101--xxx---a

102--yyy--b

I want create record with entity in BPC while loading above data in BPC .

Ex :

account---profit center--entity --time --amount

acc1---101----a--2007.01--10000

acc2---102---b---2007.01--20000

I want help on which is the best approach ...script logic while loading or badi or transformations for meet above requirement .

Thanks,

PSR.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2013 at 06:02 AM

    Hi PSR,

    Usually, there are mainly 3 options for maintenance of mapping:

    a. Transformation or conversion files

    b. Script logic

    c. Start / End Routine

    For your scenario, the first option will not work; since you need to get the property value from the BPC dimension.

    The second option is technically feasible but has some drawbacks. One option would be to keep the logic in default script. But then, this will run every time, some data is sent. Another option would be maintain it as a separate logic. But in this case, the user needs to run this script logic.

    I believe the third option is most suitable for you, by maintaining start / end routine using BADI.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi PSR,

      If you go with the option of script logic, then you need to create a new script (not default). This needs to be linked to a custom DM package. Then you can create a package link which will first execute the import DM and then your custom DM.

      Hope this helps.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2013 at 05:17 AM

    Hi PSR,

    It depends on what are the different reports you may need to develop and what is the relation of ENTITY with PC.

    I would suggest -

    1. If it is One-To-Many (for one entity, there are many PCs) - You create ENTITY as a dimension where you would have A & B as entities, P_PC as your 'U' type of dimension where you would have 101 & 102 as profit centers. This way, you can have the data as expected i.e.

    Acct1, 101, A, 2007.01, 10000

    ACCT2, 102, B, 2007.01, 20000

    2. If there is one-to-one relation with the Entity & profit center, then you need to have Entity dimension, where you can have a property called 'Profit Center'. Hence, no need to have separate dimension for PC. When you create a report, you can pull the "PC" property from Entity dimension. This way, you would have the data in cube as

    ACCT1, A, 2007.01, 10000

    ACCT2, B, 2007.01, 20000

    Hope this helps.

    Regards,

    Rashmi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2013 at 05:22 AM

    Hi PSR,

    First load all master data from BW to BPC dimensions.

    While loading master data for Profictr dimension, in transformations

    you mentions as

    ID=ID

    ENTITY=BW info object which values you want pass to entity.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2013 at 07:53 AM

    hello sir i want some help regarding script logic

    i am having the data like

    chemicals 2009.total 2008.total 2007.total diff.1 diff.2

    1 3000 .... .......

    2 4000 ..... ..........

    3 5000 ....... .....

    4 6000 ...... ......

    now i want 2009.total/2008.total to be displayed in diff.1 and 2009.total/2007.total in diff.2

    please help me

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2013 at 09:22 AM

    Hi

    Use this simple approach, no hassle.

    Transformation File

    *MAPPING

    ACCOUNT=0GLACCOUNT

    PROFITCENTER=0PROFITCENTER

    ENTITY=0PROFITCENTER

    TIME=0FISCPER

    AMOUNT=0KEYFIGURE

    Entity Conversion File

    EXTERNAL:INTERNAL

    101:A

    102:B

    Viola, you get what you want.

    Halomoan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Actually what I gave is a human readable solution and every consultant or even the business users are able to do it and get the result. They can do the maintenance and changes by themselves. I remember how SAP sales said that BPC is meant for a business user instead of the IT.

      If you prefer a custom coding solution such as DM BADI routine or what ever ABAP coding to solve the issue, it is fine, your choice, but try to ask the same question like you mentioned above what IF one day (3 years from now) you have to add or change something. Where is the ABAPer ? Where is the doc? How much I have to pay a consultant to fix it?

      Back to the owner of this thread, what is his/her choice. There are many ways to the Rome.

      😊

      Halomoan

Before answering

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

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