Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

SQL Query Reference
answered 27-09-2019 02:20:20 -0400

We have a customer who is trying to use our software to query via ODBC a Denodo virtual database. Apparently something about the way we format the SELECT statement is not liked by your query engine. Where can I find a reference on your SQL query lang...

Answers: 1

Vertical pivoting
answered 27-09-2019 02:05:46 -0400

Hi Team, Is there a way to do vertical pivoting in denodo? I have one data element which is a combination of 3 fields basically seperated by ~. Example: abc~dfv~1234 cvfdv~as~23 So the first seperation till ~ belongs to field A, second part belongs to...

Answers: 1

#array #customfunction

Caching Intermediate views
answered 26-09-2019 08:30:43 -0400

We have a requirement to cache an Intermediate view and it should never expire. We don't want it to be done manually for every single run. We need to implement it permanently. How do we do it in VDP or VQL Shell? We tried doing it by ticking the check ...

Answers: 1

JSON Resource cannot be created due to problem with charset?
answered 26-09-2019 05:19:10 -0400

When creating the base view of a new JSON resource I get this error: ( ISO-8859-1) Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Unexpected character ('­' (code 173)): expected a valid value (number, String, ...

Answers: 3

JSON

Assign restrictions without execute rights
answered 26-09-2019 05:05:16 -0400

Hello, I have multiple interface views in my report layer with customer sales and sales figures. I used the 'Assign Restrictions' function in a shared base view, so for example German users could only see sales data from Germany. Which also worked very...

Answers: 3

Role and User Management

When use map function, the query plan change, query take much more cost
answered 26-09-2019 01:26:13 -0400

I create a map manully and want to use this map to finish some augument convert, yes the augument can convert, but the query plan changed, the query take much more cost: select count() from AA where "WID" = 2020092 select count() from AA where "WID" = ...

Answers: 2

map query plan

What to use instead of ResultSet.TYPE_SCROLL_INSENSITIVE
answered 25-09-2019 12:00:57 -0400

I am aware that ResultSet.TYPE_SCROLL_INSENSITIVE is not supported by denodo currently. Do you have a suggestion as to what I can use instead to retrieve the row count of the result set?

Answers: 3

row number Resu type_scroll_insensitive

Unable to use Power BI Denodo connector for views with column restrictions
answered 25-09-2019 08:58:07 -0400

We are utilizing 7.0, update 20181011. Power BI users that do not have access to all columns of a view are unable to utilize the Denodo connector. They see an error due to the fact that not all of the columns can be projected and they can not get to th...

Answers: 3

Power BI

Create variable or custom date in denodo
answered 25-09-2019 08:08:21 -0400

Hi, In scheduler output file name, i'm looking to get yesterday's date. Currently we can use only 4 variables which are jobid, jobstarttime, projectname, jobname. So how can i get previous date as output file name. Or how to create a custom exporter fo...

Answers: 1

How to create map with query a view? where is my map
answered 24-09-2019 08:27:55 -0400

Hi team, I create a map with below and it can be used. CREATE MAP SIMPLE dates_test ( 20190701 = 2020091 20190702 = 2020092 20190703 = 2020093 ) Question is: I looked for all my database, I cannot found this map? where is located in? Also, since I have...

Answers: 1

map