Q&A

How to Convert datatype from Text to Date?
answered 08-10-2019 21:18:06 -0400

HI Team, My base view has a date field which is in datatype text ( Varchar-50) and giving value '20190910172316' . I tried to convert the same to date by using " to_date('yyyyMMddhhmmss' , base_view.eff_dt ) as eff_dt " in derived view layer. it worke...

Answers: 1

Date Conversion

No array data from tutorial web service
answered 08-10-2019 10:34:57 -0400

Hi I am following the online tutorial and when executing a query on the web service on 'C003' I get an array come back however there is no data in the array. According to the online tutorial I should be seeing 2 records in the array. Any tips on how I...

Answers: 3

Is there a way to create the Base Views directly from erwin files or erwin xml files instead of creating the base views individually
answered 04-10-2019 07:40:18 -0400

Is there a way to create the Base Views directly from erwin files or erwin xml files instead of creating the base views individually. We generally create base views connecting to a database where the datamodel of EDW is sitting, but is there a way to c...

Answers: 3

#erwin #datamodel

i18n View Locale
answered 04-10-2019 06:50:07 -0400

Is there something we can run to pull out the base views which have a different map from the default for both the searchmethod and the view, itself?

Answers: 1

query to get i18n type

Denodo alternative for TSQL "STUFF.... FOR XML PATH"
answered 04-10-2019 02:35:33 -0400

Hi, I have a table with multiple rows and a single column called ID - it is aways 5 chars long ID 12345 23456 34567 I want to create a view with a single column output and a single row output that will concatentate all the values inserting a com...

Answers: 2

ARRAY

Denodo Architecture for Developer and Administrato
answered 03-10-2019 07:24:19 -0400

Hi, I just downloaded Denodo Express and started importing some sources. I was wondering how I shoould be using Denodo in my Company, for example, is it right to install denodo in a server and then let the developer connect to this server using their...

Answers: 1

Access Denodo Express Administration Tool

Denodo Data Catalog tutorials
answered 03-10-2019 07:01:09 -0400

Hi Team, Can anyone suggest me some links to understand denodo data catalog better? I had a good read about it few weeks before, but am not able to find the content now, when I searched Thanks for your help, Manju

Answers: 1

#data catalog

Denodo 7 data catalog: share (explore) queries
answered 02-10-2019 14:06:24 -0400

Hello, For the Denodo catalog, what is the recommended way for a user to share a query, is it possible via the web interface? to other data catalog users? can it be shared so that other catalog users can see updates after obtaining access to the s...

Answers: 1

Delimited file sources- rows to columns
answered 02-10-2019 09:51:06 -0400

Hi, I'm having an issue with a delimited file source. The file is actually a column from a big query wich contains a CLOB, that clob has the next format : parameter1:value1;parameter2:value2;parameter[n]:value[n]; ........ What i want is to convert ...

Answers: 2

delimited file sources rows columns pattern tupple

get_view_columns
answered 01-10-2019 06:44:41 -0400

We are using the get_view_columns() function to pull denodo interfaces and columns into the MicroStrategy warehouse catalog. We have run into an issue that if a transformation has had manual vql manipulation, the function fails to return all columns. ...

Answers: 1

Microstrategy VQL get_view_columns