Platform

Sneha

@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

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

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

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

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

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

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

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

Ability for summaries to only include the items wh...

Synchronise module scrolling on a dashboard

Ability to open a module directly from drill down ...