Need help in assigning private reports and dashboards.

Hi Team,

Any update on this please?

Regards,

Aruna

Hi Kota,

Thanks for reaching out.

The recommended way to do this type of content access change would be to modify the report / dashboard settings in the UI as the current owner.

We also have the option to migrate content upon user deletion, see here -

https://community.yellowfinbi.com/topic/add-ability-to-deactivate-or-delete-a-user-but-have-the-system-move-content-to-another-user

If you'd like, I can create a request to include this option outside the delete function, e.g. perhaps a user option here -

Does this sound like a good way forward?

Queries against the Configuration database would be out-of-scope for support; that said Dashboard definitions reside in the reportgroup table, you may be able to associate these via reportgroup*, reportheader or reportinstance tables to adjust access. Hope this helps!

Thanks,

Eric

Hi Eric,

I tried that migrate content option; however, it did not work.

Hence checking at the queries.

In UI we are not able to access the data of that user as Informed that user has been deleted at the backend.

Regards,

Aruna

HI Kota,

Thanks for the reply. In this case I'd recommend restoring from backup prior to the user deletion, in order to delete the user from the front-end, and migrate the content in the supported fashion. You can also reach out to an account manager to schedule an engagement with our consulting partners for assistance in developing a custom query like this for your specific needs.

Thanks,

Eric

Hi Eric,

DB restoration I have already asked and customer doesn't have it.

Regards,

Aruna

Hi Kota,

Thanks for the reply. You may have luck with this tool - please keep in mind queries against the Configuration can cause irreparable damage and is not technically supported so please have working backups before attempting.

https://community.yellowfinbi.com/knowledge-base/article/a-stored-procedure-that-allow-an-administrator-to-view-all-private-reports

Let me know if you need anything additional here.

Thanks,

Eric

Hi Kota,

I'm going to go ahead and mark this question as Answered at this time. Feel welcome to reach out in the future.

Thanks,

Eric