HFM Period Year Options as Variables
Hello Gurus,
Can someone please show me the syntax for using variables in the HFM data extract options - using the LKM-Hyperion Financial Management Data to SQL? For example, I created two variables 'HFMClosePeriod' and HFMCloseYear'. I want to use these variables to define the option values for 'Period' and 'Year' using the above variables. I have tested my interface using hard-coded values but this is not realistic. I have tried entering the varable name in the Value field [for example - #HFMClosePeriod] but the interface doesn't recognize the variable. John Goodwin's post recommended using a package but I receive the same results.
Your assistance is greatly appreciated!