Q&A

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

How to apply text function on field that is used for search method
answered 11-08-2021 19:25:11 -0400

Hello, I want to apply a text function to a field that is used as query parameter for a base view. The reason for that is because we receive some input parameters (for example a number) and I need to add a prefix. If I receive "12345" I need to add "c...

Answers: 1

Denodo 7 search methods

Json array in data set - joining back to original data --- losing records when select * is used
answered 11-08-2021 06:58:14 -0400

I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...

Answers: 2

select query flatten ARRAY missing records JSON join

Denodo access cobol file
answered 11-08-2021 06:01:09 -0400

Hey , please I want to ask if I have cobol copybook file and cobol data file .. is there is way to make denodo read these files and show this data file as relational table in denodo?

Answers: 1

#Source Data

Can SAP Analytics Cloud use Denodo as a Datasource?
answered 11-08-2021 01:51:05 -0400

SAP SAC is one of our main reporting front-end tool. Would like to know if Denodo which contains modeled data from multiple sources can be a datasource to SAP Analytics Cloud(SAC).

Answers: 1

SAP SAC

sort response based on specific order
answered 10-08-2021 18:41:28 -0400

Hi Team, I am developing a denodo odata api by passing filters as entity_id eq 123 or entity_id eq 234 or entity_id eq 124. The response order is different. If I want the response in same order(123, 234,124). Any solution?

Answers: 1

ODATA

Issue while starting Denodo solution manager 8.0
answered 10-08-2021 18:14:08 -0400

Hi team, I have installed solution manager 8.0 in our production linux host today using the install.xml file generated which was explained in unattended installation of olution manager 8.0. License file is copied to the conf folder. But when I start t...

Answers: 3

#DenodoSolutionManager8.0

com.denodo.solutionmanager.exceptions.ValidationException: Cannot load driver class: oracle.jdbc.OracleDriver
answered 10-08-2021 17:58:18 -0400

Hi Team, i tried to create 'solution manager database' as mentioned in the below link & got error as 'Cannot load driver class: oracle.jdbc.OracleDriver' https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/configur...

Answers: 2

Format Odd TEXT Date to Timestamp
answered 10-08-2021 17:57:31 -0400

I have a field called date that is coming in as text as the following format and I am having trouble converting it to a valid time stamp: 9 - Sep - 2019 19:35 Can anyone help with the formatting of the function?

Answers: 4

Date Conversion Date time stamp timestamp

Create a rank in a view
answered 10-08-2021 17:28:09 -0400

Hi, I have a view created from delimited file with fields bd, date, count and i need create a rank by bd and date. I try ROWNUMBER() OVER ( PARTITION BY ORDER BY _ ) and RANK() OVER ( PARTITION BY ORDER BY ) but it´s nos work. I try case bd when 1 th...

Answers: 1

Rownum() Over & Rank() Over

Condition based Join of 3 tables
answered 10-08-2021 13:41:59 -0400

I am having 3 tables - A, B, C. I need 4 kinds of output Case 1 : If condition 1 and 2 both not satisfied : Sel from A Case 2 : If condition 1 satisfies : Sel A. from A Inner Join B Case 3 : If condition 2 satisfies : sel A. from A Inner Join C Case ...

Answers: 2

join CASE switch