SQL server 2005 Analysis services Cube

I have a datawarehouse with some dimensions that I need to keep updated with
no or very little delay.
Rolap will not work, it gives me an SQL error. It might be due to the fact
that my Key is a Uniqueidentifier.
Molap with SQL server update notification is just to slow, my application is
to fast, so the change is not visible untill a reload.

Anybody that can help me?

Thanks in advance,
Jimmi

Jimmi,
What is the source data repository?

Hi Brad,
We use SQL server 2005 as repository.

/Jimmi


"Brad" <Brad.Marshall (AT) Teksouth (DOT) com> wrote

Would you be interested in looking at another architecture? We have
done large data warehousing implementations for the last 8 years and
have developed a product that fits between a BI tool and the data
warehouse that offers significant performance boosts. It only does sql
and not mdx, but is really good in ad hoc environments. If interested,
check out www.entellicache.com

Brad

Jimmi,
I am assuming your base star schema is being updated without any
problems, but updating your cube is where the issues begin? Also, is
there any architectural reason why you are using a Uniqueidentifier as
a key in your dimensions? Have you tried querying the star schema
directly and bypass the cubing process?
Thanks,
Brad


Jimmi Bram wrote: