Recent content by Ben Hill

I was looking for an internal document about feeders, invalidations and formulas today and then found that we had incorporated it into our standard documentation. This is a great reference for how MODLR generates feeders and how the formula system works. A great resource if you are looking to...

Just to add to this, when a page loads it follows this approach - Take any URL parameters first Use local storage (what the user was last looking at) Any "Set default" instructions on a given set The settings the given dashboard / card was last saved on [This one shouldn't happen but if a card...

Note: This only applies to manually managed dimensions and hierarchies or automatic dimension updates which do not run dimension.wipe / dimension.createOrWipe. Sometimes when building a new model or adjusting a model over time, N-level (bottom level) elements can be added to hierarchies and...

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

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...

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

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...

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...

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...

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...

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.

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...

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...

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...

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...