Q&A BY TAG 'denodo 6.0'

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

Formatdate() different behaviour to fetch MMM i.e month
answered 14-09-2016 09:31:44 -0400

We wish to have month in following format i.e first letter capital. Jan Feb Mar Apr When we are running below function, it return month in capital i.e JAN, FEB, MAR etc if derived view is used based on Oracle data source. formatdate(' (MMM)', CURRENT...

Answers: 1

denodo 6.0

License Issue
answered 13-09-2016 05:38:05 -0400

**Hi Actually I am just starting this technology.I have correctly Installed everything. But still I am finding some features are not allowed with this license.Such as User role management in Administration tab. Please let me know what kind of license I...

Answers: 3

denodo 6.0

INERT, UPDATE, DELETE operations from Denodo
answered 13-09-2016 05:11:01 -0400

I can see there is mention of DML operation syntax in VQL guide. May I know how can we use it? I know we can set properties at data source level to allow INSERT, UPDATE, DELETE but wondering how can we use mentioned script from Denodo tool. What I am t...

Answers: 1

denodo 6.0

How to stop full cache getting invalidated?
answered 24-08-2016 07:51:29 -0400

I know there would be way and mentioned in document but thought to check if it is possible. When we change any code in DV layer, cache is getting invalidated. I want to stop it.

Answers: 1

denodo 6.0

DATE with Time Is not Matching
answered 12-08-2016 09:08:34 -0400

Hi Team, I am running Denodo testing tool to test the query in Denodo 5.5 and Denodo 6. I am getting all columns value same but not for date column. in Denodo 6 : Mon Aug 01 00:00:00 MDT 2016 in Denodo 5.5 : Mon Aug 01 12:26:14 MDT 2016 I am gettin...

Answers: 3

denodo 6.0 Date

Single-key association vs Multiple-key association
answered 11-08-2016 05:41:01 -0400

I have one dimension table (PRINCIPAL) having 2 primary keys talking with fact sales (DEPENDENT). I have question in my mind whether we need single association or two association joining each dimenstion key with fact table. If I create one associat...

Answers: 1

denodo 6.0 admin denodo 5.5

Do we have similar REGEXP function in Denodo to implement this logic?
answered 02-08-2016 08:58:50 -0400

We are trying hard to get REGEXP logic to be build behind below requirement. COALESCE( REGEXP_SUBSTR( UPPER(( DIM_ACCOUNT_CORPORATE.ZIP_POSTAL_CD )), CONTROL_PARM_CORP_ZIP.PARM_VALUE ), 'N/A' ) Here if PARM_VALUE is metadata and based on its value,...

Answers: 1

Denodo 6.0 denodo 5.5

Connecting Spotfire with Denodo
answered 19-07-2016 22:18:19 -0400

I am sure we can connect Spotfire but thought to confirm with your expert team and guidance on it on how to connect it. Please help.

Answers: 1

denodo 6.0 admin denodo 5.5

Why default cache_wait_for_load is true even though cache is not enabled on the view?
answered 14-07-2016 15:52:04 -0400

I have imported some of views from 5.5 to 6.0 environment. Not using any caching in any of views. When running quey in Denodo 6.0, I can see ('i18n'='us_pst', 'cache_wait_for_load'='true') is appended for the query. Due to this option as true, query t...

Answers: 1

denodo 6.0 Denodo 5.5

Denodo 6 - Resource Manager
answered 09-06-2016 11:10:58 -0400

Hi there, I am testing out the resource manager for our upcoming Denodo 6 launch and ran into a few questions I was hoping you might be able to help me with. I have set both a few plans and a few rules to be applied to some plans, but maybe I am tryin...

Answers: 3

denodo 6.0 resource manager