08-30-2024 05:09 AM
I'm trying to convert a 5YP forecasting file into an XFD excel import file. Unfortunately the business currently plans by year and 'scenario' (UD5) on the column so it's not as simple as adding the xfd tokens in. This is a simplified example of the planning file:
Has anyone got any prior experience of creating an xfd file with multiple dimensions in the columns? Ideally this would all be kept in one sheet, rather than splitting it one sheet per UD5.
09-02-2024 06:20 AM
You cannot create a template like this when using the XFD template if you want the OS to recognize the data. XFD templates must consist of named range where the first row of the named range holds the dimension tokens and the following rows contain the data intersections you want to populate you could take one of two approaches: