It’s been a long time since I blogged, looked at OTN, Network54 and used PS3, I was busy house hunting and learning FDM (not FDMEE).
- Currency – Stores and displays in the default currency.
- Non-currency – Stores and displays as a numeric value.
- Percentage – Stores a numeric value and displays as a percent.
- Date – Displays as a date.
- Text – Displays as text.

I think what Planning does is it runs an internal mechanism which matches this ID and shows us the VALUE. So what will happen if I use @XREF on a text member.
SELECT * FROM smpplnadmin.hsp_text_cell_value;


How good is this in a real environment
Not so good , what if there are different text measures and they all are not XREFed. We’ll get issues when we try to copy the values from HSP_TEXT_CELL_VALUE.
So what alternative do we have, well I can create a DATAEXPORT script and pull all the values for the text measure.
//ESS_LOCALE English_UnitedStates.Latin1@Binary
SET DATAEXPORTOPTIONS
{
DataExportColFormat ON;
DataExportColHeader Account;
DataExportOverwriteFile ON;
};
FIX(FY12,
“HSP_InputValue”,
Working,
Forecast,
@RELATIVE(“TotalGeography”,0),
@RELATIVE(“YearTotal”,0),
Local,
Comments)
DATAEXPORT “File” “,” “C:tempcomments.txt” “0”;
ENDFIX
In the above example I’ll get a file similar to this.
“HSP_InputValue”,”FY12″,”E01_101_1110″,”BAS”,”Local”,”Forecast”,”Working”,”Jan”,1
“HSP_InputValue”,”FY12″,”E01_101_1110″,”BAS”,”Local”,”Forecast”,”Working”,”Feb”,2
Load that to an external table and create a load file by joining the data to TEXT_ID which can be used by OutlineLoad and load that in the target application.
Pittsburgh,Comments,”HSP_InputValue,FY12,E01_101_1110,BAS,Local,Forecast,Working,Jan”,Consol
Chicago,Comments,”HSP_InputValue,FY12,E01_101_1110,BAS,Local,Forecast,Working,Feb”,Consol
Update 03/12/2014
After I wrote this I thought of testing the export data feature of 11.1.2.3 environment and see whether it can generate the load file.
It generates the file in the required format.
Hi Celvin,
If it is an EPMA application, then I might also explore the data syncronizer option with scheduled load activity. I presume that might of some help here.
I presume there might a workaround available through ODI for this as well, but need to check the same.
Hi Celvin,
Thanks for your blog. It is very helpful. But The line where you have mentioned that “Load that to an external table and create a load file by joining the data to TEXT_ID which can be used by OutlineLoad and load that in the target application.” that is not clear. Can you please explain it in more detail ?
Regards,
MG