Cognos Controller

 View Only
  • 1.  UDBR code for all accounts

    Posted Mon July 06, 2020 09:49 AM

    Hi all, just want to know if someone knows how to filter all zero level accounts in a UDBR script.

    Unfortunatelly using the "getAccountsInSummation" is not an option, as I do not pretend to put summation accounts on the script.


    Thanks in advance.



    ------------------------------
    Gilson Lins de Barros
    ------------------------------


  • 2.  RE: UDBR code for all accounts

    Posted Mon July 06, 2020 09:59 AM
      |   view attached
    Here are a few links on udBr

    1. Core documentation - https://www.ibm.com/support/knowledgecenter/SS9S6B_10.4.2/com.ibm.swg.ba.cognos.ctrl_ug.doc/c_udbrch.html
    2. Filtering objects - https://www.ibm.com/support/knowledgecenter/SS9S6B_10.4.2/com.ibm.swg.ba.cognos.ctrl_ug.doc/c_udbrfilterfunc.html#udbrfilterfunc


    ------------------------------
    paul YOUNG
    ------------------------------



  • 3.  RE: UDBR code for all accounts

    Posted Mon July 06, 2020 02:14 PM
    Hi Paul,


    Many thanks for your help, coding is not my speciallity but will ask my colleagues and try some scripts.

    The reason why I am trying UDBR is because there are some accounts here that sum up to a main and a statistical summation accounts.

    If I put both summation accounts on a Control Table, Controller eliminates twice, I am not sure if UDBR works this way too.


    Thank you.

    ------------------------------
    Gilson de Barros
    ------------------------------



  • 4.  RE: UDBR code for all accounts

    Posted Thu July 09, 2020 03:53 PM
    Hi Paul

    wonder if there is any training for UDBR scenarios that we can enroll in? thanks in advance

    ------------------------------
    Amelia Chun
    ------------------------------



  • 5.  RE: UDBR code for all accounts

    Posted Fri July 10, 2020 06:23 AM
    Majority of training for Cognos Controller is now carried out by BP - Arrow ECS Education
    Arrow remove preview
    Arrow ECS Education
    Introduction to IBM Cognos Controller Set Up Companies Set Up Accounts Configure the Application Enable Data Entry and Data Transfer Set Up Accounts to Show Changes over Time Enhance Data Analysis Enhance data analysis by using extended dimensions Enable and define extended dimensions Generate reports for extended dimensions Prepare accounts
    View this on Arrow >

    Normally UdBr was designed to handle specific issues that automatic journals could not handle properly, like changes in ownership structure.


    ------------------------------
    paul YOUNG
    ------------------------------