About mmoloney

mmoloney · ‎04-19-2022

It would be useful to be able to set Production Models header or background colour to something different to Test or other non-production Models. During development activities switching between models in different browser tabs and windows can lead to changing a formula in the wrong model. I've seen in other Finance Systems where you can change the RGB code of the background/page banner in system settings to easily differentiate between Test and Production environments. I've attached an example of where I changed the banner colour using the A+ extension in Chrome to show the effect that could be used for Test models.

mmoloney · ‎08-19-2021

+1 We have a need to disable a button to approve a journal if the journal approver is the same as the journal creator. It would be nice to have a boolean line item which does this check and drives the ability to run the action/button.

mmoloney · ‎05-17-2021

This functionality would be a great addition. Hopefully this can be added to the roadmap as soon as possible.

mmoloney · ‎04-12-2021

Hi All, Thanks for the replies. Our IT department has notified me that we can upgrade our Excel Add-in version to 4.2 now so hoping that the issue is sorted once my colleague upgrades. Thanks Michael

mmoloney · ‎04-08-2021

Hi All, A colleague of mine is working with a report in Excel using the Anaplan Add-in version 3.4 and is receiving the attached error even when opening the spreadsheet. On other occasions when she clicks on the Anaplan ribbon in Excel the spreadsheet crashes without an error message. She had issues with Excel crashing just prior to the Anaplan add-in crashing so that might be a contributing factor. Has anyone encountered this error before? Regards, Michael

mmoloney · ‎02-19-2021

@rob_marshall I agree totally. Thanks again for you're replies. Michael

mmoloney · ‎02-19-2021

Hi @rob_marshall, Great explanation, thank you. Yes our lists contain multiple subset lists but the list properties are just being used for LOOKUPs and SUMs. They're not being referenced directly by the module in line items or 'double counting' as you cleverly called it, so in this case is the Model still more bloated than if we were to separate the list properties out to SYS modules? (I understand the other benefits of having system modules i.e. auditability, filtering, formula usability etc.) Kind Regards, Michael

mmoloney · ‎02-18-2021

嗨,抢劫,我一个问题你的原因之一change List properties to System Modules namely: List properties add to the overall size of the list upon load If we have a large module using a list or a couple of lists with list properties, will that module decrease hugely for each list property removed and moved into a system module? or in other word, is the cell count of a module related to the how many properties a list might have? Thanks in advance, Michael

mmoloney · ‎07-30-2020

Hi, What format is the Line Item that the user is trying to export? Are other Line Items in the Grid/Dashboard being exported correctly? Do you have any screenshots of this issue? Regards, Michael

mmoloney · ‎06-03-2020

Hi @einas.ibrahim This is the approach I ended up using. Its not 100% what I was looking for but it's a workable solution for me. Thanks for taking the the time to reply Kind Regard, Michael

mmoloney · ‎06-02-2020

Hi Misbah, Thanks for the reply. From what I see the formula Line Item just brings in the aggregated amount when the COLLECT() function is used. So when you roll up to the Total Company level, for example, the data displayed for the formula Line Item is the aggregated values of the bottom level calculated value.

mmoloney · ‎05-29-2020

Hi Everyone, I have a reporting requirement which I cannot seem to perform due to limitations on Line Item Subsets and the COLLECT() function. I have a Line Item from Source Module A which calculates the % value of one line vs another Line Item (% calc, summary is set to formula) in the same Module. I've created a Reporting Module B which contains a Line Item Subset which includes the '% calc' Line Item Subset Item in order to do some variance analysis. When I COLLECT() the data from the Source Module A the '% calc' Line Item Subset Item in the Reporting Module B brings in an aggregated figure and not the calculated %. Is there away to perform this reporting functionality using the Subset Line Item within the Reporting Module B without having to create a separate Module to handle the calculated % for the '% calc' Line Item as my Customer wants to export the Reporting Module B and to have to export two Modules each time would not be feasible. Thanks in advance for any help. Kind Regards, Michael

mmoloney · ‎02-07-2020

Has there been any update on this? Very surprised that this isn't hasn't more traction. Seems like a completely legitimate feature to have included and the technical implementation should be reasonably straight forward.

mmoloney · ‎12-04-2019

Chris, Thanks a million, that worked for me. I hadn't thought "outside the box" in relation to using a second module as a dashboard filter but it makes perfect sense Cheers, Michael

mmoloney · ‎12-04-2019

Hi Nathan, Thanks for the reply. The first grid has the Customer list as a list formatted line item, its not in the page selector so it won't sync that way. I was hoping that it would be possible to sync the list formatted line item with the page selector of the second grid or somehow filter the customer in the second grid which is a property of the Promotion setup grid.

mmoloney · ‎12-03-2019

嗨,伙计们,我有一个仪表板与网格用户to setup Promotion Entries. The module behind this grid has a numbered list called Promotions and the line items in the module are used as references in the property formulas for this List. I have another grid in the same dashboard with the Promotions and Customer lists included. The user can input data in Periods for each Promotion and Customer combination. My question is: Is it possible to sync the Customer in the line item of first grid with the page selector for Customer in the second grid. For example if the user selects the Promotion line item it would automatically sync with the Promotion page and customer page in the grid below. Is there any way to apply this filter selection based on the fact that the Customer is a property of each Promotion List item? Thanks in advance, Michael

About mmoloney

UKI Commercial

Modelers Forum UK

Change Model There Colour

Re: enable/disable Action Button based on conditio...

Re: Schedule "Copy & Archive" - Backup Model

Re: Anaplan Excel Add-in 3.4 Error

Anaplan Excel Add-in 3.4 Error

Re: Planual Explained - Day 5

Re: Planual Explained - Day 5

Re: Planual Explained - Day 5

Re: Data export from dashboard

Re: Line Item Subsets and COLLECT() function with ...

Re: Line Item Subsets and COLLECT() function with ...

Line Item Subsets and COLLECT() function with calc...

Re: Import Current Period

Re: Synchronising Module Line Item with Page on sa...

Re: Synchronising Module Line Item with Page on sa...

Synchronising Module Line Item with Page on same D...

Change Model There Colour

Re: Establishing Sales Targets Business Process Qu...

Line Item Subsets and COLLECT() function with calc...

Change Model There Colour

Line Item Subsets and COLLECT() function with calc...

Re: Establishing Sales Targets Business Process Qu...

Change Model There Colour

Re: Establishing Sales Targets Business Process Qu...

Line Item Subsets and COLLECT() function with calc...

LOOKUP does not work on list parents and only leaf...

New Modeling Experience: Undock tabs to be present...

Ability to Enable / Disable a button based on a fo...

enable/disable Action Button based on condition

Current Date and Time