09-03-2014 07:41 AM
I got the following question.
I got a cube with a fact table, dimension A, dimension B.
I want a drill through column A1, column A2, column B3 for example. How do I establish this?
09-03-2014 10:35 AM
I am not a cube developer, but from my experience assisting my clients who build cubes, here to offer my 2 cents:
Since your cube is from star schema tables, the drill-through table needs to be the full join of the fact table and all of the dimension tables. I would choose to use 'view'.