I have cube called client distinct cube.. that cube is been driven by table A and has the following columns
Client-id, Active ,mcd Elibigle and time_Id
and there another table called Eligibles which has the following columns
Client_id, Time_Id, Plan_Id, plan_Id can be 1 -5
I have a created a dimension called client insurance with table eligbles as the base table and i have added 2 more tables called ben-plans and insurance to get the names for it...
SO when i build this dimension i get the STate, and medicaid and its subsidiarys
the dimension and fact tables for this cube is matched by Client ID and when i process this cube and i get 260 distinct clients for med C but if i query those two table for the same time frame i should 620 distinct instead of 260.. I am not sure what i am
basically i want the dimension to be build by the following query
Select distinct a.client-id from tbl_a a, tbl_eligibles e where a.client-Id = e.client-Id and a.time-Id = 54121 and e.time-Id =54121 and e.plan_ID = 5
Any help will be appreciated.
View Complete Post