Post reply

benifits of creating relations at DSV level

  • May 31, 2011 at 2:31 am

    #149110

    Hi,

    what are the benefits that we get if we create relationships at DSV file level itself instead of at Cube level.

    Thanks.

    Thank You

  • June 8, 2011 at 4:29 pm

    #1336000

    VRT (5/31/2011)

    Hi,

    what are the benefits that we get if we create relationships at DSV file level itself instead of at Cube level.

    Thanks.

    the only one I can think of is that it will help when running the cube (and dimension) wizard.

    But I've also found it pretty helpful to have them in the DSV to use as a reference...a lot of times I have to go back and make some changes to a cube I haven't touched or even looked at in the past 6 months...having the relationships in the DSV where I can also see the column names and explore the data all in one screen is nice.

    Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com

Viewing 2 posts - 1 through 1 (of 1 total)

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