Search results

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

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

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

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

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

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