Platform

MarkT83

Thanks heaps @DavidSmith , @nathan_rudman & @kavinkumar for the detailed explanations! I'll work through it and revert back if any issues Mark

MarkT83 · ‎10-13-2019

Hi @kavinkumar . Thanks for the quick reply 1) Can you help & explain how the top level would work? Even if you had a top level 'All Currencies' & then you had a subset of the currency list in the calculation module, say AUD, when you referenced the original module it would return the sum of all the currencies in their nominal/input value which is not a useful. The nominal/input values need to be translated from the input currency to AUD & then Summed 2) Don't think this calculation works as each Select statement that is performed to obtain a particular currency value needs to be translated using another select statement (again the currency). There is no overarching value or relationship that I can see that we drive a dimensional value return Thanks! Mark

MarkT83 · ‎10-13-2019

Hi team, I have a Currency list that has no parent/top item & an input module whereby the user will enter the data into the Currency dimension. In a secondary module I want to convert all those currency values entered by the user into 1 currency. I can only get this to work at the moment by not having a currency in the 2nd module/having a subset of the currency list item I require & creating a manual formula whereby I select each currency type & converting it to the required currency (again by using a select item). I'm aware that this is not a scaleable solution & breaks some of the best practices but I'm having difficulty in finding a more dynamic solution, does anyone know a more robust manner to reference items within the same list that do not have a parent?

MarkT83 · ‎10-09-2019

Thanks @ArunManickam & @a.dilieto

MarkT83 · ‎10-07-2019

Hi Team, Wondering if there is a way to align Dashboard header rows where the Modules are not the same width? I am trying to align the far right so the 1st row is align with the left and middle modules Thanks Mark

MarkT83 · ‎10-06-2019

Hi @ArunManickam & @usman.zia , I achieved my aim by creating another Line Item with the Lag formula and therefore on my % movement Line Item I could reference both line items (thereby referencing the current period & prior period) & also being able to set the summary to Formula Thanks for your assistance!

MarkT83 · ‎10-03-2019

Nice one @DavidSmith Thanks

MarkT83 · ‎10-03-2019

Hi Team, I'm attempting to create a Period on Period % movement in a module using multiple dimensions but I require the summary level/top level to still calculate using the formula rather than Summing all the lower node %'s. When I change the Summary method to % I receive an error I have tried using Period, Lag & also Lookup for the prior month as a line item in the current module Is there a way I can display the % movement as a formula for all cells? Thanks

MarkT83 · ‎10-02-2019

Thanks @nathan_rudman App downloaded & checking it out Mark

MarkT83 · ‎10-02-2019

Thanks @ArunManickam I was incorrectly thinking the PERIOD function would only return the month of the date, rather than the Time Period selected as the list value! Mark

MarkT83 · ‎10-02-2019

Thanks Nathan & Arun. I have a Time Filter module but I was asking more specifically as to how to convert a date/period & return the FY? Cheers Mark

MarkT83 · ‎10-02-2019

Hi Team, I'm trying to extract the FY from a date. In our world the Fiscal years run from July to June & hence 1/07/19 would be FY20 I could convert the date to a Time Period & have a separate module that maps the Time Period to FY but I thought that might be overkill? Many thanks Mark

MarkT83 · ‎10-01-2019

Hi @jnoone Thanks for the reply! I tried changing the script as per the AP connect instructions & creating the shortcut but still receiving the same error. Once I have created the shortcut am I meant to run the shortcut or the original file? Attached are the full versions of my script & Shortcut Appreciate your help! Mark Thanks!

MarkT83 · ‎09-29-2019

Thanks Vignesh! - I understand how the scripting is working now

MarkT83 · ‎09-26-2019

Hi @VIGNESH.M , Thanks for your help, unfortunately it didn't quite work. I did adjust the script a little but I have definitely got something incorrect. Could you take another look for me? FYI - The Process is 2 Import actions which use 1 file each Thanks!

MarkT83 · ‎09-25-2019

Hi team, I'm trying to use Anaplan connect to run a Import process but my script is incorrect. I attempted to modify my working import script per the instructions in the Anaplan Connect guide (pg 27) but it is not working Below is my script and error, any help would be appreciated!

MarkT83 · ‎09-25-2019

Hi team, I am receiving the below error when trying to perform a simple upload using Anaplan Connect & One Drive. This action will perform if I change the directory of Anaplan Connect & the batch file to the local C: I have reviewed the Anaplan Connect help document & saw there is a section about Network drives (pg 43) but I could not get it to work Could anyone point me in the right direction? Many thanks Mark

MarkT83 · ‎09-17-2019

Thanks @DavidSmith! Very helpful

MarkT83 · ‎09-13-2019

Cheers David - always looking for faster & smarter ways to model!

MarkT83 · ‎09-13-2019

Love it Arun! Thank you very much Mark

MarkT83 · ‎09-13-2019

Great explanation Will - that makes sense as to why it doesn't roll up! Mark

MarkT83 · ‎09-12-2019

Hi Team, I'm trying create some logic whereby I classify each Customer Account as either Existing, New Business or Churned for each Financial Year based on whether they had revenue in the last month of the previous financial year compared with the current year I have created the Matrix below (the columns are Line Items) for the rules of classification Below is the Module I created where I can classify each customer as 1 of the above based on the revenue but I cannot determine what the formula would be? I did not want to create a large IF statement (as in IF Opening ARR = TRUE & Closing ARR = TRUE THEN Existing). FYI I will be referencing a Module with Customers as rows & Time as columns & I will use the Mapping below to return the correct months revenue value Is there a method to determine whether the customer has satisfied both criteria and return the List item? Thanks!

MarkT83 · ‎09-12-2019

Thanks Nathan

MarkT83 · ‎09-12-2019

Hi Team, I have noticed that when referencing a module that has Time as a dimension from a module that does not have it as a dimension that the formula will not return the highest node in the Time Dimension E.g. I have a Module with Employees & a Boolean line item and a Module with Employees & Time (with Summary as Sum) & a Number line item. If I enter a value into any of the Employee/Time intersections it will roll up to the 'All Periods' Time dimension. But if I then reference that employee from the original Module it will not return the All Dimensions value I'm assuming I need to use SELECT:Time.'All Periods' in these circumstances? Thanks

MarkT83 · ‎09-11-2019

Thanks Arun! Worked like a charm Little strange that AP would allow you to see the full list when you have already entered the Selected Access for the list at a User level Mark

MarkT83 · ‎09-11-2019

Hi Team, I have a list (Employees) which has Selective Access enabled & I have updated the Users Section for the relevant access to Employee list items. I also have a Line Item Formatted with the Employees list. When the employee clicks that Line Item all the Employee List items appear, not only the Selective Access items FYI - Employees rolls up to Regions(which does not have Selective Access enabled) but the Employee has setup for this (see below screenshot) Any ideas on why the full list would be displaying in the Line Item? Thanks Mark

MarkT83 · ‎09-10-2019

Ok - thanks Kavin - makes sense!

MarkT83 · ‎09-10-2019

Hi Team, I created a module dimensionalised by Time with Dynamic Cell Access set to Read for all periods except for Sep19 to Jun20. The setup was working as expected when tested manually. When I Imported data from another Model with the same time dimension the data was uploaded into the Read access periods & the write access periods Does Dynamic User Access not work with imported data? Many thanks Mark

MarkT83 · ‎09-10-2019

Too easy - thanks!

MarkT83 · ‎09-10-2019

Great - thanks Keith!

Platform

Academy

Master Anaplanner

Programs

About MarkT83