Q&A

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

Authentication with Azure APIM
answered 10-02-2022 06:31:49 -0500

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...

Answers: 1

Subqueries in the WHERE Clause of the Query unable to find the table
answered 10-02-2022 05:59:27 -0500

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...

Answers: 1

Subquery

How to include a subquery in the CASE clause of a field expression
answered 10-02-2022 01:27:40 -0500

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

Answers: 1

CASE Clause

Remote table Vs Cache
answered 09-02-2022 07:43:44 -0500

What is the difference between remote table and cache

Answers: 1

cache Remote table

unable to connect local instance of denodo to azure analysis service
answered 09-02-2022 06:35:33 -0500

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 ...

Answers: 3

Problems in converting oracle math operation and the concatenation operator
answered 09-02-2022 04:57:35 -0500

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...

Answers: 1

Date Conversion concatenate Oracle

Error in CASE Clause end as {name} in field expression
answered 08-02-2022 06:22:45 -0500

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...

Answers: 1

CASE Clause

Access to Oracle Redo Log files
answered 08-02-2022 06:01:04 -0500

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.

Answers: 1

Redo log

Unable to find closed cases
answered 08-02-2022 05:17:50 -0500

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

Answers: 1

Error saving view: Syntax Error: Exception parsing query near '*'
answered 08-02-2022 04:04:27 -0500

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...

Answers: 1

Syntax error