Planning Analytics

 View Only
  • 1.  Skipping a column in Workbench in PAW

    Posted Thu March 31, 2022 12:33 PM
    I use Workbench in PAW to edit TI processes but it does not seem to have a feature to ignore or skip a column in a flat file.

    Can I skip a column in Workbench?

    Skipping a column in TI:

    Workbench:

    Thanks,
    Kong

    ------------------------------
    Kong Intrasinghathong
    Master Consultant
    QueBIT Consulting

    Analyze. Plan. Achieve.
    https://quebit.com
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Skipping a column in Workbench in PAW

    Posted Thu March 31, 2022 03:54 PM
    Hi Kong,
    The Ignore option is under the Type:
    Hope it helps,

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



  • 3.  RE: Skipping a column in Workbench in PAW

    Posted Thu March 31, 2022 11:00 PM
    Hi Svetlana,

    Thank you for your answer.

    I can ignore some columns in Workbench now. However, the "Ignore" settings from a PAW book do not seem to show up in Workbench.
    Please find an example from my screenshots above. Both screenshots display the same TI process. 

    Should I only use a PAW book or Workbench for editing a TI process (no mixing between the two)?
    I am asking this question because a variable name in the second screenshot is misleading when the 4th variable name from the top is "Cost_Center". 

    Regards,
    Kong


    ------------------------------
    Kong Intrasinghathong
    Master Consultant
    QueBIT Consulting

    Analyze. Plan. Achieve.
    https://quebit.com
    ------------------------------



  • 4.  RE: Skipping a column in Workbench in PAW

    Posted Thu March 31, 2022 11:07 PM
    Edited by System Fri January 20, 2023 04:49 PM
    Hi Kong,
    Interesting, I'll investigate further the pass of Ignor between the two setting.
    The intentional place for TI process work is the Workbench, so it's giving you more powerful options.

    The "Ignore" pass between the books and WB is likely a defect, thank you for reporting the issue.
    Best Regards,

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



  • 5.  RE: Skipping a column in Workbench in PAW

    Posted Fri April 01, 2022 08:59 PM
    Hi Svetlana,

    You are welcome!

    Thank you for your answers and the information.
    I like the Workbench because I do not need to resize my rule and TI objects. It saves me a lot of time.
    I will explore more options in the Workbench like you suggested.  

    Best regards,
    Kong

    ------------------------------
    Kong Intrasinghathong
    Master Consultant
    QueBIT Consulting

    Analyze. Plan. Achieve.
    https://quebit.com
    ------------------------------