Hi,
if you put a virtual dimension into a nonemptycrossjoin statement,
you will get the funny error message:
"Data source provider error. Invalid object name 'dbo.DIM_SALES'.;42S02"

This was really hard to track down to this reason of the error.

Hope this helps.
Frank

"Frank Samuel" <FSamuel_nospam (AT) misag (DOT) com> wrote

Hi Frank, looks like you have problem in ROLAP partition. What happens if
you simply do SELECT virt_dim.members on 0 ?


--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Hi Mosha,
thanks for this guess, it is because of the write back partition.
If I deactivate write back, the query works fine, if I activate it (without
any value in the table), the query fails.
Seems to be a problem with nonemptycrossjoin and virtual dimensions, if
writeback is enabled.

Bye
Frank

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote