Planning Analytics

 View Only

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

    Posted Thu June 06, 2024 06:59 AM

    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 Thu June 06, 2024 08:03 AM
    Edited by Asgeir Thorgeirsson Thu June 06, 2024 08:06 AM
    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 Mon June 10, 2024 07:20 PM

    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 Thu June 06, 2024 07:38 PM

    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 Tue June 18, 2024 06:19 PM

    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


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

    Posted Wed September 25, 2024 08:58 AM
    Edited by Jesper Poulsen Wed September 25, 2024 08:59 AM

    Hi Asgeir

    I experience the same problem but only for some of my data. I have a chore with 3 export processes and only 2 of them have this problem.

     Have you raised this with IBM Support as it seems like a bug?



    ------------------------------
    Jesper Poulsen
    ------------------------------

    Original Message


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

    Posted Wed September 25, 2024 10:16 AM

    Apparently there is a potential problem with MDX views as source.

    My workaround was as simple as yours;  vExportValue = NVALUE;



    ------------------------------
    Kind regards,
    Jesper Poulsen
    ------------------------------

    Original Message


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

    Posted Wed September 25, 2024 10:31 PM

    Hi Jesper, 

    So I raised a ticket with IBM when I first experienced this issue.  After 68 days with IBM support and no resolution, I was finally able to solve it myself.

    I played with the dimension placement, and ended up with a an MDX statement (uses a calculated WITH MEMBER) with only a 1 element column and it worked, prior to this I was using an MDX statement with a 3 element set in the columns and it would return nothing when run via a chore.  Still no idea why it works when run manually with multiple columns but fails via a chore.  IBM only closed my case, not sure if it was passed on to the developers to find an answer/fix.

    I'm not sure if this is possible for your situation, but it worked for me.

    Regards,



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

    Original Message