Selection in List box should not affect Layout

[#1]

Hi,

I have a list box...

I want to select this to pass values to variables.

This list box is linked to entire layout.

But I want when I am selecting this list box value ,the layout should nt get affected.

Any options?

[#2]

Do you mean that your selection in the list box should not affect the other objects (Chart etc.) in the layout? If so, implement set analysis in the chart expressions to ignore the selection made in the list box.

or You can create a stand alone table with the list column and use it in the list box. This will not affect any other objects since this table will not be joined with any other table in the model.

-Haneesh

[#3]

Since I have many charts And it was alrdy implemented long back .i cant change the functionality using set analysis now...

What is the second option I think It will be useful..Could you pls explain?

[#4 · Accepted solution]

The second option is to create a stand alone table with the column to be included in the list. Lets say that you need 'Region' column from 'Fact' table in your document to be included in the list. But, the selection made on this list should not affect the other objects.

So, in this case, you create a new table with 'Region' field as follows:

[Region Listbox]:

Load Region as [Reg Listbox] //Make sure there is no column available in the model with this name

resident (Fact);

----------------------------------------------------

You will now have a field [Reg Listbox] which is not joined to any other table. Use this in the list box. Since there is no join with other tables the data in other objects will not be affected if you select any values in the list.

Hope this resolves your issue.

-Haneesh

[#5]

Thanks for ur reply..

yes I 2 worked out in the same way now..