Define members on each axis of the data form appropriately and define import options correctly because this affects which data is imported.
To import only rows that contain data for the specified columns:
In Planning, specify the data form columns (for example, Descendants Inclusive of YearTotal).
For the dimension for which to import members to the row, add the dimension root to the data form design.
For example, to load accounts on the row, place the Account dimension root on the data form's row.
When you run ImportFormDefinition, use these options: /AR /-AC
Accounts are loaded from the data file if members from each dimension making up a cell match members on the data form columns, pages, and POV. The added rows are filtered by members on the page. For example, if you place some members on the page, only accounts that contain data for those members are added to the data form. Rows are filtered by the members on the POV. If the data file contains data for the salary account for 2008, but only 2009 is on the POV, the salary account is not added to the row although it exists in the data file.