Write Access Driver to Parent Item

Hi, I want to use breakback function and Write Access Driver.

We have Country List which has Region List as Parent.

And Users input to "Adjust Lineitem" and it set as breakback.

In this table, I want to users can write "Adjust" by Region List, and cannnot write by Country List.

I want to set a Boolean Lineitem to Write Access Driver like this table.

But I couldn't. Do you have any idea?

Region	Country	Write
	Germany
Europe		☑
	Japan
	Korea
Asia		☑

Accepted answers

pyrypeura

Hi @CommunityMember125605 ,

You could check out this article about calculating hierarchy levels Re: Calculating Levels in a Hierarchy for Dashboard Filtering . When you have hierarchy levels calculated you can create boolean for the breackback with formula 'Hierarchy Level'=2 .

Please note that breakback doesn't change line items that have only read access.

All comments

pyrypeura

Hi @CommunityMember125605 ,

Please note that breakback doesn't change line items that have only read access.

ShubhamCh

Hi @CommunityMember125605

According to your requirement, you want Users to input values in Region cell and apply breakback. You don't want Users to input anything in the Countries' cells means read-only cells and that's the problem here. Even if you create a write access driver which lets you enter the value in Region cells, the country cells will be read only and the breakback won't work.

Breakback only works on writeable cells.

@ManjunathKN please have a look at the problem and confirm the above mentioned statement.

Thanks!

- Shubham

ManjunathKN

Hi @ShubhamCh

It will work if the write and read access are different on each levels.

for country, it should be true for read access and for region it should be true for write access. It can be achieved by hierarchy level filtering method as mentioned by @pyrypeura.

Thanks,
Manjunath

Quick Links

Can you help?

Unanswered questions

Can we disable Create page button from the UX page
I want to disable the [create page] button for the end user from the dashboard. The end user can create a page or worksheet to link to the module to edit the data. can anyone please give some suggestion? Thx…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…