Correlation Names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pushpendu Sharma - 21 Mar 2005 19:34 GMT

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

Signature

Thanks,
Pushpendu

Reply to this Message

Adam Machanic - 21 Mar 2005 19:37 GMT

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...

Signature

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

> Hi,
>
[quoted text clipped - 7 lines]
> 'ScanGeographyProductTime' have the same exposed names. Use correlation
> names to distinguish them.;42000

Reply to this Message