https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions https://community.denodo.com/answers/question/details?questionId=906Qj00000IhoGvIAJ&title=Refresh+Time+%2F+Update+frequency Hello, If I want to know the refresh time or update frequency of any particular data table which is on Denodo Data Catalogue how can I find it ? Mon, 09 Sep 2024 14:36:12 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IhoGvIAJ&title=Refresh+Time+%2F+Update+frequency 2024-09-09T14:36:12Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IgwGXIAZ&title=Dependencies Hi Team, Is there any way to get the list of all the dependent views of a base view. Mon, 09 Sep 2024 09:49:42 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IgwGXIAZ&title=Dependencies 2024-09-09T09:49:42Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IZnUvIAL&title=Column+space+issue We have a view which is generated from joining a view from collibra, this view has an extra space in the specific column of the view. This space from the view is affecting other views down the line, we have applied the option 'trim' to eliminate the unwanted space . This space is not available from the source system views, it is observed that the space is present onky after the join. Fri, 06 Sep 2024 11:00:35 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IZnUvIAL&title=Column+space+issue 2024-09-06T11:00:35Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IT1CrIAL&title=Git+with+HA+configured+VDPs We use Git for source control on Design Studio objects, and since we have switched to HA, the local repository is locked when trying to commit an object. Additionally, we run git reports on the local repos to determine any uncommited files and changes in the last week. The commands are in a shell script, run on the local VDP in this directory: /opt/denodo/denodo-8/work/vdp/repository/ Here's the commands run in the script: git log --pretty="%h - %s" --since="1 weeks ago" git diff --stat origin/main Since moving to a HA configuration, it depends on which VDP you connect to when running the script. If you commit on VDP 1, then you do not see these changes reflected in the copy of the local repository in VDP 2. How do you force connection to the same VDP when in a HA configuration where you have multiple hot VDPs? Otherwise, the remote repo will have trouble synching to the local repos because you don't know which is connected when you do commits vs when you make changes and push. Is there a way to force Denodo into using a common local repository directory across HA VDPs? Wed, 04 Sep 2024 20:51:58 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IT1CrIAL&title=Git+with+HA+configured+VDPs 2024-09-04T20:51:58Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IArWwIAL&title=S4+Private+Cloud+Source Hello, Anyone connected S4 HANA(on Private Cloud) as datasource in denodo? Did you have to open DB port at S4 HANA end to enable this? What template with SAP had to be used for ticketing? What are the other options for this source? Thanks! Fri, 30 Aug 2024 02:42:15 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IArWwIAL&title=S4+Private+Cloud+Source 2024-08-30T02:42:15Z https://community.denodo.com/answers/question/details?questionId=906Qj00000I4EbWIAV&title=Time+Format Hello Team I want my hours to be return in 24 hour format and not in the AM/PM format. for exemple, now, i have this kind of hour 03:38:00, and i would prefer 15:38:00. Is there a function that can change it in the output? Thanks Wed, 28 Aug 2024 15:05:35 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000I4EbWIAV&title=Time+Format 2024-08-28T15:05:35Z https://community.denodo.com/answers/question/details?questionId=906Qj00000I2eVHIAZ&title=Excel+Datasource+%28Macro-enabled+spreadsheet Hi Team, one question, is it possible to add a .xlsm datasource. BR Wed, 28 Aug 2024 05:34:24 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000I2eVHIAZ&title=Excel+Datasource+%28Macro-enabled+spreadsheet 2024-08-28T05:34:24Z https://community.denodo.com/answers/question/details?questionId=906Qj00000I2Um1IAF&title=how+to+combine+localdate+and+time+into+one+column%3F Hello Team, I have two columns: one type is localdate and the other is time. Can I combine them directly into one column and make the type of such column be timestamp? How should do that? Thank you Wed, 28 Aug 2024 03:48:47 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000I2Um1IAF&title=how+to+combine+localdate+and+time+into+one+column%3F 2024-08-28T03:48:47Z https://community.denodo.com/answers/question/details?questionId=906Qj00000HzpF7IAJ&title=HotFixes+and+Denodo+container+images Hello, Are hotfixes automatically installed on the denodo-platform and solution-manager container images when a new image is pushed? Thanks Tue, 27 Aug 2024 15:05:05 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000HzpF7IAJ&title=HotFixes+and+Denodo+container+images 2024-08-27T15:05:05Z https://community.denodo.com/answers/question/details?questionId=906Qj00000HyhMtIAJ&title=DAX+function+not+working+with+Denodo+direct+query Why find or Search DAX function not working with Denodo direct query Tue, 27 Aug 2024 09:58:00 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000HyhMtIAJ&title=DAX+function+not+working+with+Denodo+direct+query 2024-08-27T09:58:00Z