If your fact table or dimension tables grow and you reprocess your cube, your aggregations will remain unchanged, unless you chose to amend them manually. However, if you add a...

I thought the question (How can I reset the dimension member counts automatically?) was about to follow.

Statement or question?

This should explain a couple of things.

http://www.sqldts.com/default.aspx?6,222,254,0,1

Howard.

similar post -

Hope this helps.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=117285&edit=failed

Heres an example of how to get excel data from a SQL task

INSERT INTO customer

SELECT F4 AS Cust

, F5 AS LVL

...

You may want to read the section called "Memory Settings" from the following link.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx#ETAA

I'm unsure of the precise nature of this but I do believe that 2005 will have a profiler for OLAP which should make it easier.

similar link with brief explanation of how we do it

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=141851#bm141944

I've enabled the /PAE switch and bumped up my threshold to 2.7Gig and as of yet (2 days) not had any memory problems.

Thanks for the help nice people.

I usually get this type of error when theres a problem with the source. I would suggest that whoever has rights to amend the package enable package logging. This will...

This could be a virtual memory issue. See -

http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.olap&tid=36533834-9e5d-457a-87da-801d5a592242&cat=&lang=&cr=&sloc=en-us&p=1

Have you used Perfmon object Analysis Server: Agg Cache – Evictions/Sec to see if the cleaner thread is evicting entries....

Apparently MSAS 2005 will be able to address 3 gig (32bit version) and the 64bit will still be able to access as much free memory as there is on the...

My personal favorite is (for all you Brits out there) –

Select convert(varchar(10),dateadd(month,1+datediff(month,0,getdate()),0)-1,103) AS [EOM]

Hi, Happy New Year

There are two very basic options. The first is to generate a DTS package that performs all the tasks you need, alternatively, you could split the tasks...