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

0PCA_C01 PCA: Transaction Data Customizing..

Hello Experts

I am on BW 7.3 Sp 3. It is my first time to work on such type of scenario. therefore, I need some help and suggestion.

I have given an a InfoCube PCA: Transaction Data 0PCA_C01.

I need to add up, in Account Dimension: Account Number 0GL_ACCOUNT and Financial Statement Text 0GLACCEXT

I need to create a new Dimension''Material'' and need to add 0Material and 0Mat_Sales

as well as, six keyfigures whcih are:

i) Revenue ii) Variable Manufacturing Cost iii) Fixed Manufacturing Cost iv) Contribution Margin v) Gross Margin vi) Quantity

I also have two hierarchies: Account Number and Profit Centrer

I have following questions in your honour:

1) On RSA3, its DataSource 0EC_PCA_1 showing 0 records? What's wrong?

2) How to tackle this kind of scenario?

3) What is delta type of 0EC_PCA_1, weather it would be Init with Data Transfer or Init Without Data Transfer?

4) This DataSource doesn't have 0Material, 0Cal Day, 0Cal Month and 0Cal Year Monnth, 0Account and Financial Statement item, then Do I have to enhance this

DataSource, Or, Is there other DataSource, I need to use for this purpose or what to do if I use same DataSource?

5) Any other thing I have to perform or take care, please let me know especially, adding up 0Material and Mat_Sales and above key figures?

Please elaborate step by step,

Regards,

Arshiyan

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2013 at 10:30 AM

    Hi Arshiyan,

    1) Check your data source " 0EC_PCA_1" table in R3. From which table this data source getting data. Check data availability in table level.

    2) The Standard cube "0PCA_C01" which give periods based on Profit center's.

    3) You are including 2 new dimension in existing cube and 6 Key figure. Now, your requirement is you should find the respective source field in data source, if available you may directly map to info provider otherwise you should enhance from table like GLPCT.

    4) This data source which supports only full update mode. Plz find below link for delta for above data source.

    " http://help.sap.com/saphelp_nw04/helpdata/en/de/46663758459166e10000009b38f8cf/frameset.htm "

    5) If your data source does not have " 0Material , 0calday , 0calmonth, & your financial items, you should enhance the datasource . Then only you may get data and map the fields to Info provider.

    6) First please check the tables and header and line item details, then only we come to conclude whether we can get directly or we can do generic. Please check your functional consultant along with your requirement.

    Regards,

    Baskaran.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 27, 2013 at 07:08 AM

    Hi,

    1. Assuming your system will be fresh one. so no entries at your base tables. might be your getting 0 records at RSA3.

    2. Check the base tables have data or not.

    3. Once data source supports delta then we can do it in any way. Init with data or init with out data.

    you can check about data source delta supports or not by using table - ROOSOURCE, field - DELTA.

    4. Please check your technical specs and requirement then do it accordingly.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 27, 2013 at 08:17 AM

    1. First Check data sources base tables either data is available or not.

    2. Search same data source name with help.sap.com you will get relevant information either data source supports delta/full and Mandatory settings what we need to consider at the time of using this data source.

    0EC_PCA_1 help.sap.com.


    3. Need to enhance data source if relevant fields not available , for time characteristics like cal day, calmonth no need to do any enhancement.


    Note : First check both info cube and data source in help.sap.com

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 06:51 AM

    Why you are going for generic data source, is there any specific reason? why don't you go for standard 0EC_PCA_1 delta.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 12:53 PM

    Hello

    Thank you very much for your input. I have created 100% Customise InfoCube and created structure.

    Now, I am going to customise one DataSource for my scenario which would use for daily and monthly analysis.

    Please have a look a above post for screen shot and following are my questions..

    Q1) please let me know for my daily and month analysis which options for Generic delta I suppose to choose?

    2) How to create hierarchy for account number and profit centre? Could you please elaborate step by step?

    Your input would be appreciated!

    Regards

    Arshiyan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Numeric pointer only for new records, changes to existing records not be consider as delta to bw. When we are using this option we have confirm that there won’t be any changes to already loaded records to BW.Yes if your requirement to load data to cube select additive Delta.

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 02:02 AM

    Thanks very much for reply.

    I have decided to do customising a DataSource Z_EC_PCA_1 for my above scenario and two InfoCubes

    and I have created and ready InfoCube structure.

    i) -One InfoCube for daily analysis ii)Second InfoCube for Monthly analysis


    Now, I tried to customised DataSource on RSO2, i got stuck which option I need to choose.

    I have following questions in your regard

    Q1) While customising, Daily Analysis DataSource, on Generic Delta pop up window, which options to choose

    i) Time Stamp UTC ii) Time Stamp Local iii) Calend Day iv)Numeric Pointer

    Settings:


    i) New Status for Change Records ii)Additive Delta

    Q2) While customising, Monthly Analysis DataSource, on Generic Delta pop up window, which options to choose. from above given options?

    Q3) I have two hierarchies, which are not included in a standard InfoCube, now I have to create a new dimension in the InfoCube to add up? or how to add up hierarchies in a customising InfoCube?

    Your input world be appreciated!

    Regards

    Arshiyan


    custom ds.png (21.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Arshiyan,

      If you have timestamp/calmonth in your datasource then you can use delta based on timestamp/Calender day but 0EC_PCA_1 is based on delta pointer so better to use the same only.

      Regarding hierarchy you have to create hierarchy on your master data not in infocube. You can create hierarchy on your master data account number and profit center then you can use in your BEx report directly from master data.

      Hope this will help.

      Best Regards,

      Kamal

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.