Disabling boolean check for only particular member in a list

Hi,

I have a flat hierarchy, which is used in a module.

A Boolean line item is created in same module, but I want my Boolean field to be enabled only for particular member in the dimension list and disabled for all other members.

Regards,

Madhu

Accepted answers

MadhabikaM

Thank you @DavidSmith for your quick response.

All comments

DavidSmith

@MadhabikaM

Dynamic Cell Access will resolve this

1. Create a module by the dimension and call it Access Driver - dimension name

2. Add two line items, both Boolean formatted called Read? and Write?

3. Make the formula for Read? = NOT Write?

4. Tick the relevant Dimension member for the Write access

5. Then in your target module, in the blueprint, scroll to the right and you will see two columns for Read Access Driver and Write Access Driver

6. Then select the access driver module line items from 2. above

If you don't want the values to appear in the other dimensions, don't set a driver for the Read Access Driver

I would look at the App Hub and download the following if you need for examples for DCA

Dynamic Cell Access - App hub model

Also, look at this article

Dynamic Cell Access - Tips and tricks

I hope this helps

David

LipChean_Soh

Hi,

You can use DCA as shown below:

Screen Shot 2019-06-07 at 10.15.32 AM.png

Thanks,

LipChean

MadhabikaM

Thank you @DavidSmith for your quick response.

MadhabikaM

Hi @LipChean_Soh ,

Thanks for your quick response,I have added the Boolean on? in by Flat List as Properties.

Flat List is used in my target module, but in blue print view when I am trying to assign that property in write access Driver(3rd screenshot by you).

I don't see the property Boolean on? from available property drop down, is it anywhere I need to enable this to be viewed.

Thanks,

Madhu

Jitendra.Vishnolia

Hi ,

Create a line item in the same module and refer the list property in it (Boolean Formatted). Use this line item in write access Driver.

Thanks

DavidSmith

@Jitendra.Vishnolia @MadhabikaM

To align with current best practices, Access Driver are only available if they are housed in Modules and line items

As I mentioned, and @LipChean_Soh showed, you need to create an Access Driver module to have the Boolean line item that can be used for DCA

David

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…