Search results

  1. 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...
  2. Ben Hill

    Request Percentage input behavior

    Hi Grantham, We've solved this issue now. Thanks, Ben
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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
  15. Ben Hill

    Model notes and documentation

    Hi Grantham, We are implementing this one, but will be omitting the "related Application workview links" for now due to it being considerably more effort. I think providing an overview page which shows all the relationships between model workviews and application screens is more likely...
  16. Ben Hill

    zero suppress with a tolerance

    Hi Grantham, Perhaps this could work also if we add a filter option at the top of any data column in a workview (perhaps enabled via a set instruction). If this behaves similar to an Excel Autofilter we could then allow multiple filtering condition types, including contains, lesser, greater or...
  17. Ben Hill

    Request Azure Single Sign On Functionality

    Hi Paul, Grantham, Yes this is definitely on the roadmap along with GSuite and OKTA Authentication methods. We have been working into the platform various changes over time which get us closer to the correct place for alternate authentication methods but this one will definitely be a couple...
  18. Ben Hill

    Minor Updates MODLR Excel Add-in - 1.3.10 - Minor Update - 15th Sept 2020

    MODLR Excel Add-in - Documentation, Download Update Date: 15th Sept 2020 Update Listing This fixes a bug which can occur when using a CubeGet and CubeSend against the same data-point in the same worksheet or workbook. Added the delta symbol copy button (used in Formula development). Added a...
  19. Ben Hill

    Implemented Request: Export to CSV in shared server folder from MODLR datasource

    Hi Grantham, Our engineers have added this in version 2.4.816 (unreleased). //this creates a csv writer object var csv = datasource.csv(fileName); //the file path will be within the filesystem folder (Accessible via FTP and the manage filesystem page. //write a line to the file...
  20. Ben Hill

    Minor Updates MODLR Gateway - Minor Update - August 6th 2020

    MODLR Gateway (Early Access) - https://go.modlr.co Update Date: 6th August 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 Features and Bug fixes previously pushed to...