Under Consolidation Administration, there are a few options to schedule task flow to extract data from HFM.
If the option "Extract Data (deprecated）" is selected, data can be extracted to text files. But it seems there are restrictions to extract top level data. For example, when I have the following POV selected: account10000(base level), TotC1, TotC2,..., data does not get extracted from TotC1 but from base levels under TotC1 (While I only want the sum). When a parent level account is selected, some kind of top level for C1 and C2 are extracted as well. But it's a little bit messy here.
If the option "Extract Data to File" is selected, data is extracted all as expected, however in zipped format. This creates problem for my automation.
Any advice please? Thank you.