I have a large partitioned cube that is showing some invalid demension
members. These exist due to Db integrity issues that have been
resolved. I expected reprocessing each partition would elminate the
invalid members but that wasn't the case. Can anyone tell me how I can
clean these up?

David

Just a sanity check - did you reprocess the dimension first?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

yes, a full process of a dimension is required to "remove" members from the
dimension.
incremental or update process of a dimension only add new members or change
existing one (like changing the label of a member)


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

These are not shared dimensions. So, does that mean doing a Full
Process of each Cube Partition should solve the problem?


Jeje wrote:

mm...

verify what is the result of the query REALLY executed by AS.
not what you expect, but take the SQL query, and run it in the query
analyzer to view the real result and verify if your unwanted members
appeared.

I'm not sure how local dimensions are processed, I never use this type of
dimension.
I greatly recommand to use shared dimension instead of locally defined.

have you try to do a full process of the cube? not 1 partition at a time but
the entire cube.


"JonesAtl" <david_jones (AT) teamji (DOT) com> wrote