Does anybody know how to put dynamically a filter into incremental update of a cube, which aborts the update if data is redundant.
I assume that time dimension in the cube needs to be checked ex. if the monthly data already exists in the cube, and it needs to be compared with a month from the view which underlies cubes fact table. However I don't know enough about MDX or cubes in general to figure this out :-)
Is it possible to delete , lets say a particular month from time dimension and all updates from this month, from a cube?
Not sure what your schenario is.
Few suggestions:
One take a look at the whitepaper talking about Analysis Services processing http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_asprocarch.asp
Second to answer your question about deleting data from dimension. The answer is yes, but only in case if you are deleting only few memebers. If you only going do delelte one customer from the dimension it should be fine. But not deleting all days in a month in Time dimension. Analysis Server actually not going to delete intenal record for dimension member, it just going to mark it as deleted. So in time you'd have to fully reprocess your dimension.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment