Latest Activity

code

where to put daily/monthly filter?

If we need to filter daily or monthly state data for final view built in Denodo which is like joining to a date table with the daily/monthly columns to match the date and filter. The view will have good complexity with multiple joins/unions, so where d...

code

How to split then flatten with row number (index of the item flattened)?

Hi, I have a question regarding how to perform an operation in Denodo. I have data in a base view (on a Snowflake data source) that looks like: | Order_number | Icd10_codes | Icd9_codes | | -------- | -------- | -------- | | 1001 | 100.1,101.2 | | | 10...

code

Can't connect to JDBC for acme_crm_ds tutorial

Hi I was following the tutorial https://community.denodo.com/tutorials/browse/basics/2fs5jdbc Errors and driver configuration https://imgur.com/a/cQXuLZR Any idea if the configuration on my end is wrong?

code

What happens if license/temp license expires

What happens if license/temparary license expires in existing envirnoment.

code

Exclude server-specific parameters while exporting VAL from denodo design studio

Is there a way to omit any server-specific parameters from the whole export of the Denodo design studio UI, such as 'com.denodo.vdb.vdbinterface.server.VDBManagerImpl.registryURL'. Additionally, we are aware that it may be excluded when exporting data ...

code

Power BI Data Set Incremental Refresh

Hi Team, Currently I'm working Denodo 8 and using Power BI as a reporting tool. Data flows from left right as mentioned below. Data Warehouse -> Denodo Views (Views Created on DWH tables) -> Reports Created on Denodo Views. We are using ODBC an...

code

Denodo - extracting certain text from a field using regular expression

Hello Denodo Geeks, I am trying to extract certain text from a field in denodo using regular expression. To a certain extend I am able to acheive my target, but there a certain text values in the field that do not work as intented. Here is an example ...

code

Convert calenderweek and year to date

Hi guys, I am facing the following converting issue in denodo. I have to convert the formats yyww, yyyyww, wwyy and ww/yy into the date 'dd.MM.yyyy'. Does anyone of you have an solution for this problem I am facing right now? Thanks Johannes

code

how to avoid time zone conversion in Denodo ?

Hi, Is there a way we can avoid any implicit timezone conversion in Denodo ? We have a column in a table which house datetime from different regions of US along with an additional Flag column which tells us about the time zone of the row. In this scena...

code

I need to send multiple query parameters to a field in REST API

Hi, can us help me with that? i want to know if is possible to send multiple query parameters like "field in (value 1, value2, valueN)" to a field in REST API. The goal is to use a single 'GET' but 'IN' condition, or also if there was a way to edit the...