Skip to Content
avatar image
Former Member

modelling approach for many to many factless fact table

Hi,

I have 2 factless fact tables deviations and complaints.

and these 2 tables are related many to many on batch ID

I need to derive certain calculated measures on deviations dataset and consider complaints as its dimension for drill down capabilities.

If I use star Join I'm getting Over count scenario in my measures.

Traditionally we need to use bridge table to handle this scenario.but how can this be achieved inside HANA?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers