Restrictions not working in BO Webi Report
I have created a universe on BEx query. Now on this universe when i create reports with restrictions the restrictions are not working.
If i create a BO query with restriction say Doc_Number= 108994 and display Doc_Number and Delivery_Number then:
in Doc_Number column i get 108994 but in Delivery_Number column i get all the delivery numbers from the cube. In other words all Delivery_Numbers are retrieved when i restrict data for one Doc_Number and vice versa is also true.
Can anyone help me solve this issue?
Try to restrict the variable of Document number on the Key figure not in the global filter and let me know.
right click your key figure under restrict put your variable of document number.