Can I insert measure data from different sources in applications?
Yes, you can use data from multiple sources such as SAP, JD Edwards, Oracle Financials, Analytic Services and spreadsheets using Oracle's Hyperion® Application Link.
How many characters can I use in a measure formula
You can use 2000 characters in a formula. However, large formulas may become difficult to maintain and impact performance.