You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Getting error while bursting BIP report output to sFTP server

    in Reporting and Analytics for ERP 1 comment

    Summary:

    Getting below error while bursting BIP report output to sFTP server-

    Below is my SFTP bursting query-

    *with hash_q as query*

    select
    distinct HASH "KEY",
    'MicroStrategy_Inventory_Rpt_Template.rtf' template,
    'en-US' locale,
    'text' output_format, --Output type
    'FTP' del_channel, --WCC for the content server
    'XXSW_MICROSTRATEGY_INVENTORY_' || :p_region || '.csv' output_name, --Primary File (or File Name)
    'EMEAB2BDMZSFTP' parameter1, --Server name
    NULL parameter2, --USERNAME
    NULL parameter3, --password
    '/outgoing/OracleCloud/COA' parameter4, --remote directory
    'XXSW_MICROSTRATEGY_INVENTORY_' || :p_region || '.csv' parameter5, --Title
    'True' parameter6 --secure
    from hash_q

    I have enabled bursting in report properties as well-

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!