mapping in bex analyzer

Dear all,

1.In bex analyzer output, for vendor equivalent Type to be Displayed, but the Type w.r.t to vendor does not available in corresponding cube level data, we want only in bex output , where to maintain the data and to retrieve in output.

Example:

Vendor: Type

X A

Y B

Z A

2.The length of the material is 18 digit, one condition is to be checked first 8 digits is to be taken If it contains alphabet the corresponding material should not come in bex analyzer output.

Note: the above two points belongs to same cube data.

kindly suggest suitable solution.

Regards,

U.Linganathan