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!