Open Forum

Expand all | Collapse all

Dimension Decision Tree

  • 1.  Dimension Decision Tree

    TOP CONTRIBUTOR
    Posted Jul 02, 2019 11:26 AM
    Hello,
    Is there a way in NAV base or with coding to make a Dimension have more of a decision tree feel?

    More or less: You select Dimension A first and then based on what you select there Dimension B only shows results tied to that?

    Example: You select Medical in Dimension A, and then in Dimension B only options related to the Medical (ER, Chiro, OBGYN, etc) would come up to be selected vs the entire list in Dimension Value?

    Thanks!

    ------------------------------
    Andrea Riviezzo
    Functional Analyst
    Charlotte's Web, Inc.
    Louisville CO
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Dimension Decision Tree

    TOP CONTRIBUTOR
    Posted Jul 02, 2019 05:18 PM
    @Andrea Riviezzo you may be able to use Dimension Combinations for this. Dimension Combinations can be defined to avoid posting entries with contradictory or irrelevant dimensions. You can block or limit specific combinations of two dimensions. A blocked dimension combination means that you cannot post both dimensions on the same entry regardless of what the dimension values are. A limited dimension combination lets you post both dimensions to the same entry, but only for certain combinations of dimension values.

    You can find Dimension Combinations by using Search or Tell me depending on your version.


    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Dimension Decision Tree

    SILVER CONTRIBUTOR
    Posted Jul 03, 2019 02:17 AM
    Hi Andrea,

    I agree with the Cynthia ,you can use "Dimension Combination" feature to define the combination of dimension,say if Dimension B is defined as blank with the Dimension A, then combination is allowed to use.

    If you want to put validation on dimension value then there needs to be put custom code.

    ------------------------------
    DEEPAK KUMAR
    BC/NAV Consultant
    AlleTechnologies Inc.
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Dimension Decision Tree

    TOP CONTRIBUTOR
    Posted Jul 04, 2019 02:26 PM
    You could also try building the hierarchy within the dimension values page itself.  Using this you can build the groups and then the actual selectable values underneath the group.  The user would just select one value but still gives you the option of reporting at the posting level or the group level.


    ------------------------------
    David Wiser
    Project Manager
    Tigunia
    Seattle WA
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role