on 07-30-2010 7:12 PM
hi gurus
i have data coming from two different sources i have to compare both side fields in one dso and show it into the report
i have validation dso i musing select comman in endroutine to pick up the data from the other dso but somehow the data is not coming into the field is there any other way to do that
thanks
Hi,
It needs to be compared at staging level/loading only.
Check the code. Check if the data types of objects are matching or not.
I hope it will help.
Thanks,
S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
kkk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
helpfull
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i m using fuction conversion_exit_alpha_output to eliminate leading zeroes now this i m using in transformation routine
now i have requirement to use this programme in more than one field how do i do that .
thanks.i have done that with one filed that works fine but in the same structre i have more than one fields and in transformation routine its only taking o
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi again,
Unless both the fields are included for the end routine within transformation, you can include the conversion there. Alternately, within transformation, you map the source fields to the destination DSO. You can include the alpha conversion in there. In the assignment (double click the line or "=") and select formula and select alpha conversion.
Hope it helps
hi
i m trying to use transfer routine in multiple fileds but i cannot. its only apply for one fileld.what is the alternate way
like im trying to use the conversion_exit_alpha_output but it only works for one infoobject i have more than one infoobjects that has leading zeores coming in data.
thanks
Hi gurus
i m using fuction conversion_exit_alpha_output to eliminate leading zeroes now this i m using in transformation routine
now i have requirement to use this programme in more than one field how do i do that .
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can include the code and logic in your End routine to do the comparison and field assignment. If you are storing the data from the 2 sources in DSOs, The fields (to be compared) would be
Step 1:Create an Internal table for SOURCE_PACKAGE, and 2 DSO
create variable for the final field
Step2: populate the data in the internal table of DSO1(type /bic/azDSO for custom DSO and /bi0/a0DSO ) & DSO2 based on selection criteria = Source_package-field
include logic to compare and assign the final field = <DSO-field.
Loop at IT_Source_package
move corresponding values from type table to IT_source_package
Endloop.
Append IT_Source_Package to Source_Package
hope this helps.
Samir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
or is there are option we can compare two dso data in bex analyzer?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.