As my title, I'm in this trouble. When I create a BI publisher report, it's show all of value, I just can filter after that.

Can someone tell me know how can I filter values before show it in BI publisher report?

Like I call a Store Procedure and parse parameters, and then It show values

Ex: EXEC schema.SPStudents(001,Chris,Smalling,18,etc,...);

Now I'm using Oracle 12c.


  • Which BI tool are you using? Jun 3 '19 at 9:59
  • @Vérace OBIEE 12c
    – Mr. Falcon
    Jun 4 '19 at 8:56
  • Can you run any query direct through SQL*Plus or SQLDeveloper? You should provide here the details of your tables (as text - no screenshots) and the full text of your Stored Procedure. Jun 4 '19 at 9:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.