Jump to content
Sign in to follow this  

Recommended Posts

Dear friends

we are about to create the first reports with Tableau. We have to link the required tables. Is there a DB schema where we should see how the tables are correctly linked together? We found out a lot, but a few things are unclear to us. For example how a project is related to a program.

 

Thank you

Thomas

 

  • Thumb Up 1

Share this post


Link to post
Share on other sites

Hello @Thomas Mundschin,

 

Thanks for bringing this up.

A documentation of the Reporting Database can be found at:

https://help.meisterplan.com/hc/en-us/articles/115004373214-Tables-and-Views-of-the-Reporting-Database

It includes an entity relationship diagram that illustrates how the tables are linked to each other.

I hope this will help you with your reports. If you have any further or more specific questions, don't hesitate to contact us directly or on the Quest.

 

Kind regards,
Fabian

  • Thumb Up 1

Share this post


Link to post
Share on other sites

Thank you. We're two steps further. We are looking for the fields "Rang" and "Projektwert". Are they visible somewhere or do we have to recalculate them?

 

Share this post


Link to post
Share on other sites

Hello @Thomas Mundschin,

It's good to hear that.

The rank of a project in a specific scenario can be found in the field "priority" of the view "reporting.scenarioprojects". Since the project value is not directly accessible in the Reporting Database, it will be necessary to recalculate it.

I hope this answers your question. If you need any assistance with this, don't hesitate to contact us!

Kind regards,

Fabian

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...