Invalid data filtering

[Former Member]

Hi,

The data coming from source system is containng #.Though it is available in RSKC it is not getting loaded.So, We have decided to take this issue by writing some routines for a particualar infoobjects.Can any one help me to write either Transfer routine or Update routine.

Thanks,

Vasu

[Former Member · Accepted solution]

Hi,

Once again chek the RSKC and type ALL_CAPITAL.

Its always good to write a routine in update rule level.

Cheers,

Malli

[Former Member · Accepted solution]

Thanks.

But what does it make difference If I write a routine at TR rather than UR and also help in coding for a particular Infoobject.

[Former Member · Accepted solution]

Can any one please look into it?

[former_member496813 · Accepted solution]

Trabsfer routine is performed at the info source / comm structure level when the system proceses the data from the data source.

Update routine: at the update rules while procesing data from the info source / comm str.

Transfer are used for example to transform data that is arriving from different DataSource (typical example different CostCenter codes from R/3 and flat files).

In Update I can introduce Routines that select particular Movement Type for a secific KPI or that select Attributes from a Master Data to enrich Cube content. Typical is the example of Purchasing or Movement Cube, where with Process Key and Movement Type you can create specific KeyFigure for specific KPI. For more detail you can also see the Update Rules of the Business Content via RSA1-->Metadata Repository.

But if the same InfoSource is used to upload 3 cubes, and 80% of all the routine is equal it is better to introduce all these routines in Transfer, so these routine will be elaborated one time for all cubes.

Also Check:

Hope it helps..

[pavan_mankineni · Accepted solution]

HI,

for ur issue u can go for formula not for routine in formula we have like REPLACE function using that function u can solve ur issue.

writing routine in transfer rules affect for all the data comming from the source because transfer rules are data source dependent and update rules are data target dependent.

if u write update routine it only affects data which is going into that particular data target.

assign points if it helps,

thanks,

pavan.

[Former Member · Accepted solution]

Thanks.

But What for this REPLACE function is used?

and also please give me code to filter the unwanted data in TR itself.

[Former Member · Accepted solution]

I got the function of REPLACE formula.But allready there is a formula (upper case conversion) for that infoobject.Is it possible to add another formula for the same infobject?

[Former Member · Accepted solution]

Nope, you can't add to formulas, so what you need to do is to write a routine which actually accommodates the new logic to get ride of the # as well as the existing one.

In ABAP, there is something called translate and you can translate all occurances of # to ' ' or something else to get ride of the "#" sign.

This has been a problem but there is also one note you need to apply, that will solve the issue for once and forever, I don't have the note handy.

thanks.

Wond

[Former Member · Accepted solution]

Thanks .

But can u help me by giving that code.so that I can paste the same thing in the TR(just by changing the Infobject name).

[Former Member · Accepted solution]

Can any one please look into it?

[Former Member · Accepted solution]

Can any one help me in coding this please?

[Former Member · Accepted solution]

Can any one please take a look at it?

[Former Member · Accepted solution]

Just I could find some logic

if anyone helps in coding it .it is really appreciated.

RESULT = TRAN_STRUCTURE-Infoboject.

If begining of the Infobject is having a #

then replace it by next character.

if the begining of the Infobject is having a # then replace it by a place.

Hope it gives good hint to help me.

[Former Member · Accepted solution]

Hi Expert's I have written this code in my Transfer Structure.

Hope this is what I required.Please correct me if I am wrong with this code.

RESULT = TRAN_STRUCTURE-/BIC/ZSUBPTITL.

len = strlen( RESULT ).

if RESULT+0(1) = '#'.

REPLACE '#' with RESULT+1(1) into RESULT.

Endif.

if RESULT+len(1) = '#'.

REPLACE '#' with ' ' into RESULT.

Endif

[Former Member]

I am closing this one.

Thanks,

Vasu

[Former Member]

I am closing this one.

Thanks,

Vasu

[Former Member]

I am closing this one.

Thanks,

Vasu