Database, Backend Setup with multiple Entity Relationships

Unknown

Hi Board Community,

I need help on a specific backend, datawarehouse setup topic.

I have to create a report which shows the cost per publisher and its respective country.
My idea was to create an entity for publishers and one for country and map them via relationships, the cost would be added via a cube. In the end I want to be able to select a specific publisher or a specific country and view the costs.
Problem is that one publisher can operate in multiple countries.

For example:

In reality there are thousands of publishers which operate in multiple countries.
So I am not sure how to setup the database and backend of board as I don't have a 1-to-1 relationship between publishers and countries.

My goal is to get a dataview which looks similar to:

Publisher:

Country:

Any idea if this is possible or what would be the best way to get a solution that is close to my outcome?

Best

Mathias

------------------------------
Mathias Flintrop
Senior Financial Controller
Smaato Inc
Germany
------------------------------

Dietmar Jeschkeit

Hi @Mathias Flintrop,

if I understand you right it is quite easy. Only Thing is that the two entities are not in a relation and your cube then have 2 axes.
Independent entities can also be displayed grouped one below the other.

------------------------------
Dietmar Jeschkeit
Senior BI Consultant
Braincourt GmbH Gesellschaft für Managementberatung & Informationssysteme
Germany
------------------------------
-------------------------------------------

Unknown

Hi Dietmar, 

thanks for your quick help. 
I think I got you right, looks like I was overcomplicating the problem. 
So basically I create an entity for publishers and one for country. I don't add a relationship. 
Set up a cube which contains which stores data on both entities and have a database whch has a simiar structure like my first screenshot.
Correct? 

Best
Mathias

------------------------------
Mathias Flintrop
Senior Financial Controller
Smaato Inc
Germany
------------------------------
-------------------------------------------

Dietmar Jeschkeit

You are right. A database with an entity publisher and country. Then a cube with these two entities.

------------------------------
Dietmar Jeschkeit
Senior BI Consultant
Braincourt GmbH Gesellschaft für Managementberatung & Informationssysteme
Germany
------------------------------
-------------------------------------------