Hi,

I'm looking for a good solution to remove unused records in my dimensions.
My users dislike to see unused objects in cube's dimensions and other
prompts in reports.

But the delete command is very slow due to a ton of constraints (to insure
good data quality).

so, any idea? guide?
maybe I can change my database to 1 user only during the delete step?
does I have to change and setup some isolation hint in the delete command?

thanks.

Jerome.

Depending on your MS OLAP client tool(s), can't this be handled in the
OLAP application itself? For example, if the analysis or reporting tool
lets you use an MDX set expression for the select list of a dimension,
then NonEmptyCrossJoin(Dimension.Level.Members) will only return a set
of those members which have rows in the fact table.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!