Planning Analytics

 View Only

  • 1.  after upgrade ConsolidatedCountUnique is very slow

    Posted Tue March 10, 2020 02:34 PM
    Hello,
    I wanted to know if someone understood my case, if yes, how they solved it.

    I updated planning analytics from version 2.04 to 2.09, after the update the ConsolidatedCountUnique function has become very slow, to become unusable.
    has happened to any of you?
    are there alternatives to the ConsolidatedCountUnique function?
    Thanks
    Massimo


    ------------------------------
    Massimo
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: after upgrade ConsolidatedCountUnique is very slow

    Posted Wed March 11, 2020 08:41 AM
    There was a change made in PA 2.0.7. Please see https://www.ibm.com/support/pages/node/3117345 for more details.

    ------------------------------
    BRIAN Laferriere
    ------------------------------

    Original Message


  • 3.  RE: after upgrade ConsolidatedCountUnique is very slow

    Posted Wed March 11, 2020 12:36 PM
    In my experience consolidate functions are very slow for large data, i think the only alternative would be to add a new item for calculation and make a rule in N level with ifs and maybe ELISCOMP or ELCOMP.

    ------------------------------
    Luis Javier Larranaga Delgado
    ------------------------------

    Original Message


  • 4.  RE: after upgrade ConsolidatedCountUnique is very slow

    Posted Tue March 17, 2020 05:18 AM
    Hello,
    I found the solution with the help of IBM support, I put 2 as an option instead of zero, as suggested also in the link reported by Brian.
    thanks

    ------------------------------
    Massimo Deambrogio
    ------------------------------

    Original Message