Data model creation

[shiveshsingh]

I am having 2 fact tables, and each fact table has 40-40 dimensions each.

Both the fact table are not associated to each other in any way.

How can we create a data model for this?

[techvarun]

You need to concatenate both the tables or need to create a Link table

[techvarun]

Follow the links in the below thread.

Data Modelling With Multiple Fact Tables

[tresesco]

If they are not associated in any way, leave them as they are and that would create two data islands for you. At the front-end, you could create dashboard possibly for two disjoint data set as if creating two dashboards in one place. In another way, you could concatenate the tables creating flag (mentioning the table name may be) and use that in set analysis in front-end expressions.

[effinty2112]

Hi Shivesh,

If your two fact tables have no associations do they really belong together in one document?

cheers

Andrew

[mayuresh_d]

If both of them don't have any relation with each other then u have to create two data model with respect to both the fact tables. and keep it in one document ...so that you can use both the data represent in single table.. and you can use field triggers if you want that your selection make affects on both model.

else

just keep them separate and create two documents.

[ramasaisaksoft]

To create a Data model,

Case 1 :

when ever you have more than 1 Fact table choose "Snow flake Date Model" here Dimension tables will join Fact tables so you will get Association between them(Even though that Dim table is not useful just take a small Dim table between both of the Fact tables).

Case 2:-

Create one extra field as a Flag field in both of the tables so that association will come.

Case 3:

Depends on the data Use alias names to the fields.