Skip to Content

modelling approach for many to many factless fact table

Dec 05, 2017 at 05:14 AM


avatar image
Former Member


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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers