Skip to Content
0
Former Member
Oct 04, 2009 at 09:39 PM

Formula in conversion file..

217 Views

In the conversion file for dimemsion members...there are 3 header columns.

EXTERNAL

INTERNAL

FORMULA

What is the formula used for ? has some one used it before...

For example I am having a dimension member coming from external system in 6 digits and I need to strip

the first 2 decimal which are leading zero's..

Where this is best addressed ..conversion file or transformation file?

For example 00ABCDEF, need to be converted as ABCDEF..

Appreciate inputs..