I'm having an interesting problem with a SQL 2000 SP3 Analysis Services
server, running on Windows 2000. I have a Cube that has 13 dimensions. If I
edit the cube and choose Tools/Validate Cube Structure, I get a popup:

"There is a loop in the schema. Please remove the extra joins."

I tried to optimize the Schema (using Tools/Optimize Schema), but once it
optimizes the Schema, the error is still here, if I choose Tools/Validate
Cube Structure.

I have tried a visual check of the Schema, but am not sure what I am looking
for - perhaps a join that joins a table to itself?

Help.

Thanks.

Doug F.

a loop appeared if a dimension table is linked to 2 other tables.

for example:
Country --> Customer --> Sales Fact table
--> Stores -->

AS will create a link between country and store because AS detect a common
name like "CountryID"
its not a link that you have created, but an automatically created link by
the cube edition tool.

I have this issue in a cube, ewvery time I open it, AS addd a link between 2
tables and I don't want it.

just look at the links between the tables to find which one is the bad link

"Doug F." <DougF (AT) discussions (DOT) microsoft.com> wrote

If you find you actually NEED the loop in your schema you can "trick" AS
by creating a view on one of the tables and use that.

To expand on the previous example:

Country --> Customer --> Sales Fact table
vwCountry --> Stores -->

Where vwCountry is simply a "SELECT * FROM Country", not pretty, but it
works. AS'05 will allow more flexibility in this area.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <O1db6vXuFHA.3756 (AT) tk2msftngp13 (DOT) phx.gbl>,
willgart_A_ (AT) hotmail_A_ (DOT) com says...