Skip to Content
0
Former Member
Feb 16, 2009 at 06:06 PM

Custom field using look up in BEx

48 Views

We have a cube that refreshes from an ODS that's loaded from R/3 SD side. There is a query based on a multi-provider that links this cube and a couple of others. Now, after reviewing the numbers from this query, the users come up with an adjustment percentage based on only 2 characteristics (the query has about 30).

Is there anyway to create a custom field/key figure which will calculate the key figure, multiplied by this new percentage, through an look-up of the 2 characteristics, and return it as a new key figure (adj_key_figure)?

Thanks!