Recent content by Grantham Good

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

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

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?

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

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

ok thanks - will try this

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

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

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

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

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

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

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

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

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