Search results

  1. G

    Request Percentage input behavior

    Hi Ben, I think we have a further issue, which is if you are using eg 25% format and copy and paste in Modlr, it pastes as 0.25 % to the target cell
  2. G

    Question Workview Feature: Changing Auto-Recalculation

    I think you need to at least on thin client Ignore the flag on first load in the front-end and always refresh it right away. And if it is off- it would be good to somehow indicate a refresh is needed when changing slice, maybe highlight the refresh button a different colour
  3. G

    Question Workview Feature: Changing Auto-Recalculation

    looks good Ben, how will this affect the thin client if calculation is set to off, even though I voted third option above, itmight be best to be On for thin client? Will you also have the same setting (on/off) for thin client?
  4. G

    Reset the set dimension while we are applying new instruction

    Would be good if we can Reset the set dimension while we are applying new instructions. Example: If you go to a row element and Select with the right-click, then try to change a set in the rows by opening the set editor - the new changes will look like they don't take effect until you go and...
  5. G

    Default value for Reporting Month - and include other months

    Hi Lizzie, “Set Default using the Next Instruction” works - thanks
  6. G

    new Date() for timezones

    ok thanks - will try this
  7. G

    Formatting additions display 000's and display flip sign

    hi there, it would be good to have formatting capability to have flexibility to complete features like: display 000's or by millions, - for large numbers display flip sign - good for displaying Income lines (which are credit - ) and not impacting the NPAT Probably a few more but thats a start
  8. G

    Default value for Reporting Month - and include other months

    We have a Period variable for reporting month, reporting year, reporting YTD. etc Would be good to be able to on a Workview selector display all Reporting YTD expanded children, and have the default land on the new month (probably last month on the list) in a report each month. Have tried using...
  9. G

    Default value for a Set if formulas not met

    We use formulas in a set to default to a legal entity currency, where Legal Entity is one dim and Currency is another. Only issue is when a person Pivots the Legal Entity dim from a selector to a row or column the formula cannot calculate as it is not a single legal entity on display. Would be...
  10. G

    Question Struggling with Syntax

    SEQUENCE(Dimension, Hierarchy, SequenceShift, RelativeLocation) will bring back sequence - but usually only applied to period dim LINKBY(CubeName, RelativeLocation, ValueLocation) might work? you need a mapping created for the combinations and the LINKBY("SourceCubeName", ["Element 1", "Element...
  11. G

    new Date() for timezones

    Hi There We can use new Date() to return a date eg Tue Nov 17 2020 09:17:05 GMT+0000 (UTC) but it would be good to be able to call timezone times that relate to the location of the main teams eg aestTime = new Date().toLocaleString("en-US", {timeZone: "Australia/Brisbane"}); This does not...
  12. G

    Closed Cell unlock in If Statement

    Hi Warren, you may have tried this but would CONTINUE work for you on the false? if(true, value, continue)
  13. G

    Parent Alias duplicate naming across Hierarchies enabled

    This would be good if we can implement this quickly as we have to work around this at the moment with an alternative naming convention that is not the same as the Source systems Like we can with element parents across hierarchies, it would be good to incorporate this capability for the alias...
  14. G

    zero suppress with a tolerance

    Yes that would make sense Ben, less than greater than would give better flexibility
  15. G

    zero suppress with a tolerance

    Hi there, it would be good to be able to zero suppress rows and columns, but to call out a tolerance + or - . Example being with some comparisons across two children in a consolidated element you will get a very small residual even though it is zero when displayed. By adding a tolerance if you...
  16. G

    Implemented URL path displayed and ready to copy for the application screens page in the gateway

    Hi Brad, we name the screen any name, so if you dont name the same as the workview you would not know the one to one match on the 1st page view- you have to open each one
  17. G

    Model notes and documentation

    Hi Modlr team, we maintain workview, cube, and application information offline - mostly description free form text. It would be good to have a field we can maintain in modlr direct so we don't do anything offline - also good for this to be able to be extracted easly in xls by the user and in...
  18. G

    Implemented URL path displayed and ready to copy for the application screens page in the gateway

    Hi Brad, is it possible to get the Workview name too as this would be a handy reference
  19. G

    Request Azure Single Sign On Functionality

    This would be a good box to tick, SSO is used across most of our other systems