Planning Analytics

 View Only

  • 1.  Issue with Chore-Scheduled Export Process Not Returning Values

    Posted 29 days ago

    Hi all,

    I hope this message finds you well.

    I'm encountering an issue with a chore that runs an export process for cube data. The process is designed to export the data from the cube, and I've noticed the following behavior:

    • When I manually run the export process, it works perfectly, exporting all the data with no issues.
    • Similarly, if I manually run the chore that includes this process, everything functions correctly and the data is exported as expected.
    • However, when the chore is triggered by its schedule, the process runs but no values are exported for the records.

    I'm puzzled by this discrepancy and would appreciate any insights or suggestions from the community and the PAW development team.

    Has anyone experienced a similar issue? Are there specific settings or considerations for chore-scheduled processes that might be causing this?

    Thank you in advance for your help!

    Cheers, Asgeir



    ------------------------------
    Asgeir Thorgeirsson
    ------------------------------


  • 2.  RE: Issue with Chore-Scheduled Export Process Not Returning Values

    Posted 29 days ago
    Edited by Asgeir Thorgeirsson 29 days ago
    I found a temporary solution to the issue. It seems that the
    Value in the data source part of the process is "0" when the process is run by the system chore, but
    SValue returns the correct string value.
    My workaround is to use SValue and convert it as needed:
    PatchValue = StringToNumber(SValue);
    This resolves the problem for now, but I'm still looking for a more permanent solution.
    All dimension members in the cube are numeric
    Why would Value fail to return data, only when run by the system chore?



    ------------------------------
    Asgeir Thorgeirsson
    ------------------------------

    Original Message


  • 3.  RE: Issue with Chore-Scheduled Export Process Not Returning Values

    Posted 25 days ago

    Unfortunately, the StringToNumber trick did not work for me.  It appears as though the view is just not getting generated at all.



    ------------------------------
    Craig Sawers
    ------------------------------

    Original Message


  • 4.  RE: Issue with Chore-Scheduled Export Process Not Returning Values

    Posted 29 days ago

    Hi Asgeir, 

    I am experiencing the same issue, with a process that creates a view and generates an email to report any changes from a snapshot.  Your description of the issue is exactly the same.  I have a support ticket open at the moment for IBM to look into this.  

    I will try your 'String' resolution as a temporary fix.  

    Thanks,



    ------------------------------
    Craig Sawers
    ------------------------------

    Original Message


  • 5.  RE: Issue with Chore-Scheduled Export Process Not Returning Values

    Posted 17 days ago

    Hi Craig,

    Here is a snippet that may help (from the old perspectives wizard).

    if (VALUE_IS_STRING=1,CellPutS(SVALUE,........, CellPutN(NVALUE, ...);

    One other thing to check is:

    If the strings are created by a rule, are they fed correctly.

    Jules



    ------------------------------
    Julian Sedgewick
    ------------------------------

    Original Message