Latest Activity

code

Date difference in hour

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...

DENODO

code

Creating a field in derived view using something like partition by.

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 ...

DENODO

code

Cached data getting deleted as soon as it is done caching in SQL database

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...

Scheduler DENODO denodo scheduler SQL Server

code

Denodo installation steps on mac os

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...

DENODO MAC os new installation

code

intellisense not workin

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...

DENODO

code

JSON parameter with OR condition

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...

DENODO json JSON

code

Access Cognos TM1 from Denodo

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

Denodo TM1

code

Ways to arrange fields in Derived view into folders

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...

DENODO formatting

code

Denodo view in finding out Top 10(customers) by some measure in tableau

We are trying to use Denodo view in finding out Top 10(customers) by some measure in tableau.for this created a set in Tableau with top 10 and pulled in report and gave error "error connecting to denodo odbc" Can you tell any workaround for this or ho...

Denodo denodo with tableau

code

Downloading issue

Hi Team, I am trying to download the Express edition 6.0 but it fails every time in between. Could you help me here.

DENODO