Skip to Content
0
Jun 12, 2007 at 08:25 PM

Replace an existing field value with another in BEx query.....

67 Views

Hello

I'm not a guru in BEx, so I thought some-one here could point me in the right direction. Basically we have a compound master data object - and the cube is populated for both these fields. However, we have a user that would like to get a report where the all values gets replaced by a standard value. So... we can't restrict the value, as the one she wants doesn't exist in the cube. So...I'm thinking BEx needs to be fooled into thinking that the field is populated by this standard value to read the relevant data from the master data object. As an example - a material plant object. In the cube it will be plant A with material 123. However, she wants to replace the value of the plant with B, and keep the material value the same ie 123 so that we can read the MD with this value instead.

Any help would be greatly appreciated.

Thanks