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.