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.
DATAEXPORT “File” “,” “C:tempcomments.txt” “0”;
In the above example I’ll get a file similar to this.
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.
After I wrote this I thought of testing the export data feature of 220.127.116.11 environment and see whether it can generate the load file.
It generates the file in the required format.