How can I change the default dashboards for multiple existing users?

Ian Thompson shared this question 1 year ago
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

Comments (6)

photo
1

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

photo
1

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

photo
1

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

photo
1

No problems Ian, we will bug you again in the future on this. Enjoy your DBA work :)

photo
1

Hey Ian, just checking in. how did you get on with it all?

photo
photo
1

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