Datasource view in SSAS

  • Hi I am new SSAS I would like to ask if my datasource view does not contain arrow that pertains to relationship, is that ok?

    If I create a cube and dimensions properly and define relationship in dimension usage, is that ok or will work ?

    Many thanks

    Jao

  • That should work, although I usually create my relationships in the data source view as well.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi Koen,

    Does it mean that pointing your Fact Table and dimensions in an arrow just help to visualize your work or cube?

    So thats why when I open some projects downloaded from the internet the link or arrow doesn't exist.

    Thanks in advance

    Jao

  • It helps with visualizing, but also when you create your cube the dimension usage tab will be populated for you.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Tested, got it Koen, I really appreciate your help.

    Ciao,

    Jao

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply