The bottom of page 175 in the 18.104.22.168 HFM admin guide says:
To extract data to a database, you must be assigned the Administrator or Extended Analytics security role.
If you are not assigned the Extended Analytics security role, these restrictions apply for extracting data:
- You can extract only base level data for ICP and all Custom dimensions.
- You can select only one Scenario and one Year dimension.
- You can select only the Periods that are in the Scenario's default frequency.
Here is the HFM role mentioned:
Providing EA role helped solve the issue. I looked at HFM doc but only the roles and said EA role is to extract data to database. Assumed it is not applicable to flat file extract. Should have read the EA part in hfm doc.