Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  IBM Controller FAP bug ?

    Posted 2 days ago

    Hello,

    It was not found by me, but a customer pointed us to the feeders section in the FAP cube that pushes IBM Controller data to IBM PA.

    Basically, when the FAP restarts, it generates feeders like this:


    feeders;
    ['YTD'] => ['Monthly'], ['YTD'] => DB('DestinyMonthlyCompanyDetails', !FAP_Division, !FAP_Counter Dimension, !FAP_Department, !FAP_Product, !FAP_Currency, !FAP_Transaction Currency, !FAP_Consolidation Perspective
    , !FAP_Closing Version, !FAP_Contribution Version, !FAP_Account, !FAP_ActualityMonthly, !FAP_Origin Company, !FAP_Counter Company, !FAP_Company, !FAP_Journal Number, ATTRS('FAP_PeriodMonthly', !FAP_PeriodMonthly, '+1'), 'Monthly');

    While it should be:


    feeders;
    ['YTD'] => ['Monthly'];
    ['YTD'] => DB('DestinyMonthlyCompanyDetails', !FAP_Division, !FAP_Counter Dimension, !FAP_Department, !FAP_Product, !FAP_Currency, !FAP_Transaction Currency, !FAP_Consolidation Perspective
    , !FAP_Closing Version, !FAP_Contribution Version, !FAP_Account, !FAP_ActualityMonthly, !FAP_Origin Company, !FAP_Counter Company, !FAP_Company, !FAP_Journal Number, ATTRS('FAP_PeriodMonthly', !FAP_PeriodMonthly, '+1'), 'Monthly');

    In other words, the comma after ['Monthly'] needs to be a semicolon.

    I have no more information than this, even not a version number, but does it ring a bell?

    My workaround is to use the RuleLoadFromFile TI command, each time the FAP is restarted.

    Best regards,

    Wim



    ------------------------------
    Wim Gielis
    Senior Consultant
    Aexis International
    Sint-Stevens-Woluwe
    +32496225001
    ------------------------------


  • 2.  RE: IBM Controller FAP bug ?

    Posted 2 days ago

    Thanks for highlighting this, we also saw the same on our environment and have updated the feeder manually. Numbers were not incorrect at reporting cubes, probably because feeder file was not recreated. Surprisingly, Rule saves with that syntax without errors.



    ------------------------------
    Rohit Shrivastav
    ------------------------------



  • 3.  RE: IBM Controller FAP bug ?

    Posted 2 days ago

    Thank you Wim and Rohit,

    We'll investigate and log, it does look as a defect for FAP,



    ------------------------------
    Svetlana Pestsova
    IBM Planning Analytics Product Manager
    ------------------------------