cancel
Showing results for 
Search instead for 
Did you mean: 

0PCA_C01 PCA: Transaction Data Customizing..

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (5)

Answers (5)

Former Member
0 Kudos

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

Former Member
0 Kudos

Select Timestamp as Timestamp UTC and safety interval upper limit as 1800,it means it will fetch data from the last init or delta to till time. if you loading data to DSO use new status for changed records.

Former Member
0 Kudos

Thank you Kalpana for reply.

Could you please be kind enough to let me know following

1) What is Time Stamp Local and Numeric Pointer?

2) Currently, my requirement is only to use InfoCube, then do I have to select ''Additive Delta''?

3) What if my load data according to this flow then DS>>DSO>>InfoCube? Now, In this case,

     what would be the setting?

Regards

Arshiyan

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member199945
Active Contributor
0 Kudos

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 

RamanKorrapati
Active Contributor
0 Kudos

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.