This content has been marked as final.
Show 3 replies
-
1. Re: Create calculated field on top a Dimension table's column
Naveen B Jul 23, 2018 2:40 AM (in response to Ayan Chakraborty)Hi Ayan,
Which Join you are using- Kindly use full outer join so that you will get a cross product when you do the count you will be able to get 80
Kindly mark this answer as complete/helpful so that it will help others
-
2. Re: Create calculated field on top a Dimension table's column
Okechukwu OssaiJul 23, 2018 4:21 AM (in response to Ayan Chakraborty)
You are getting only 30 users possibly because you are doing an inner join. Another alternative will be do a left join, since your User table contains a complete list of valid users.
Add the User table first on the left most side of the data join and then left-join all other tables to it.
-
3. Re: Create calculated field on top a Dimension table's column
meenu choudhary Jul 23, 2018 7:18 AM (in response to Ayan Chakraborty)Hi Ayan,
Looks like you are using an inner join(or left join keeping fact table as left table).
If you want to have all the user go for left/right join keeping dimension table as left/right table.