-
Anaplan to Tableau connection
Hello Everyone, I am trying to use Anaplan to view my data in tables but not lucky. Is there any way to obtain the data from Anaplan and see them in Tableau? Already tried a lot but no luck. Please guide Thanks in advance James
-
How do i create a filter that used three dimenions ?
I need to create a filter that pans across three dimensions. I've tried using a boolean box, applying that to the lists I need to select. I think I'm going about it wrong. Essentially what I need to be able to do is - if I select a product, I want only to be able to see the components that are within that product. I also…
-
Selective Access on Drill Through Transaction Detail
Hi, I have created a module that contains detailed actual transaction data. The module is based on a transaction ID list and properties like month, account and cost center (and other details). That module feeds into another module for reporting, using the SUM function. I'm able to Drill Through to Transaction Level detail…
-
Allow OFFSET calculation in version formula
Description: Allow OFFSET to be used on summary line item formatted as Formula. Impact/Benefit: I am trying to calculate a percentage change from prior year or prior quarter at the summary level. For example, year-over-year % changes using a formula at the aggregated level: Total Growth in Net Sales / OFFSET(Net Sales, -1,…
-
OFFSET on LIST ITEM
When entering the formulae below it works,however if i change the -1 in the OFFSET formulae to point to a lineitem to pass the no of periods to offset it is formatted as a number anaplan gives an error , the AutopopulateActivity line item is fomatted as a list item. IF ISNOTBLANK(Select Job Code) THEN Select Job Code ELSE…
-
Retrieve Numbered list' Display Name
Hi, All I am struggling with retrieving a display name of a numbered list in a Property. My understanding is that Name(Product) will retrieve #1, #2,,, in my case. Could you give me some pointers ? Thanks in advance. Greg
-
Dashboard Page Selector
Hi Community, I've tried to post the same query yesterday, but it seems it didn't go through. I'm gonna have another try. I'm working on creating a Variance Dashboard at Cost Center / GL level. Having those two dimensions alone would make a relative big module, but I have added couple more which is causing me a lot of…
-
Anaplan Formulae - Repeating sequence of numbers across Timescale
Im creating a Rostering model in which I need to do the following: 1. In a module contain all employee information i.e.. start dates, shift pattern category, etc 2. Module containg a shift pattern profile i.e. for shift pattern A = 2 days on 2 days off, Shift Pattern b = 5 days on 2 days off 3. Module with timescale(day)…
-
Display Hierarchy Codes against parent nodes in line item
When creating a module with a hierarchy dimension, if the code is used as a line item, the code will display as blank for higher level nodes in the hierarchy. This is not the case in the list screen for example and is very disappointing for business users used to other tools who do not like the workaround of including the…
-
Odd Division Output
Would someone explain why Anaplan is giving me a number 5x larger than the number I am dividing when my calculation takes the first number (4,221.43) and divides it by 0? I would assume that it would be 0 or a NaN. Not something as large as the last number.
-
Breakback function by selected Line Item
Hi Team, It will be great to have an option to select the Line Item which will be taken as a source to calculate phasing for Breakback function. At the moment split is done based on the items, in which I input amount. Unfortunately in some business cases it's required to use another metric for phasing. This can be useful…
-
Error In Formula - how to understand Circular Reference
Hi, Please see details on the attachment. My apologies for not posting it on the message box I document my inquiries on my pc for future references. Regards,
-
percentages of a line
Hi: Apologies for the simple question but we are new at this!!! I need to work out how to work out the % of a item in a line. Using an excel equation it will be sometime like - a2/sum(a2:a5) I am sure it is something very straight forward but having no joy so far!! Many thanks for the help in advance!!
-
Convert Date with Week Format to Last day of month with a Date Format
Hi, My model's Model Calendar - Calendar Type is set to 'Weeks: General'. I have a module with a column of dates and the Format is set to Week. In another column with Format set to Date, I'd like to write a formula that will take the date from above, lets say it's 9/2/2019, and output as the last day of the month in date…
-
Dimension Mismatch
Hi, Please see attachment for details. Regards,
-
Only summarise at lower levels of hierarchy
Hi all, I have a model with the three lists; Cities_L3 which rolls-up to Countries_L2 which rolls-up to Markets_L1. In module I am calculating amounts at the city level using FX rates which are different depending on the parent Country. Is there a way I could summarise the cities to show a sub-total at Country level, but…
-
Retrieving last date with value
Hi, I have a module where I have time as dimension, as well as a list of equipment. The module is on daily level and has a value of either 1 or 0 depending on if the equipment is in service or not. These values are imported from another Anaplan model. I then have a second module, where I have the same list of equipment as…
-
Function for Format Conversion
Hi all, I just want to share a simple table as a summary of the functions needed to convert data across formats in Anaplan. Is not a big deal, but I hope it comes in handy to some of you. * Transform Text into Date is not that straight forward since it is needed to chop the date in 3 chunks: the day (DD), the month (MM)…
-
Select parent level
I would like to see a formula similar to parent but "inverted". When I have an unbalanced hierarchy and need a parent a similar level I would like to choose level from the top instead. example: invparent(item,3) which would always give the level 3 item for all parts of the list instead of trying to find our a way to get a…
-
Non Parent/Top Item List Relationship
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…
-
How to apply sum function(or any) on time line item?
Cee-Cee shop module is where my Spool & Cages incoming, Outgoing happens In Cee-Cee shop module i have Expected Cee-Cee return date which is nothing but (Date + Lead time days) Now in Expected Repair item return module, I have expected line item - What I'm trying to do is or requirement is to take from the incoming(Cee-Cee…
-
TIMESUM with Generic Weeks, and other summation options
Hi all, I thought I'd just summarise some of my learning experiences with summing data using Generic Weeks, since I couldn't find an article that brought this all together. First up, as you will probably know, you can't use the ordinary SUM function across the timescale if you've chosen Generic Weeks, as there are no…
-
Order of Lookups and SUM in formulas
Hi, I was going through a best practice video which mentioned that the order of lists in the module can help improve the performance if the lists are ordered similar to their order in General Lists section (because indexing becomes easier for the engine). I was wondering if there is a similar best practice when it comes to…
-
how to truncate concatenated strings with a separator
Hi guys, Assuming I have a concatenated strings with different length but with the same separator.. To illustrate: I have company code+ledger+asset code but with "-" in between.. This 3 do not have the same length.. Assuming here are my data 1. 111-123456-12456 2. 1111-1234-124 3. 11-12345-234 How can i get the mid…
-
Pulling data from numbered list into a module
Hi All, I need some advice/guidance. I'm building a tiny model that looks at the number of components used in products. We have one component that can be used in 5/6 products. The end result that I'm trying to achieve is a module that shows me data by components. What I've done is created a numbered list called "infeed…
-
YoY Change % to forecast a line item from actuals
Assume, I have the following line items using which I am trying to build a prediction/forecast for "Revenue". Revenue --> Actuals are imported for the actuals period, and this should be the forecast for the forecast period. YoY Chg% --> Imported input data that tells the % change in Revenue YoY for that month, for the…
-
Period on Period % Mvmt - Formula Summary Method
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…
-
Extract FY from Date
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
-
Displaying the first date of my historical years
Hi All, I was wondering if there is a syntax that gives me the first date of my historical years, based on the timescale settings. My Fiscal Year (currently) goes from 01-06-2018 to 31-05-2019 and I have 2 past years within my model, i.e. the date I'm looking for right now is 01-06-2016. I would like to have a syntax that…
-
Formula to populate time period formatted line item
Hi, I have two line items - Year and January - with no dimensions. Year is time period (year) formatted and a user selection January is time period (month) formatted and I am looking for a formula which uses the year the user has selected to return the period - For example, the user selects FY19 and the it returns Jan 19.…