Q&A BY TAG 'Cache'

You must sign in to ask a question. If you do not have an account, you can register here

SSRS and Caching
answered 27-02-2019 05:02:03 -0500

I have created an SSRS report with parameters that the user inputs (using ? as parameter in the SQL). The derived view that the SSRS report is using has partial cache mode turned on with match exact queries only selected. It seems as if the report is ...

Answers: 1

cache partial cache ssrs

Cache modes
answered 07-01-2019 17:56:38 -0500

Hi, I'm using the Denodo Express Edition platform and I'm trying to try the partial cache mode with the Match exact queries only option. I have entered Administration> Server configuration and I have activated Cache Status. Then before executing the...

Answers: 1

Partial cache Cache

Cach data using Java
answered 18-12-2018 07:48:12 -0500

--typo on header can not edit :( i want to cache data using java .i have following question 1.Denodo have any API? 2.Please share sample code? i have modifed the denodo jdbc client sample and tried it is not working. please help me on this

Answers: 2

java Cache

Power Query parameters not working when cache is on
answered 14-12-2018 13:01:38 -0500

Hi - I have a view with 1 parameter that I am consuming in Excel through ODBC. I cannot pass the parameter back to Denodo unless the cache is turned off of the view. Is there any solutions for this?

Answers: 1

Power BI Cache

VDP "store results in cache" isn't working
answered 05-11-2018 11:23:16 -0500

when I execute the following SELECT FROM oneview CONTEXT ('i18n'='us_mst', 'cache_preload'='true', 'cache_wait_for_load'='true') it returns around 160 records. However, subsequently when i do select from oneview i get zero records.. why isnt my cache...

Answers: 1

Cache

cache refresh info
answered 07-08-2018 02:22:08 -0400

Hi Guys, is it possible to get a list of views having caching enabled, to check their latest cache refresh using VQL? If not using VQL, does Denodo have other ways to check for caching info about views?

Answers: 1

VQL VDP Cache

Truncate and Drop Data Movement tables from Cache database
answered 13-07-2018 04:37:13 -0400

Hello, How do I remove (Truncate then Drop) the Data Movement tables that have been created in the Cache database? These tables were created - in my example, MySQL - when I had clicked on the Data Movenment option in the Derived View Execution Plan. I...

Answers: 1

data movement tables Cache

Partial Cache not working
answered 12-06-2018 09:20:31 -0400

I have created a derived view ('client') on the top of a Excel and partial cache mode is on. Now I am trying to check how partial cache works.Initially I have around 10 rows. I have also created a base view on the top of cache database. I am executing ...

Answers: 2

Partial cache with different where conditions Cache

Is it possible to query only the data in the Cache of a derived view?
answered 06-04-2018 08:15:25 -0400

Hello - very new to Denodo and running into a questions I am looking for help with. Esentially, I have created an ODBC connection between our denodo databases and Alteryx. I am querying data from a denodo table, but I am only interested in returning da...

Answers: 1

ODBC Alteryx Driver Cache

FULL CACHE
answered 09-03-2018 07:56:04 -0500

Hi: I'm trying to use fullcache for a DV compound of a join between a ODBC and JDBC base views, when executing this DV dv_customer_calls without cache the result is 2512 rows, however when updating the DV to Full Cache it restuns 0 rows. Is this the ex...

Answers: 1

Cache