Post reply

What exactly happens when we press add related tables button while creating DSV

  • June 16, 2014 at 5:22 am

    #396916

    Over here in SSAS we does not create something like primary key and foreign key on a table , but still when we shift a dimension table from left to right and click add related tables, its adds the fact tables .

    How does the SSAS engine comes to know that this certain fact tables are related with that particular dimension table.

    Thanks.

  • June 16, 2014 at 5:25 am

    #1721898

    Shadab Shah (6/16/2014)

    Over here in SSAS we does not create something like primary key and foreign key on a table , but still when we shift a dimension table from left to right and click add related tables, its adds the fact tables .

    How does the SSAS engine comes to know that this certain fact tables are related with that particular dimension table.

    Thanks.

    It can also match using column names. This is determined by the NameMatchingCriteria property.

    Adding or Removing Tables or Views in a Data Source View (Analysis Services)

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

  • June 16, 2014 at 5:31 am

    #1721900

    So in SSAS does it match by column names ? :ermm:

  • June 16, 2014 at 6:16 am

    #1721914

    Shadab Shah (6/16/2014)

    So in SSAS does it match by column names ? :ermm:

    Depends on what you have configured in NameMatchingCriteria.

    You can turn it off if you want.

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

  • June 16, 2014 at 10:19 pm

    #1722124

    Do you know a article or blog in which this things are mention , that which column name is search in the other table.

    And where can i find this NameMatchingCreteria option

    Thanks.

  • June 17, 2014 at 12:06 am

    #1722130

    Shadab Shah (6/16/2014)

    Do you know a article or blog in which this things are mention , that which column name is search in the other table.

    And where can i find this NameMatchingCreteria option

    Thanks.

    Did you try Google at all?

    Did you read the article I linked to?

    Did you even take a look at a data source view and its properties?

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

  • June 17, 2014 at 1:28 am

    #1722151

    Ok. Got it. Actually i happen ,not to see your link which you had posted.

    Thanks for your time Koen 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

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