User access levels for drill path layers
Please let me know if it is possible to set up different user access levels for drill paths layers.
Scenario:
A card on shared page consists of a bar graph with company-wide term count by location, and a single drill path layer has been set up with a table to display the employee names along with other pertinent fields.
While all users with access to this page/card should have access to company wide data, I would like to limit how much underlying data is accessible when drilling down. (This is not a PDP issue since it's not about restricting data based on fields such as department code, business unit, etc.)
Desired action:
Users Group A: Full access to fields which were selected for this drill path layer, Users Group B: Access to some fields only. Users Group C: No ability to drill down. They should see only see the bar graph; no access to underlying data.
Thank you!
Best Answers
-
@serendipity This is an interesting use case. Unfortunately, I'm not aware of any ability to limit field access or to define a user specific drill path. I wanted to comment, though, because I want to make sure to follow along and hear any solution that is offered. This may end up being a feature request though.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Hi @serendipity
@ST_-Superman-_ is correct. This functionality doesn’t exist currently especially since you’re wanting to conditionally trigger the drill path action based on your data. I’d recommend putting in a feature request for this type of functionality. The only possibility I would see is to utilize PDP to restrict access to the columns in the drill path but for your group C it would still allow access to the drill path but it would be empty.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Hi @serendipity
@ST_-Superman-_ is correct. This functionality doesn’t exist currently especially since you’re wanting to conditionally trigger the drill path action based on your data. I’d recommend putting in a feature request for this type of functionality. The only possibility I would see is to utilize PDP to restrict access to the columns in the drill path but for your group C it would still allow access to the drill path but it would be empty.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
technically, @GrantSmith and @ST_-Superman-_ are correct, but you do still have options / hacks.
1) build your initial card on a dataset view of aggregated data. apply PDP policies as appropriate.
2) when you create a drill path, you can reference the original dataset, OR point to a completely different dataset. Create a second DSV at a second layer of aggregation as appropriate, and again, control PDP. you can choose to allow Group A and Group B to see DSV 2 but NOT Group C.
3) when you create a drill path you can decide whether or now you allow drill down to the row level, or if drilling stops on a card. depending on desired outcome that can make the creation of a separate DSV superflouous.
Side note. this gets messy fast. usually people assume a card will drill to the same dataset ... when it doesn't then you get problems when you migrate to a new dataset or need to start maintaining beast modes in two places... but it works.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"3
Answers
-
@serendipity This is an interesting use case. Unfortunately, I'm not aware of any ability to limit field access or to define a user specific drill path. I wanted to comment, though, because I want to make sure to follow along and hear any solution that is offered. This may end up being a feature request though.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Thank you very much@ST_-Superman-_ !
0 -
Hi @serendipity
@ST_-Superman-_ is correct. This functionality doesn’t exist currently especially since you’re wanting to conditionally trigger the drill path action based on your data. I’d recommend putting in a feature request for this type of functionality. The only possibility I would see is to utilize PDP to restrict access to the columns in the drill path but for your group C it would still allow access to the drill path but it would be empty.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Hi @serendipity
@ST_-Superman-_ is correct. This functionality doesn’t exist currently especially since you’re wanting to conditionally trigger the drill path action based on your data. I’d recommend putting in a feature request for this type of functionality. The only possibility I would see is to utilize PDP to restrict access to the columns in the drill path but for your group C it would still allow access to the drill path but it would be empty.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Thank you very much @GrantSmith!
0 -
Thank you very much @GrantSmith!
0 -
technically, @GrantSmith and @ST_-Superman-_ are correct, but you do still have options / hacks.
1) build your initial card on a dataset view of aggregated data. apply PDP policies as appropriate.
2) when you create a drill path, you can reference the original dataset, OR point to a completely different dataset. Create a second DSV at a second layer of aggregation as appropriate, and again, control PDP. you can choose to allow Group A and Group B to see DSV 2 but NOT Group C.
3) when you create a drill path you can decide whether or now you allow drill down to the row level, or if drilling stops on a card. depending on desired outcome that can make the creation of a separate DSV superflouous.
Side note. this gets messy fast. usually people assume a card will drill to the same dataset ... when it doesn't then you get problems when you migrate to a new dataset or need to start maintaining beast modes in two places... but it works.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"3 -
Thank you very much @jaeW_at_Onyx. All of your Domo videos are incredibly informative so I am thrilled and grateful to have heard from you with your hack. I will give this a try although I can imagine it getting messy, as you've already pointed out. There are several cards like this on my dashboard--with similar but slightly different needs-- so it makes my head spin thinking of how each need to be adjusted to incorporate your suggested approach. LOL. Thank you again.
0 -
@serendipity if it were my requirement, I would have two separate cards for two different audiences. (AND still apply PDP as necessary).
Also, check in with your CSM, I believe Domo were working on column based PDP but I don't know how far they got on that.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Thank you @jaeW_at_Onyx
I have 2 separate dashboards set up for now since it turns out that we do not have Dataset view enabled.
And yes, a column based PDP would be of tremendous help, and I hope it is offered to us at some point! Thank you again! 😀
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive