設定InfoObject的過濾值

在進報表選擇條件時，選擇某個過濾條件，有可能會把該InfoObject的所有的值顯示出來，而實際上很多都是無效的，如何處理？

 

1. Double Click the InfoCube
From menu select Extras - Strucutre Specific Properties - In the last column called F4 query select only values in InfoProvide

2.Double click ODS
right click IO
select ODS object specific properties
In the option query execution filter value choose only values in provider

3.Double click IO
Go to Business Explorer Tabs
Change settings for following 2:
Query Def. Filter Value Sele
Query Execution Filter Val.

在InfoObject的設定，應該是Cube的預設值，所以在Cube設定的才是最終設定