Architecting, installing and maintaining your SAS environment

Cube drill through

Reply
Regular Contributor
Posts: 237

Cube drill through

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

Respected Advisor
Posts: 3,156

Re: Cube drill through

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

Ask a Question
Discussion stats
  • 1 reply
  • 286 views
  • 0 likes
  • 2 in conversation