Custom Query Vs Custom Query Cached On Demand

reut taizi shared this question 8 months ago
Answered

Hi,

It seems that the explanation of both option is equal.

What is the different between them?

What is the best practice?

Thank you,

Reut

c7a59d49daa4e550c16709e27734374a

2be484c95a60531034cf5661ed628c26

Reut Taizi|BI Manager|Galor Systems and Software Development Ltd.|T: +972 (3) 6076300 ext. 341|F: +972 (3) 6076310|reut.taizi@galor.com|www.travelbooster.com

1baaa5670d45106aa7c5927d1020fcb2

Comments (8)

photo
0

Hi Reut,

Thanks for reaching out to support with your question.

As per the wiki, here are the definitions -


Custom Query: Create a list of values by caching the current contents of the field in the database using a custom SQL query.

Custom query cached on demand: Create a list of values by caching the current contents of the field using the custom SQL query each time the report is loaded.


It would depend on your environment and your report filtering needs as to which filter value list setup you would want to implement.


More info on filters can be found here -


https://wiki.yellowfinbi.com/display/user80/Filter+Formatting

Thanks,

Eric

photo
0

Thank you.

So is there a meaning by schedule refreshing with Custom query cached on demand ?

From: Support Queue <support@Yellowfin.bi>

Sent: Tuesday, March 12, 2019 8:16 PM

To: Reut Taizi <reut.taizi@galor.com>

Subject: Re: Custom Query Vs Custom Query Cached On Demand [#12802]

photo
0

Hi Reut,

with the "Custom Query On demand" feature - query is refreshed every time the report is run

as opposed to

Custom Query - query is refreshed when the "refresh" button is pressed

Does that help clarify things for you?

photo
0

Hi, yes I understand.

Although the explanation is not intuitive.

I don’t really understand what is the meaning of cashing if the query run every time the report is open.

Regards,

Reut

From: Support Queue <support@Yellowfin.bi>

Sent: Thursday, March 14, 2019 10:52 PM

To: Reut Taizi <reut.taizi@galor.com>

Subject: Re: Custom Query Vs Custom Query Cached On Demand [#12802]

photo
1

Hi Reut,

Here is a bit more depth on the difference -

https://community.yellowfinbi.com/knowledge-base/article/filter-format-cached-values-on-demand

Does this help?

Thanks,

Eric

photo
1

A little bit,

But still it is difficult for me to see the all picture.

Is there a post explaining all options? With the differences between them?

From: Support Queue <support@Yellowfin.bi>

Sent: Monday, March 18, 2019 6:13 PM

To: Reut Taizi <reut.taizi@galor.com>

Subject: New Comment in "Custom Query Vs Custom Query Cached On Demand"

photo
1

Hi Reut,

The Filter Formatting wiki link has a list of all options, in this case see the Filter Settings - Entry Style section -

https://wiki.yellowfinbi.com/display/USER74/Filter+Formatting

A previous ticket with a bit more context-

https://community.yellowfinbi.com/topic/cached-value-list-clarification

Let me know if you are still having difficulties.

Thanks,

Eric

photo
1

Hi Reut,

I'm going to go ahead and mark this question as Answered. Feel welcome to reach out with further inquiries.

Thanks,

Eric