How can I change the default dashboards for multiple existing users?
Answered
How can I change the default dashboards for multiple existing users?
We are changing our version of reports and I need to setup the default dashboards for multiple people and remove the old default dashboards.
Are there SQL tables I need look at and is this safe to do?
Ian
Hi Ian,
you can actually do this via the Dashboard Manager utility, however, if you want to do it via the backend then the table you want is PersonFavourite.
The columns you'll be interested in are IpPerson which identifies the user (you can check who the person is by looking up this ID in the Person table, IpPerson), ContentId which identifies the dashboard (this is the foreign key to GroupId in the ReportGroup table which is the dashboard table), and SequenceNumber which identifies the order of the dashboard tabs.
Having said that, let me remind you that we don't really recommend such backend modifications, so be very careful if you choose to do it, and please don't forget to backup your Yellowfin database immediate beforehand so you can rollback if something goes wrong.
regards,
David
Hi Ian,
you can actually do this via the Dashboard Manager utility, however, if you want to do it via the backend then the table you want is PersonFavourite.
The columns you'll be interested in are IpPerson which identifies the user (you can check who the person is by looking up this ID in the Person table, IpPerson), ContentId which identifies the dashboard (this is the foreign key to GroupId in the ReportGroup table which is the dashboard table), and SequenceNumber which identifies the order of the dashboard tabs.
Having said that, let me remind you that we don't really recommend such backend modifications, so be very careful if you choose to do it, and please don't forget to backup your Yellowfin database immediate beforehand so you can rollback if something goes wrong.
regards,
David
Hi Ian,
I'm cleaning up my worklist and i noticed that this ticket is still open and in the "Awaiting Reply" status, so I'm wondering how you got on it and whether you would like the ticket closed or not?
If you could please let us know then that would be great!
thanks,
David
Hi Ian,
I'm cleaning up my worklist and i noticed that this ticket is still open and in the "Awaiting Reply" status, so I'm wondering how you got on it and whether you would like the ticket closed or not?
If you could please let us know then that would be great!
thanks,
David
Sorry Big Dave,
I have two parts to my role.
- YellowFin Developer / Administrator.
- Data Warehouse administrator / support.
The data warehouse part has been taking up all of my time lately.
Ian
Sorry Big Dave,
I have two parts to my role.
- YellowFin Developer / Administrator.
- Data Warehouse administrator / support.
The data warehouse part has been taking up all of my time lately.
Ian
Hi Ian,
I'm wondering how you got on with the subject matter of this Question, and whether we should close this off?
regards,
David
Hi Ian,
I'm wondering how you got on with the subject matter of this Question, and whether we should close this off?
regards,
David
Hi David,
I need help with a similar situation
Hi David,
I need help with a similar situation
Hi Ashan,
Thanks for your reply.
To give the access to default dashboards we have a community article which will help you.
If you want to take away the access, make those dashboards secure and give access to people who ever you want to give it to.
Let me know if you have any questions.
Kind Regards,
Mahesh
Hi Ashan,
Thanks for your reply.
To give the access to default dashboards we have a community article which will help you.
If you want to take away the access, make those dashboards secure and give access to people who ever you want to give it to.
Let me know if you have any questions.
Kind Regards,
Mahesh
Hi Ashan,
Hope you are doing well.
I am marking this as answered for the moment.
If you still have any questions, please feel free to reply back.
Kind Regards,
Mahesh
Hi Ashan,
Hope you are doing well.
I am marking this as answered for the moment.
If you still have any questions, please feel free to reply back.
Kind Regards,
Mahesh
I am running into a similar situiation and want to set a new dashboard as the "Leftmost" dashboard. Is there a way to do that via the distribute option?
I am running into a similar situiation and want to set a new dashboard as the "Leftmost" dashboard. Is there a way to do that via the distribute option?
Replies have been locked on this page!