I am struggling and SAP seems lost on the actual issue. Looking for any help. I have a Universe comprised of a single table containing information on Projects. On my webi report, I have a query filter called WBS Code that is set up as “Matches Pattern,” Prompt, and using the Wildcard (%) as a default value. When I select a project name and then select the code I’m looking for under that project, the WBS Code filter works as normal and returns data. If I do not enter a WBS Code and leave the default value as the % and select a project that does not have a value within the WBS Code…the report retrieves no data. Shouldn’t the report still retrieve the data based off the other filters regardless of values in the WBS Code when the % is left as default?
It may be that Business Objects doesn’t return anything in this case because there is nothing to compare the % to. A better option for this case may be to make the WBS Code prompt an optional prompt so it can be skipped if you don’t supply a value.
2 Likes