Cognos 8.4 Analyst Publish Error

Post Reply
Bladeless
Posts: 6
Joined: Wed Oct 19, 2011 8:14 am
OLAP Product: Cognos
Version: 8.4
Excel Version: all

Cognos 8.4 Analyst Publish Error

Post by Bladeless »

Hello,
i have a problem:
I changed DList(respectively and DCube) and trying to Publish that changes, but I get this error:

Could not create an items table for DList {Name};42S01 :[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'it_dimension_0' in the database.;;CREATE TABLE {Name}.it_dimension_0 ( itemid char(38) NOT NULL ,dimensionid char(38) NOT NULL ,itemname varchar(500) NULL ,displayname varchar(500) NULL disporder not NULL ,itemiid int NOT NULL PRIMARY KEY CLUSTERED( itemiid )ON [PRIMARY]) ON [PRIMARY]

Very similar to http://www-01.ibm.com/support/docview.w ... wg21347079
But this issue does not help (( I have version 8.4.

Please help!!!
Bladeless
Posts: 6
Joined: Wed Oct 19, 2011 8:14 am
OLAP Product: Cognos
Version: 8.4
Excel Version: all

Re: Cognos 8.4 Analyst Publish Error

Post by Bladeless »

Problem solve:
publish from CAC
Post Reply