I have two tables invoice(fact table) and agents(dimension). Not all invoices have an agent. How do I use the agents table as an outer join? When I include agents as a dimension and look at all agents, I only get invoices that have an agent. I know I could create a view in SQL but I want to do this in the cube.
Thanks,
Bill
You can create an unknown member in your agent dimension table and connect all fact records without an agent key to that member. You will have to use TSQL to this.
SSAS2005 can help you with doing this without writing code. Have a look at inferred members in BOL!
Regards
Thomas Ivarsson
No comments:
Post a Comment