We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Management – Multi Column with Period dimension as driver load rule ignores selected period

Received Response
21
Views
6
Comments
edited Feb 23, 2021 1:45AM in Planning 6 comments

Summary

Data Management – Multi Column with Period dimension as driver load rule ignores the selected start period and always picks the first data column in the file.

Content

Hi Folks,

I have a data load rule setup with the following settings:

1. File Type: Multi Column Numeric Data

2. FD: Comma

3. Amount expression: Driver=Period;Column=7,18

 

As indicated in the expression, the file I'm trying to load has twelve periods starting from column 7. 

Issue: Data Management ignores the selected start period and always loads data starting from the first data column in the file. For example, if I want to load the last six periods in the file and select Jun-FY21 as the start period and Dec-FY21 as end period, Data Management ignores the selected period and loads Jan-FY21-Jun-FY21 data in Jun-FY21-Dec-FY21 in Planning.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!