Please find attached a document I created which lists all the functions available in the BI Expression builder up to 11.09.04.011 along with examples of the syntax and how they can be used.
The BI expression builder is found in: BI, EB, ETL, ETL-Allocations, Publisher, Performance Planning and CRM. XLOne also uses many of the functions that the expression builder has in it although the look and feel is slightly different.
Mastering the expression builder is the key to mastering many of the products mentioned above.
I’ve updated the expression builder document to include the XLOne specific functions: