I using the "LKM Hyperion Financial Management Data to SQL" to extract data out of HFM.
1. The period value is not being returned, being left blank. Is there something special that I need to do to get the period value (i.e. 1, 2, 3, etc) in the output column? All other values are being displayed correctly. Is this a bug?
2. Is there a way to extract all base members for Accounts and Entities? i.e. Net_Income.[Base] or Enity.[Base]
Or do I need to list all values to be extracted? I know I can do this in HFM Extended Analytics (EA) and was thinking the ODI adapter would behave the same.
Using ODI v10.1.3.6.3 - 09/06/2010