Value helps on a crossTab

[Former Member]

I've modelled a BEx query and displayed it using a crossTab in Design studio.

On this query I have a few characteristics being used as key figures, which are input ready.

1. Now I am a bit confused as to how to display a value help or a drop down for these fields, which will show the master data maintained on that info object, which can then be used by the user to select a value.

I have seen examples where a dropdown field is used, and the function getMembers is used, but how will that help to enter data directly into the crossTab?

2. I also have a query on how to make a particular cell disabled based on a value on another field. With Analysis for Office, we could write a macro to achieve this.

3. Since I have modelled characteristics as key figures, i can only enter numbers.

As an example, i have product type, which the user has to select on the input ready query.

The master data is below.

Key Text

1 Lifestyle

2 General

3 Specific

etc.

Now, the user sees only either 1, 2 or three on the query.

How do I display the text of the selected value?

[former_member225192]

can anyone confirm if this is officially supported? I am trying it with Design Studio 1.6 SP6 and the key figure value (of the characteristic) does not provide any input help. I have tried both the spreadsheet and the crosstab components. I have checked that there is Master Data for the infoobject (as per above suggestion). This does work in Analysis for Office (Excel). will the value help component in Lumira Designer 2.0 provide this functionality?