Hi all,
I have a module in which a line item is date formatted and need to find in which week the dates will come as i have to calculate weekly average for all the weeks of a year.
Please suggest how to achieve this.
Thanks
@saurav4ss
Create a SYS Time Daily module with a line item named parent, formatted as week, with the formula being parent(item(time)). Now, in the source module where you have a line item formatted as date, you can use that to do a lookup to the line item in the SYS Time Daily module. Give that a shot.
Rob
The July and August releases added several useful capabilities to Anaplan AI, including the ability to create and retrieve saved views and create list import actions. It would be valuable to extend these capabilities to support the full end-to-end user story: creating a saved view and using it as the source for an import…
Hello there, we are using AnaplanXL to pull data from 3 different sources into one Excel file. Two of them are Azure SQL data bases and the third is Anaplan itself. Whenever the Excel is opened 3 pop up windows to log in to each data base appear. Until they appear and everything is entered or clicked already 2 minutes are…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
