Modeling

[Former Member]

Hi All,

I have a reqirement to Pull an extra field from CRM.

This field is type (INT4) in the table.

This field is required only as an optional drill down in the report

I have the following question

1) In modeling this what type of characteristic info-object is to be created Char or Numc? This field will not be used in any calculation. what are the pros and cons of these?

2) This extractor update type is delta? if I am enhancing the extractor, and if I don't need the history do I need to do the Initialization again?

3) we are on CRM version CRM 2.0C . Is the enhancing the data source step same as we do for R/3? If some one could mention the steps for this?

Regards

Ajay

Points will be assigned for all releted answers

[Former Member · Accepted solution]

HI Ajay

1.In modeling this what type of characteristic info-object is to be created Char or Numc? This field will not be used in any calculation. what are the pros and cons of these?

A numc allows only the numeric characters from 0 to 9.

A Char allows any values

2)) This extractor update type is delta? if I am enhancing the extractor, and if I don't need the history do I need to do the Initialization again

if not requried history, i think you can load delta with out init again

3)we are on CRM version CRM 2.0C . Is the enhancing the data source step same as we do for R/3? If some one could mention the steps for this?

Here we have two technigues either Badi ( Bdoc ) or Funtional exit (CMOD)

better search SDN for steps.

Thanks

Thota

[Former Member]

If I model it as Numc /char how does this effect when I am soring of this field on the report?

You cna sort ascending or decending with the key of the field or the description.

Currently the delta are running from CRM 0CRM_SALES_ACT_1 extractor.

If I am enhancing this data source to add this extra field.

Does it effect the delta that is currently running?

It wont affect delta. but you are right you have to reinitialise the delta if you wish the new field to be extracted with rhe historical data.

There is a Staging ODS . There is data in the ODS and the cube. And from ODS to cube daily load is full load? so to get the history for this field can I do repair full request instead of doing and Init ?

Reparing full request to birng in new fields, I am not sure.

Cube gets data from two different ODS ( CRM ODS and Sales ODS)?

If I am adding this extra characteristic do cube and one of the dimension does this effect the already existing data in the cube?

It will affect the data in the cube, as the data form now on will be of different granularity.

Also I want to conform the step while enhancing the data source?

1)From RSA6 select this data source.

2)click on the enhance the data source. ( Specify name of the field ZZFiledname)

3)In CMOD Write Code to get data for this field.

Is there anything else do I need to do in CRM system other the above 3 steps.

I worked on CRM 4 and 5 and you are on 2, I am not sure if there are any more procedure.

Ravi Thothadri

[Former Member]

1) In modeling this what type of characteristic info-object is to be created Char or Numc? This field will not be used in any calculation. what are the pros and cons of these?

I suggest you keep as char type, though there wont be any difference in keeping as Numc.

2) This extractor update type is delta? if I am enhancing the extractor, and if I don't need the history do I need to do the Initialization again?

Delta initialization and history are totally different concepts. Can I know what exactly are you looking for?

Ravi Thothadri

[Former Member]

Hi Ravi,

If I model it as Numc /char how does this effect when I am soring of this field on the report?

Currently the delta are running from CRM 0CRM_SALES_ACT_1 extractor.

If I am enhancing this data source to add this extra field.

Does it effect the delta that is currently running?

Since the delta is already running if I don't do the initialization again I will not have the history? for this field.

There is a Staging ODS . There is data in the ODS and the cube. And from ODS to cube daily load is full load?

so to get the history for this field can I do repair full request instead of doing and Init ?

Cube gets data from two different ODS ( CRM ODS and Sales ODS)?

If I am adding this extra characteristic do cube and one of the dimension does this effect the already existing data in the cube?

Also I want to conform the step while enhancing the data source?

1)From RSA6 select this data source.

2)click on the enhance the data source. ( Specify name of the field ZZFiledname)

3)In CMOD Write Code to get data for this field.

Is there anything else do I need to do in CRM system other the above 3 steps.

your inputs will be helpful.

Regards

Ajay