Search results

  1. 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...
  2. G

    Default value for Reporting Month - and include other months

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

    new Date() for timezones

    ok thanks - will try this
  4. 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
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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)
  10. 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...
  11. G

    zero suppress with a tolerance

    Yes that would make sense Ben, less than greater than would give better flexibility
  12. 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...
  13. 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
  14. 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...
  15. 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
  16. G

    Request Azure Single Sign On Functionality

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

    Implemented Ability to Expand and Contract Instruction Directory menu options

    Good work Brad, would also work well, if the search worked when sections were collapsed, and there was a quick collapse function for all?
  18. G

    Request Make use in Workviews the area above the rows and in the corner by the columns

    hi there, Would be nice to make use of this area above the rows and in the corner by the columns - would work if it was a text area to write a header or instructions?.
  19. G

    Request Request: Rules/ Formulas - turn off and on

    Hi there, We have various forecasting cycles in the year and use working versions for scenarios, these having formulas relating to the specific working versions... I manage the working versions through a hierarchy and use restrictions in formulas to reference only these... but, it would also be...