Cube drill through

[Filipvdr]

Dear all,

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?

Regards,

Filip

[Haikuo]

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'.

Haikuo