Q&A

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

Top-down update
answered 24-09-2019 08:19:56 -0400

I have understood that the bottom-up update (narrow black arrows in the picture) takes place in real time, but it is not so clear if the top-down update (fat red arrows in the picture) is possible, and, if this is the case, how? i.e. if an external a...

Answers: 1

scai finance

ERROR: Syntax Error: Exception Parsing query near 'show'
answered 24-09-2019 08:13:43 -0400

Hi, I am trying to get my odbc 64 bit connection working on my pc. my 32 bit works fine. For this 64 bit I am using PostgreSQL Unicode(x64). I have the same settings as my odbc32. Except the postgresql versions are different. 32odbc i run ANSI 9.03...

Answers: 1

PostgreSQL