You cannot create derived text measures from elements in text file connections.
When derived text measures are used in cube schemas to build Essbase models, the XOLAP Model option and XOLAP Model with Oracle OBIEE option will not be available for the model.
Derived text measures are not fully supported in Spreadsheet Add-in. Use Smart View to view members in derived text measures.