Develop a very basic Tableau report to demonstrate hierarchical security

£20-250 GBP

已完成

已发布

超过 7 年前

£20-250 GBP

货到付款

I have an Oracle database table with 1.5m rows of data. I need a Tableau report that sits over this table and filters the returned rows based on the login ID of the Tableau user. The login ID will represent a user in an organisational hierarchy. There are 4 levels to the hierarchy. Depending on which user logs in the data should be summed up to their level based on their reportees. If a manager has two employees one makes a sale of £50 and the other makes a sale of £75 then each employee logging in should see their own value i.e. £50 and £75 respectively. If their manager logs in then they should see a value of £125 and so on up the organisation hierarchy.

Database Development

Tableau

项目 ID: 13065117

关于此项目

9提案

远程项目

活跃7 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@Iasuki

To whom it may concern, I am a Tableau certified and software developer based in Dublin. I’ve been working with Tableau software since version 7 and with software development for more than 10 years. You can use an ‘User filter’ on Tableau to give and restrict access on row level, according to the user. I main issue in this case é that every time that you have a new user you must change the report manually to grant access. One way to solve this is create a table on your database to save the users and respective group that hi belongs, and create a view to provide the data to Tableau with the group access; so Tableau will filter the group. In this scenario you just need to update this table. Regards, Danilo Iasuki

£222 GBP 在3天之内

5.0

(1条评论)

2.4

9威客以平均价£223 GBP来参与此工作竞价

@Forket

Hello. No problem, would be happy to help you with this. Remember did similar report in project for UNICEF. One question: do you have cloud version of Tableau? In case of any questions feel free to chat. Thanks and have a nice day.

£388 GBP 在5天之内

5.0

(1条评论)

4.6

@vishnu5894

Hi, How are you? I have expert knowledge in leading BI tools such as tableau, qlikview and qliksense. I will do your requirement. I have done it's earlier for some dashboards.

£277 GBP 在1天之内