Hi Denodo Team, Can you help me with this error that i get when i want to deploy the query to the database. The error is "Error loading database " databasename"". any suggestion what to fix in order to work? thank you.
Answers:
1
Hi there, I am trying to retrive last business day of last year though this query select dateadd(yy,datediff(yy,-1,@date),-1)[In sql], but in denodo I am not able to find any solution here, so can you please help me out, Thanks,
Answers:
1
Hi, How many columns(fields) I can delegate to the soure from denodo? I am facing an exception 'ORA-01722 invalid number' while delegating more than 160 columns to the source? So is there any limit set on source side or denodo side? Kindly assist, T...
Answers:
1
Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not ...
Answers:
1
Hi Team, Can Denodo support this function, to make the view name case insensitive, eg. I have one exact view like : DERIVED_VIEW_A, and when query the view, I may write the query like: select from "derived_view_a", or select from "Derived_View_a", an...
Answers:
1
I am seeing a strange issue with my Denodo cached view where it returns 0 records if I put a where statement and limit the columns. No issue if I select all columns though. Is this a bug, or I am missing the error? Please help me get the tailored view ...
Answers:
5
Nevermind! Figure out the issue.
Answers:
1
I have a view, I need to update columnA with Column B if that columnA as null value , do we have denodo query for it.?
Answers:
1
Hi Team, Denodo 7.0 Is there any scripted way (stored procedure), which can tell what base views are created from query and what otherwise. Please help. Thnaks.
Answers:
3
Hi, We have a report view that is run monthly and is critical from the end user perspective. This view is cached on a regular schedule. When we run the view in vdp and it does not have any functions like current date() or get quarter(), I see that the...
Answers:
1