Ability to set default value based on SQL query

Jenny Kirillova (Leighton) shared this idea 6 years ago
Idea Logged

I need an option to be able to set default filter values dynamically. Something like we do for caching filter values via freehand sql.


Freehand sql for a report default filter values will be great.


Access filters should be considered as well as dependent filters.

This will allow a user to see the report with relevant data rather than empty screen once a report is loaded.

Replies (9)

photo
1

Hey Jenny,

Yulia has raised this enhancement for you, though from what I understand if were were able to implement this idea, then this freehand default value is probably not needed.


Thanks,

David

photo
1

Hi David, I click on 'idea' link and it's not working. Basically we have a data of a very high resolutions with many many rows returned. We cannot cache filters using standard YF functionality. We always cache filter values based on userid using custom freehand sql queries. If your idea allows us to cache filter using Custom queries and then default filter will be returned based on user that logs into application, then YES, that would be unforgettably awesome. At the moment inflexibility of default filters for Yellowfin users with source filters is suffocating.

photo
1

Returning back to this problem... We have three VIP clients with lots of complex reports and now they ask to give access to regional managers and we struggle big deal. So this is something that is swelling really badly and is on it's way to explode sooner than later. Thanks again. Please keep me posted.

photo
1

I agree this is an important feature. We had dynamic default values in SQL Server Reporting Services back in 2005 and it is hurting not having it in Yellowfin. Here's an example use case for us.

- multitenant system with 'standard' YF reports used by many client organisations.

- each client has a different 'base year' for their energy usage. Could be 2006, 2011 etc depending on client. The client wants to see data for their base year as soon as they run a report. They don't want to select the base year, and may not even remember what their organisation's base year is.

- We can easily look up the client's base year in our SQL database using a client code.

- The client may want to select a different base year when analysing their data, so it is not appropriate to simply filter the data by year in the YF View.

SQL Server Reporting Services has the concept of Parameters, including Dynamic Parameters. The value of one Parameter can be used in the evaluation of subsequent Parameters. It would be worth taking a look at that should YF embark on a default filter feature because it is very likely that report authors will want to supply a parameter to a function that returns the default value.

photo
1

Has any progress been made on this? I need to be able to change the default value of a filter dynamically for a report? Thanks

photo
1

Hi Jonah,

I hope all is well,

I can see we have implemented a feature that would assist with this, although this is still in working progress. As it stands we implemented the option of being able set a report for dynamic filter default value. This is only applied on report filters. Going forward we still need to address the option of this with all types of filters such as view level filters, dashboard filters and so on.

What next?

I will make our development team aware of this.

Regards,

Mark

photo
1

Hi Jonah,

I hope all is well and I hope you had a great weekend.

Going forward with this, I have since discussed this with out development team and we come with some questions;

  1. Are you after the first value, and just want that extended to views/dashboards?
  2. Do the want to run a query for each filter to return the default value for the logged in user?

Let me know.

Regards,

Mark

photo
1

Hi Jonah,

I hope all is well,

It's been 11 days since I last heard from you, with this I just want to touch base to see if you had chance to read through my responses. If you can get back to me that would be great.

Regards,

Mark

photo
1

Hi Jonah,

I just want to touch base again with this. If you can get back to me asap, that would be great, going forward if I don't hear back I will go ahead and mark this back to Enhancement Logged and make our development team aware of this until we can get some feed back with regards to my questions;

  1. Are you after the first value, and just want that extended to views/dashboards?
  2. Do the want to run a query for each filter to return the default value for the logged in user?

I hope this is ok, and I hope to hear from you soon, I am very much keen to get this resolved.

Regards,

Mark

Leave a Comment
 
Attach a file