BookmarkSubscribeRSS Feed
Filipvdr
Pyrite | Level 9

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

1 REPLY 1
Haikuo
Onyx | Level 15

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 810 views
  • 0 likes
  • 2 in conversation