Latest Activity

code

Authentication with Azure APIM

Does anyone have a working example of authentication against Denodo using Basic Auth or Basic Auth with VDP using Azure APIM and Azure Policy? I am trying to send a basic auth header from Azure APIM against a known username that works, but I am finding...

code

Subqueries in the WHERE Clause of the Query unable to find the table

Hello, I have added multiple tables in the view and joined all those tables. In the WHERE CONDITIONS, I have written something similar to this: A IN (select A from TABLEA where TABLEA.A=TABLEB.A ). It has been validated successfully, but when I want t...

code

How to include a subquery in the CASE clause of a field expression

Hi Denodo Team, Is there any function to add subquery in CASE clause of field expression? For example, case when Type like 'something' then 0 else (select a from table1 where table1.a=table2.a) end

code

Remote table Vs Cache

What is the difference between remote table and cache

code

unable to connect local instance of denodo to azure analysis service

i have an azure account and i am trying to connect azure analysis service to denodo. it gives me a strange error: Unable to connect to the multidimensional server: unknown protocol: asazure I am able to connect my local SSMS and power bi to the azure ...

code

Problems in converting oracle math operation and the concatenation operator

Hi support team, I'm having trouble putting this query into my view WHERE CONDITIONS, there is an AND Operators in front of the line This is my original query from oracle ... AND datedata+(8/24)>=todate(tochar((sysdate+16/24)-1,'YYYY-MM-DD')|| '00...

code

Error in CASE Clause end as {name} in field expression

Dear support team, I have a problem in putting a specific column name in my case clause, below is the line I'm running in the field expression. When i set it to end as priority it shows that "Could't repair and continue parse" but when i set the it as...

code

Access to Oracle Redo Log files

Is it possible to access and read Oracle redo log files and Oracle archived redo log files from Denodo 8? Access can be done through Oracle LogMiner via the 'V$Logmnr_contents' view and then SQL, but I want to access the view directly via Denodo 8.

code

Unable to find closed cases

Hi , i am unable to search case where i was added as contributer. is it because this is closed? if yes, how can i search those cases

code

Error saving view: Syntax Error: Exception parsing query near '*'

Hello, I am working through the lab LAB Create an Aggregation View (DEN80EDU12D08LAB01). When I get to step 5 Specify a where condition to filter the data using those parameters: to_localdate('yyyy-MM-dd''T''HH:mm:ss', bv_sales_all.saledate) between s...