Q&A BY TAG 'denodo'
Scheduler: Truncate cache tables instead of invalidating.
answered
23-06-2017 09:17:54 -0400
I have a scheduled VDPCache job which starts every Saturday at 12:00. It invalidates the data for All Rows and load the cache every weekend . This makes the Cache Database keep a lot of invalidated data which is of no use and the disk space consumption...
Answers:
1
Incremental Caching
answered
15-06-2017 06:16:36 -0400
Hello, I am in a situation where I am currently caching on the combined views layer. When I am done caching using Full mode for all the combined views for the first time, I want to keep the scheduled VDPCache jobs every weekend which must do increm...
Answers:
1
Date difference in hour
answered
09-06-2017 05:45:29 -0400
hi, I was wondering how to get hours difference between 2 dates in denodo? It seems like we just have 'getdaysbetween' function. Say, I have a start date of 6/8/2017 8:00:00 and end date of 6/8/2017 9:00:00. Now, I want to get 1 hour that elapsed betwe...
Answers:
1
Creating a field in derived view using something like partition by.
answered
08-06-2017 09:02:58 -0400
I was wondering if I could get some help in terms of calculating a difference between the date of various statuses. I have a view with column named "id", "create_dt" and "status". I would have various statuses like submit, approve, deliver etc. Now, I ...
Answers:
2
Cached data getting deleted as soon as it is done caching in SQL database
answered
06-06-2017 06:41:25 -0400
Hello, I am trying to cache the data using scheduler. There are around 30 views to be cached. 23 of them are having less data (around 10000 all together) and 7 of them are having heavy data (around 80000000 rows all together). So I created two VDPCach...
Answers:
1
Denodo installation steps on mac os
answered
02-06-2017 06:46:27 -0400
Hello everyone, I am absolutely new to denodo tool. I would really appreciate if someone can guide me through simple steps to install denodo on mac. My current mac os version is Mac Sierra 10.12.5 and java version is 8. Please help. I just need to get...
Answers:
1
intellisense not workin
answered
16-05-2017 13:22:38 -0400
Hi, I am new to Denodo and was wondering how intellisense functionality works on Denodo. When writing case statement, the intellisense comes up and once I select the statement and go on to fill in the logic for columns, there is no intellisense. Do I h...
Answers:
2
JSON parameter with OR condition
answered
08-05-2017 06:16:48 -0400
Team, We are creating datasource going into Datasource -> Json and creating datasource connection and creating base view from API 1) We are succesfully able to create Datasource the connection passing below credentials DATA route: HTTP Client HTTP...
Answers:
1
Access Cognos TM1 from Denodo
answered
28-04-2017 07:28:02 -0400
HI We wanted to Access Cognos TM1 from Denodo.INstalled the denodo O data wrapper in denodo What all details required to make successful connection to TM1 but not sure on options to select while creating a Datasource .Any document or link supporting it
Answers:
1
Ways to arrange fields in Derived view into folders
answered
07-04-2017 14:04:36 -0400
Hi Team We are building views in Denodo and have many fields in each of derived views and using Tableau as reporting tool. Wanted to check is there a way we can group fields in folders for view ie Sales View having folders as below as that of other se...
Answers:
2