I want some help in using DCA - Dynamic Cell access

Chandrashekar1997
Chandrashekar1997
edited May 17 in Modeling

Hi, Below we have 3 line items in a same module, I want to apply DCA in such a way,

If I select Country, Sub-region and Region should disable
If I select Sub-region, and Country and Region should disable
If I select Region and Sub-region and Country should disable.

Can you help me in writing the formule for Read and Wirite booleans.

image.png

Tagged:

Best Answer

  • BarunJha
    BarunJha
    Answer ✓

    @Chandrashekar1997

    The conditions will need 4 DCA Boolean line items

    1. DCA Read = TRUE
    2. DCA Region = IF ISNOTBLANK(Country) THEN False Else IF ISNOTBLANK(SUB Region) THEN FALSE ELSE TRUE
    3. DCA Sub Region = IF ISNOTBLANK(Country) THEN FALSE ELSE TRUE
    4. DCA Country = IF ISNOTBLANK(Sub Region) THEN FALSE ELSE IF ISNOTBLANK(Region) THEN FALSE ELSE TRUE

    Read Access Driver for all three LI = DCA Read

    Write Access Driver for Region, Sub Region and Country is equal to DCA Region, DCA Sub Region and DCA Country respectively

Answers

  • TristanS
    TristanS

    @Chandrashekar1997 I would add the following boolean format line items:

    • Country Not Selected? = ISBLANK(Country)
    • Sub Region Not Selected? = ISBLANK('CCC_Sub-Region')
    • Region Enabled Not Selected? = ISBLANK('CCC_Region')
    • Country DCA = Sub Region Not Selected? and Region Enabled Not Selected?
      • Use Country DCA for the Read / Write Access to the Country line item
    • Sub Region DCA = <you can build logic for this using Country DCA as template>
    • Region DCA = <you can build logic for this using Country DCA as template>

Categories