Cognos Controller

 View Only

Cognos Controller Data export from DB2 into SQL

  • 1.  Cognos Controller Data export from DB2 into SQL

    Posted 4 days ago
    Hi everyone,
    I have the following issue with one customer.
    _changed CCR environment from DB2 db to SQL db
    _ETL transfer of company statements from ledger system into CCR has not been set up in SQL environment, yet.
    interim procedure:
    1. import company statements from ledger system into CCR on DB2
    2. export company statements from CCR on DB2 via "Transfer/ Data export", picking only REPO/ BASE
    3. import the file into CCR on SQL via "Transfer/ data import"

    Problem:
    'only' PL account are overwritten in journals (journal type 'C')
    We checked in preview before import, that there is no reference to a JT in the file.

    I'd be grateful for any hint, how we could avoid this behaviour.
    Cheers,
    Heidi

    ------------------------------
    Heidi Ullrich
    ------------------------------