Latest Activity

code

Error when using RANK function for SAP data source

Hi, I am getting error while using a RANK function in Denodo v7. Error: "Finished with error: Error executing view: Function rank is not executable" Please let me know Will denodo support RANK function for SAP data source? If Yes, let me know how to f...

SAP BO RANK Function DENODO RANK Rank

code

Denodo view expose into kafka

Hello, I have some views in Denodo and I waant tthem to be exposed into kafka The views can be exposed to kafka using creating a REST API. Question Moreover is it possbile to send the view without an API? Can we expose the views using VCS int...

Denodo kafka

code

Denodo 7.0 - Estimate and Actual Memory Used by a Query

We're encountering an error suggesting a query is too large. How do you derive the estimated and actual memory of a query? -John

Maximum Query Memory DENODO Memory Settings

code

Denodo unable to fetch all the records for an entity which contains different Schemas file extensions for the parquet files from S3

Hello, I tried to create a base with file pattern (.) for the parquet file entity/table in s3 region. Then, when i excute the count query to fetch all the recodrs in the entity.I could able to get the below mentioned error. Finished with error: Error ...

custom S3 HDFSCustomWrapper; S3 DENODO AWS S3 Create Base View

code

Bring rules of the tables to base views

we have implemented security on tables in sql server ...we are using denodo 7.0.when we import the tables to create the base view do they bring them all or do we need to recreate them all again in denodo ? the denodo security doc dont have any comments...

Access Denodo Express DENODO

code

How to convert a date in string format to interval date

Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,

Date Conversion VDP DENODO

code

"SELECT top 1 1 as ID FROM <base view> uanble to excute

We have connected the SAP Database. when we are unable to excute the below query "SELECT top 1 1 as ID FROM &lt;base view&gt; " for the expected result ID 1 what changes can be done as the expected result thanks in Advance

Top N SAP DENODO SAP BW/4HANA denodo with tableau

code

The version of Denodo on which window (analytic) function of SQL can be used

&lt;Reference&gt; https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&amp;title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F &lt;Denodo VDP Version&gt; 6.0 Administration tool:...

DENODO #Analytic function

code

Continuous Error at Excel Microsoft Query data retrieval from Denodo (6.0) through ODBC connectivity

All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. &lt;Error Description when retrieving data from De...

ODBC Excel Microsoft Query DENODO data types

code

Fetching Column issue in VQL

we have SAP Data Base, when we excute the base view in the denodo tool we could able get the 150 records. But, while excuting in the VQL shell for the specific Query like Select &lt;Column_name&gt; from &lt;data_base&gt;.&lt;Base_view_name&gt; throwin...

VQL SAP DENODO SAP BW/4HANA