Getting Dimension Based on Measure

[AQuinn]

I need to display a field like the following (in Business Objects 5.1.3) in a crosstab:

= <Dimension> Where (<Measure> = &quot;constant&quot

However, the Where clause only works using the following syntax:

= <Measure> Where (<Dimension> = &quot;constant&quot

Does anyone know how I can get an associated Dimension from a condition on a Measure, as shown in the first formula? I've tried casting the Measure as a Dimension, but Business Objects won't let me do this; it keeps changing the data type back to Measure.

Thanks in advance!
AQuinn

 

[jshree]

Try this: In the universe define another dimension object that is a character equivalent of your measure object and use this in your condition. Make sure the object's property is set to 'dimension'.

 

[AndyEdwards]

Firstly I would try using an if statement instead of a where:
= If <measure> = &quot;constant&quot; then <dimension>

If that doesn't work try a filter:
Format > Filters
select the crosstab and add a filter
choose the measure and either select the value you want to filter on or
select define and enter the value in the formula box.