I came across this problem in PFC 5.4. It is caused by the way pfc
populates the values list. PFC uses the dw column names to create some SQL
to get all the vaules for the column the user has selected. We were using
stored procedures as the data source and the column names returned from the
proc weren't like any table column names so the list didn't populate.
Solution:
a) if possible make your dw column names the same as the column names in the
table in the update properties for the dw.
b) Else, do what I did and re-write the way the list populates to get a non
repeating list of value from the DW itself - don't forget to get values from
the filter buffer or your list will get smaller and smaller.
> -----Original Message-----
> From: Zehrung Joe R COCA [SMTP:[EMAIL PROTECTED]]
> Sent: 02 September 1999 19:07
> To: '[EMAIL PROTECTED]'
> Subject: PFCSIG PFC filter service
>
>
> Has anyone come across the problem in using the simple filter window, the
> value column does not select data into the dropdown.
>
> Is there a fix that has already been worked out?
>
> I am using PB 6.5 with PFC on an NT4.0 system.
>
>
> Thanks
>
> joez
>
> joe r zehrung
> ph: 925-246-5982
> dsn: 350-5982
> e-mail: [EMAIL PROTECTED]
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
> ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
> pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
