Recent content by Ben Hill

  1. Ben Hill

    Security Concern

    Hi Paul, This came across engineering at 11am on Saturday, we have reviewed the exploit against MODLR and because we do not use the log4j libraries we aren't susceptible. Thanks, Ben
  2. Ben Hill

    Audit Hierarchies on All Workviews

    Hi Paul, I've had a chat with Amin on this and we have added a new process function workview.definitionGet which will return the JSON format definition of a workview. This can then be parsed to list the involved hierarchies. I'll add here and in the support ticket an example process shortly...
  3. Ben Hill

    Request Percentage input behavior

    Hi Grantham, We've solved this issue now. Thanks, Ben
  4. Ben Hill

    MODLR Gateway - Minor Update - Apr 13th 2020 - Auto-recalculation option is Live

    MODLR Gateway (Early Access) - https://go.modlr.co Update Date: 13th Apr 2020 This is the developer portal for designing models, reports and dashboards. For some of the functions to become available a server upgrade is required. Update Listing Workview Editor - Workviews now have a...
  5. Ben Hill

    Question Workview Feature: Changing Auto-Recalculation

    Hi All, Just closing this out, we are going with Default Auto-Recalculation to On for existing Workviews and Off for all new Workviews moving forward The version of MODLR 2.5.740 will adopt the new setting of Auto-recalculation = true for all existing Workviews. From this point forward new...
  6. Ben Hill

    Question Workview Feature: Changing Auto-Recalculation

    Current plans are to keep the settings consistent between Backend and Frontend. So if automatic recalculation is turned off in the backend, the same will be true in frontend. Though we are also considering the following options - Ignore the flag on first load in the front-end and always...
  7. Ben Hill

    Question Workview Feature: Changing Auto-Recalculation

    We have setup a new feature on Workviews being that you can now turn off auto-recalculation. This will allow report developers to make multiple changes to a report in quick succession without having to recalculate or cancel the recalculation of the workview in between each change. There is a...
  8. Ben Hill

    new Date() for timezones

    Just to clarify, I believe regardless of where the instance is based it should be in UTC. So providing the timezone delta hours +10 for AEST should get you to where you want to be. I think this will likely not cater for Daylight Savings though.
  9. Ben Hill

    Question Complex formula to populate an element with the sum of all the other elements under the same parent.

    Hi Warren, I should mention is that we have CHILDCOUNT, PARENT, PARENTCOUNT functions which do not appear in the documentation (I'll have the team sort this out). Usage Example: CHILDCOUNT("Time","Default","2018") Edit: These functions have been added to the doco here. There are a couple of...
  10. Ben Hill

    Closed Strange behaviour on sequence function

    Hi Warren, When using the sequence function there are a couple of things to check - It is best to use sequence with a hierarchy which is a flat list of elements (Can be C or N Elements) - We typically create a hierarchy called Month List for this purpose. The formula needs to be restricted to...
  11. Ben Hill

    Minor Updates MODLR Excel Add-in - 1.3.14 - Minor Update - 16th Nov 2020

    MODLR Excel Add-in - Documentation, Download Update Date: 16th Nov 2020 Update Listing Instance Version: 2.4.908 - Workviews containing sets with overridden labels revert to the element names so the workview exports correctly. Instance Version: 2.4.908 - Workviews referencing multiple cubes...
  12. Ben Hill

    Request New to Modlr and would like documentation on Excel addin

    Hi Warren, We have limited documentation on the Excel add-in and are actively adding to it, presently this is in our training manual but I'll have the team move it to the standard docs portal when there is enough there. In the meantime I'll flick you an appointment setting link via email and...
  13. Ben Hill

    Major Updates MODLR Gateway - Major Update - Nov 5th 2020 (In Early Access Portal)

    MODLR Gateway (Early Access) - https://ea.modlr.co Update Date: 5th November 2020 This is the developer portal for designing models, reports and dashboards. For some of the functions to become available a server upgrade is required. Update Listing User Interface - Design of the gateway has...
  14. Ben Hill

    Request Percentage input behavior

    Hi Grantham, This one will be in the next upgrade to the gateway portal. Data entered is interpreted based on the cell formatting and so % cells where the user enters 25 will result in 0.25 being stored. This behavior is now in alignment with MS Excel. It will take a week after gateway...
  15. Ben Hill

    Request Right Click run relevant Schedule

    Hi Paul, This should be a quick one to implement. I've added my vote behind it. Thanks, Ben