How to implement below query through yellowfin report builder

Hi Nathan,

I am going to try it with freehand SQL.Will keep you posted.

Thanks!

Hi Nathan,

I am able to create it using Stored Procedure.SO I have created a view to be based on this stored proc and report over it.But in my output all the filters(which are basically IN parameters of stored procedure) are marked as mandatory.Could you advise me on making some filters non-mandatory.

Hi Mukta,

Any filter passed as a parameter to the stored procedure will be mandatory. If you remove all but essential where clauses from your report, you can create these as normal filters in Yellowfin which will not be mandatory. Let me know if this makes sense.

Regards,

Nathan

Could you please elaborate it further?

Hi MuktaWhen you create a stored procedure you can create filters. As an example, say this is your stored proc:

myproc(date my_date){
SELECT * FROM table
WHERE date_field > my_date
}

This procedure accepts a date field, which it then uses in the WHERE clause. In Yellowfin the "my_date" field will always be a mandatory filter, as it is a mandatory parameter to the stored procedure. The stored procedure will always be run before the report, with the filter value provided to the mandatory filter.

In addition to this filter, you can also add normal Yellowfin filters at the report level. These will not be mandatory. In the screen-shot below, the red date filter is mandatory because it is an argument to my stored procedure.

Let me know if this makes more sense!

Regards,

Nathan