About MarkT83

Hi Team,   Is there a way that I can set a fixed Directory destination for an Export Action?   I want to always extract to the same directory so the data can be referenced by an Excel Macro   Thanks   Mark ... View more

Hi team,   I'm trying to adjust the view of the Imports tab in the Actions area so that all the text is visible. Currently the columns are a fixed width & I cannot adjust them. Likewise I am unable to extract the data to view it in Excel (where I can adjust columns etc)   Anyone know how you can view all the data in this section?   Thanks   ... View more

Hi team,   I'm attempting to create a function whereby it will return the line item value of it's parent without using SELECT.    I have a target module with Machines List (Top level All Machines), a source module with Machines list and a system module with the Machines list & a line item returning the Parent of that list item (All Machines)   Unfortunately when I reference the Target module from the source module using LOOKUP (referencing System module) it returns 0 but will work if I use a SELECT statement & select 'All Machines'   Is there a way to return the parent value without using SELECT?   Thanks!!   TARGET Module         SOURCE Module                                         System Module   ... View more

Hi,   I'm trying to understand whether I can return a Dimension/List item when referencing a Line item rather than the Line Item result itself   I have 2 modules. 1st module is dimensionalised by FX Rates (columns) & Regions (List Formatted Line Item)   The 2nd module has a Line Item which is List Formatted with FX rates & dimensionalised by Regions.      I want to be able to return the FX Rate for the each region dimension. I thought FINDITEM(FX Rates,FX Mapping.'Region (Text)') but this doesn't work as I need to return the List item from the Line item, not the line item result itself   I am aware it is easier to build the FX rates module with Regions as a dimension and then FX Rates as the List Formatted line item for future references but this problem has me intrigued   Many thanks   Mark ... View more

Hi,   I'm attempting to import data from a module in another Model (monthly employment costs per employee) which has greater dimensionality than my current module (The source has a Currency List & also Versions which the current Model does not have)   Is there a way to SELECT a Currency List & Version item to import or do you have to create dummy lists in the current model and then map 1-1 (e.g. Fake Currency.AUD and map to the Currency.AUD in the target)   Thanks   Mark   ... View more

Hi,   I wish to create 2 import Actions where it is utilising the same Source Object & Target Object but there is only 1 action (which is the last upload) and hence I need to re-map etc when I wish to perform the latter Action   The Source Object is a CSV file and which contains multiple columns. The Line-Item mapping on 1 Action uses 1 of the columns while the other action uses another column   Can I create 2 saved Actions for this purpose?   Many thanks   Mark         ... View more

Hi,   I have a Target module which is Dimensionalised by Line Items and Time and a Source module which is dimensionalised by a numbered list and 3 line items (1 is direct input and 2 are List Formatted (1 being Time, 1 being L ine Item Sub-set of the Target module Line Items)   In my Target module I wish to return the Direct Input line item from the source module and SUM on the Time formatted Line Item and Line Item Sub Set. The problem being is the Line Item in the Target Module and the List Formatted Line Item in the Source module have effectively no relationship   Is there a SUM/SELECT formula whereby you SUM on a Line Item but SELECT which List Item to SUM on?   Target Module Target Module   Source Module Source Module   Many thanks!   ... View more

Hi,   Is there a way to use Custom Time Ranges when creating a Time Period formatted Line Item?   I wish to display only a certain number of periods as a selection option but currently all periods are the default   Many thanks   Mark ... View more

Hi,   I am attempting to upload a CSV file to a Module and the Time dimension (Months) is in the column headers but Anaplan will not recognise the Months no matter how I enter them (e.g. 01/01/19, Jan-19, 2019-01) & it is requiring me to manually map them    Below are 2 screenshots of what I am referring to. The 1st being my data upload and the 2nd being the mapping   I know that if you choose a column to Map off the TIME tab will give you the option to map in certain formats but it doesn't seem to be the case when you choose Column Headers   Thanks   Mark ... View more