All Dates displayed for "Characteristic Values" in Query Designer

[Former Member]

Hello Experts,

We are on BI 7.0, level 13. I am having an issue within the Query Designer with regards to dates. I have a write-optimized DSO that contains 3 date fields (for example, ZDATE1, ZDATE2, and ZDATE3). Each date InfoObject is of type DATS so the system automatically creates it with reference to 0DATE.

When I create a query in the Query Designer, on the left hand side, I expand the "Characteristic Values" node under each date field. The Query Designer shows the same list of values for each of the 3 dates even though they are not valid values posted in the DSO for those fields.

For example, ZDATE1 only has 1 value posted in the DSO (01/01/2005).

ZDATE2 only has 1 value posted in the DSO (01/01/2006).

ZDATE3 only has 1 value posted in the DSO (01/01/2007).

Bute when I expand the "Characteristic Values" node in the Query Designer, I see ALL THREE values under each date field. I would expect to only see the 1 value posted for the InfoObject in the DSO. Also note that each InfoObject is defined to show "Only posted values in InfoProvider".

It appears that Query Designer will show all values for the reference InfoObject 0DATE instead of the ones posted to the actual InfoObject in the DSO. If I delete the data in the DSO, the Characteristic Values list still remains because they exist in 0DATE. Anyone encounter this before? How can I get the Characteristic Values list to only show posted values for that InfObject?

Thanks for your help!

J

[Former Member]

Thanks for the response. I went into the DSO and right clicked on each of the Date fields. I looked at the Provider-specific properties and there is the option for "Query Exec.FilterVal" which only restricts what values appear when restricting during execution, not during query creation.

Is there someplace else I should look or someplace else I can make change to only display posted dates when creating a query? Thanks!

[Former Member]

if you right click the IO in DSO you will find an option which shows object specific properties.. there you can find option of what values you want it to display...