Skip to Content
0
Former Member
Apr 28, 2005 at 11:15 PM

InfoSet - No new Filter values possible

22 Views

Hi,

I have created a BW Infoset joining 3 ODSs. All the 3 ODSs are set as not available for reporting. When I use the Query designer and try to restrict on any of the characteristics in the InfoSet the newly loaded values do not show up. I believe it is because the SIDs for those values are not created. Once I execute a dummy report with all the info objects with no restrictions then the SIDs are populated and then I can filter the values in Query designer. But each ODS has over 1 million records and will not be possible to execute individual reports like this.

Can anyone suggest a solution for this.