magnify
Home Topic Business Intelligence

Business Intelligence

Home Forums Corporate Performance Management Business Intelligence

This topic contains 2 replies, has 2 voices, and was last updated by  Manny 3 years, 5 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #624

    Jamie Scott
    Keymaster

    Business Intelligence Topics go here

    #732

    Manny
    Participant

    Hi All,

    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.

    Regards,

    Manny

    Attachments:
    You must be logged in to view attached files.
    #734

    Manny
    Participant

    Hi all,

    I’ve updated the expression builder document to include the XLOne specific functions:
    GetBaseCurrCdFromLdg,
    GetBaseCurrCdFromSysProfile,
    GetExCurrAmtByDate,
    GetExCurrAmtByPeriod,
    GetExRateByDate,
    GetExRateByPeriod,
    GetSysProfileFromLdg

    Regards,

    Manny

    Attachments:
    You must be logged in to view attached files.
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.