Failed to build OLAP cubes - EPM 2007

[Juliana Giorni]

HI

What can be happing when I try to build olap cube and the sistem gives
me this error:

Failed to build OLAP cubes. Error: Analysis Services session failed
with the following error: Invalid column name "ParentID"

 

[Juliana Giorni]

HI

What can be happing when I try to build olap cube and the sistem gives
me this error:

Failed to build OLAP cubes. Error: Analysis Services session failed
with the following error: Invalid column name "ParentID"

NOTE!!!

Change the specific error... the error is: "Invalid Object name:
"OlapObjects"

 

[NZ Projects]

Has the cube ever worked ? If so what has changed ? Have you checked the
ULS logs for additional error information?

If not, then following the deployment instructions "exactly" see url below

http://technet2.microsoft.com/Offic...347b-4171-a9d3-2dc0529df39e1033.mspx?mfr=true

 

[Juliana Giorni]

Has the cube ever worked ? If so what has changed ? Have you checked the
ULS logs for additional error information?

If not, then following the deployment instructions "exactly" see url below

http://technet2.microsoft.com/Office/en-us/library/6c191657-347b-4171...

Hey...
No... the cube never worked.
I was building it for the 1st time and got this error.
No logs were gerated.
What it could be?

Regards.

Juliana

 

[Pawel]

Your reporting DB may be corrupt (OPS sometimes does that)...
There was a similar problem described in the thread on 4/12/2007 (2007
Corrupt reporting database).
Mike Mahoney advised then (quote):
'The way forward is to remove custom configuration elements from the cube and
rebuild a base cube. This "resets" the reporting database removing any
problem data. After which add back custom fields and rebuild the cube, and
the cube will build successfully.'

If you actually _did_ add some Enterprise Custom Fields to your cube setup,
then this might be a solution for you.
As far as I remember, this was exactly the way I solved a problem similar to
one you described myslef. Unfortunately it was over 6 months ago and I cannot
recall the details.

Cheers,

Pawel

 

[Claudio Hidetoshi]

Hi, Juliana.

When you configure the Analysis Service, you need to create the
"OlapObjects" table in the database (not EPM database).
Script:
CREATE TABLE [dbo].[OlapObjects](
[ID] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ParentID] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ObjectName] [nvarchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ClassType] [int] NOT NULL,
[ObjectDefinition] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastUpdated] [datetime] NULL,
[Changed] [bit] NULL,
[Version] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

After you create it you can build the cubes.

Cláudio Hidetoshi.
Rio de Janeiro.