# How to set up a workspace

**URL:** <https://community.fibery.io/t/how-to-set-up-a-workspace/6699>\
**Category:** News & Announcements\
**Created:** [September 23, 2024, 12:04pm UTC](https://community.fibery.io/t/how-to-set-up-a-workspace/6699 "2024-09-23T12:04:59Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 23, 2024, 12:04pm UTC](https://community.fibery.io/t/how-to-set-up-a-workspace/6699/1 "2024-09-23T12:04:59Z")

</div>

Since I often get asked about my suggestions for setting up databases, I made a video with some of my tips.  
Check it out, and let us know what you think.

[![](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b25c702e18c94424336eb2f9973691dbb1fddbf8.jpeg "How to set up your Fibery workspace?") ](https://www.youtube.com/watch?v=X5JfZk72ZfU)

Are there other topics that you feel like you might want tips on?

---

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [September 23, 2024, 5:58pm UTC](https://community.fibery.io/t/how-to-set-up-a-workspace/6699/2 "2024-09-23T17:58:00Z")

</div>

> [@Chr1sG](#):
>
> Check it out, and let us know what you think.

You are very, very good in explaining stuff in a simple, nice way.

I also like the way the video is edited.

And I really love all the new YouTube videos. I think it will help new users a lot so good job 🥳🥳

---

<div class="post-metadata">

**Author:** ![Tadhg\_MacCarthy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tadhg_maccarthy/32/7672_2.png) [@Tadhg\_MacCarthy](https://community.fibery.io/u/Tadhg_MacCarthy)\
**Post date:** [September 24, 2024, 1:16am UTC](https://community.fibery.io/t/how-to-set-up-a-workspace/6699/3 "2024-09-24T01:16:12Z")

</div>

Thanks Chris. Great intro. I’ve also looked at your other videos. I look forward to more.

I’d like to see instructions on reporting across multiple databases.

Thanks,  
Tadhg

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 24, 2024, 9:01am UTC](https://community.fibery.io/t/how-to-set-up-a-workspace/6699/4 "2024-09-24T09:01:21Z")

</div>

> [@Tadhg\_MacCarthy](#):
>
> I’d like to see instructions on reporting across multiple databases

Are you having any particular troubles with this?

---

<div class="post-metadata">

**Author:** ![Tadhg\_MacCarthy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tadhg_maccarthy/32/7672_2.png) [@Tadhg\_MacCarthy](https://community.fibery.io/u/Tadhg_MacCarthy)\
**Post date:** [September 24, 2024, 9:51am UTC](https://community.fibery.io/t/how-to-set-up-a-workspace/6699/5 "2024-09-24T09:51:41Z")

</div>

Hello Chris,

I am looking for an example where a report would use multiple databases as sources, say:  
 ![image.png](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/46a69060e2d7b6efc3b12ea9a4e65d40a5df7dea.png)

All my usage is just one database as a source and then having lookup fields if I need to get information from other databases.

I just don’t have an understanding of when multiple data sources would be used?

I hope that makes sense.

Cheers,  
Tadhg

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 24, 2024, 10:56am UTC](https://community.fibery.io/t/how-to-set-up-a-workspace/6699/6 "2024-09-24T10:56:52Z")

</div>

The way to look at reports is as follows:  
the databases you choose to report on will determine the data points that are shown in the report, but reports do not really ‘know’ anything about entity relations.

For example, if a single Invoice Run entity is linked to three Invoice Line entities, then the report will have 4 data points to be displayed.  
The Invoice Run entity (= data point) will have a field that lists (as text) the names of the linked Invoice Lines, and each Invoice Line entity (= data point) will have a field that shows (as text) the name of the Invoice Run.  
But there is effectively no connection between them other than that.

For most people, in most cases, reporting on a single database is the way to go (relying on lookup fields as needed).

---

<div class="post-metadata">

**Author:** ![Tadhg\_MacCarthy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tadhg_maccarthy/32/7672_2.png) [@Tadhg\_MacCarthy](https://community.fibery.io/u/Tadhg_MacCarthy)\
**Post date:** [September 24, 2024, 10:43pm UTC](https://community.fibery.io/t/how-to-set-up-a-workspace/6699/7 "2024-09-24T22:43:19Z")

</div>

Thanks Chris. Makes sense 👍
