Platform

Sneha · ‎08-16-2019

Hi all, Hope everyone's had a good summer! Just wondered when the next forum might be? I have been live on my Anaplan model for 5 months now and big issues that have come up are on filtering a catalogue(i.e items in a long list) and master files combining time dimensioned and non-time dimensioned data and wanted to put a couple of questions to all you seasoned experts! Hope to see you all soon! Sneha

Sneha · ‎08-16-2019

Hi @davewaller I currently have a dashboard (please see below) that has two modules published - one as a function of time (e.g. financial data) and one is not (e.g. key static data of a list item) - but they have a common list (being the list used for rows). The difficulty with this set up is that there is no syncing between the two modules or synchronised scrolling. I think synchronised scrolling is "On the Roadmap" but I thought this was being parked as in the NUX there was to be a functionality that would allow me to create a module or grid or worksheet that would have the two sets of data for a common list to be viewed together. This is a key functionality for the FPA analysis required so any news would be great. Many thanks, Sneha

Sneha · ‎07-17-2019

@ChrisHeathcote This would work for revenue and the time-dimensioned data but what about the non-time dimensioned data? The masterfile is a combination of the two and will need to remain this way for business function. Many thanks, Sneha

Sneha · ‎07-16-2019

Hi Chris, So the masterfile is supposed to be a "target" module as it combines the time dimensioned and non-time dimensioned data from two separate modules using the a common list. Hence the formulae in the masterfiles retrieve data from "production input.revenue" looking up on a specified month, with production input being a time dimensioned module. If I have misinterpreted your comment, please let me know. Thanks, Sneha

Sneha · ‎07-16-2019

Hi Chris Thanks for your response - unfortunately not all the line items in the module are dimensionalised by time. The masterfile trying to combine two modules, one with time dimension and one without. When the two modules are published to a dashboard - there is no synchronised scrolling and the synchronisation is not effective. So I have created a module that combines the two for end users to be able to analyse and be able to export. I think the NUX is supposed to have a feature that will fix this. Thanks, Sneha

Sneha · ‎07-16-2019

Hi @DavidSmith Thanks for your response. Unfortunately some of the other line items in the masterfile module are not dimensionalised by time hence I have to use a SELECT for the time-related line items. I think the NUX I will be able to do this instead of having, say, synchronised scrolling on a dashboard. Thanks, Sneha

Sneha · ‎07-16-2019

Hello All I have a Masterfile module that has lines items that use a select function to get the data for a specific month. However, I am now trying to make the module dynamic. This means that the end user can select a year and the module is updated with the months in the selected year. I have created a "Masterfile - Time" module were the desired year can be selected but what formula can I use to populate the line items with the months of the selected year? Secondly, please find attached an image of the how to the formula is the masterfile uses a LOOKUP function to the Masterfile-Time module. Please let me know if any further clarification is needed. Many thanks in advance! What formula should i use to get Feb and Mar filled in? The module looks up on the appropriate month in the Masterfile-Time module

Sneha · ‎05-16-2019

Hi Everyone, Sorry for the delay Yugnesh. I'm afraid I am on holidays on the dates but I look forward to reading the minutes and joining the next session! Talk soon! Sneha

Sneha · ‎05-16-2019

Hi all, Just wanted to confirm if end users can use the data/import function via the little drop down arrow next to the module name on a dashboard? I am currently getting an error message and I am not sure what i need to "switch on" or assign for the end user to be able to run an import. I know that often an import button is used but the document and the mapping needs to change and I am not sure that the end user will be able to change the mappings and document using a button. I also do not want to publish several import buttons to the dashboard. Any help is greatly appreciated! Many thanks, Sneha

Sneha · ‎03-21-2019

Hi Yugnesh Thanks for organising the Meet up. I was curious about early access and I got the impression that it was different to the Beta of NUX - is this right? And is it worth signing up for? Thanks!

Platform

Academy

Master Anaplanner

Programs

About Sneha

Next forum

Re: New UX - June 6, 2019 What's New!

Re: Formula to populate lime item with months for ...

Re: Formula to populate lime item with months for ...

Re: Formula to populate lime item with months for ...

Re: Formula to populate lime item with months for ...

Formula to populate lime item with months for a se...

Re: Session 3 - London Meet up (Anaplan Modelers F...

End-user file import from a dashboard

Re: Session 2 - London Meet up (Anaplan Modelers F...

Suggestion: Copy a Dash board Component to another...

Ability for customers to set time frame for when s...

Allow for Idle Timeout Limit to be increased to at...

Re: Session 3 - London Meet up (Anaplan Modelers F...

New UX - June 6, 2019 What's New!