I am using AS 2005

I Created a cube.
Then changed column name in fact table, one of my measure

Opened my AS project
Refreshed my Data Source View. It prompt me to delete old column and add new
one.
When I got cube design window see new column name

But when I process cube I am getting error "Error in the high-level
relational engine. The data source view does not contain a definition for
<old name> column in the dbo_xxxxxxxxx table or view.

Next error line says An error occurred while processing the <partition name>
partition.

I did recreated partition by delete and creating new in partition tab.

I am still getting the same error. Thanks for helping me what I am doing
wrong.

-Ashok

Did you check all measures using the old column?

How about searching the old name over Current Project in Code mode?

Ohjoo


"Ashok" <Ashok (AT) discussions (DOT) microsoft.com> wrote

That worked. I went to Code mode and changed old name with new name. Then I
can process cube.

Thanks - Ashok

"Ohjoo Kwon" wrote:

However I was expecting Cube designer should refresh this type of changes.

Second case. I have a calculated measure using existing measures say
measure1 + measure2
If I rename measure1 cube designer should update my calculated measure. It
doesn't do that now, I have to go to code view
and change formula.

What you guys think?

-Ashok

"Ohjoo Kwon" wrote: