Hi,

I'm struggling with this error:

Errors in the high-level relational engine. The 'DimTime' table is based on
a named query, and contains one or more computed columns. A table based on a
named query cannot contain computed columns. If the computed columns are
necessary, add them to the query expression

Any clues?

Chris Harrington
Active Interface, Inc.

In article <u#kUIkdzGHA.3464 (AT) TK2MSFTNGP03 (DOT) phx.gbl>, "ChrisHarrington"
<charrington-at-activeinterface.com> says...
up.

If your DimTime is a named query it's element will have a
msprop:QueryDefinition property with a "SELECT..." statement in it. If
you have any column expressions (eg. 'Q' + CONVERT
(varchar,dbo.DimTime.QuarterNumber) as QuarterName) they need to be
inline in the QueryDefinition property.

If your DimTime was based on a physical table in the datasource you
could embed SQL fragments in the msprop:ComputedColumnExpression
property for a given column.

It sounds like your DimTime element in the DSV might be set up as a
named query (ie. have an msprop:QueryDefinition property) as well as
having a column with an msprop:ComputedColumnExpression property

If this is correct your best bet is probably have extract the SQL
fragments from the column definition(s) and embed them in the
msprop:QueryDefinition property.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

Darren,

Thanks for explaining that. I will investigate that possibility.

Chris

"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote