+ Reply to Thread
Results 1 to 2 of 2

Correlation Names

  1. Correlation Names

    Hi,

    What is correlation name and how can I use it? I get this error when trying
    to process the cube for the first time using DSO.

    An unhandled exception of type 'System.Runtime.InteropServices.COMException'
    occurred in AutomatedCubeCreation.exe

    Additional information: Tables or functions 'ScanGeographyProductTime' and
    'ScanGeographyProductTime' have the same exposed names. Use correlation
    names to distinguish them.;42000

    --
    Thanks,
    Pushpendu



  2. Re: Correlation Names

    I'm not sure how you change them in what you're doing, but a correlation
    name in a SQL Query is a synonym for a table or column's actual name. For
    instance:


    SELECT SomeOtherTable.SomeColumn AS SomeOtherName
    FROM SomeTable AS SomeOtherTable


    In this query, SomeTable will be treated as "SomeOtherTable", and SomeColumn
    will be returned as "SomeOtherName".


    Apparently, you have two columns coming back with the same name. Change one
    of them...


    --
    Adam Machanic
    SQL Server MVP
    http://www.datamanipulation.net
    --


    "Pushpendu Sharma" wrote in message
    news:OilnEQkLFHA.1360@TK2MSFTNGP10.phx.gbl...
    > Hi,
    >
    > What is correlation name and how can I use it? I get this error when

    trying
    > to process the cube for the first time using DSO.
    >
    > An unhandled exception of type

    'System.Runtime.InteropServices.COMException'
    > occurred in AutomatedCubeCreation.exe
    >
    > Additional information: Tables or functions 'ScanGeographyProductTime' and
    > 'ScanGeographyProductTime' have the same exposed names. Use correlation
    > names to distinguish them.;42000
    >
    > --
    > Thanks,
    > Pushpendu
    >
    >




+ Reply to Thread