Problem:

I want to check the usage of the cubes in my datawarehouse. The
datawarehouse runs at SQL Server 2000. What I noticed is that after the
cubes
are processed the data that was stored with regard to the usage of the cubes
is cleared. Since I update the datawarehouse each day and consequently
processes the cubes as well, I get only the log of the active users (with
the "usage analysis wizard") of today.

Does any one know how to prevent this? Is there somewhere an option that can
be set that prevents that the data is cleared?

I already checked the help files etc. but didn't find a satisfying answer.

Regards,

Damien

Hey, am I alone answering doubts today. Wake up folks!

AS clears the log each time you do a Full process. I don't know why. You
have to make a DTS that saves the data to a temporary table before
processing, and then copies them back again. You should migrate the log from
Access to SQL server, but this requires some registry modifications (Anyone
has the msdn article?) . The table is called Querylog
Tore

"Damien" <dams_@[antispam]caramail.com> escreveu na mensagem
news:%23RcRktTsEHA.2196 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

A full process can mean that the structure of the cube has changed, and that
the existing usage statistics don't make any sense with regards to the new
cube structure. I guess there could have been a check to see if the new cube
structure is compatible with the old (or hasn't changed), but that's just
not there.

--
Jacco Schalkwijk
SQL Server MVP


"Tore Johnsen" <naturamo (AT) hotmail (DOT) com> wrote

Migrate your querylog table to sql server and then create querylog_history
table. Populate querylog_history table with insert trigger. You can read
more on
http://www.sqlservercentral.com/colu...isservices.asp

Ramunas Balukonis


"Damien" <dams_@[antispam]caramail.com> wrote

Hi All,

Thanks for all

Damien
"Damien" <dams_@[antispam]caramail.com> a écrit dans le message de
news:%23RcRktTsEHA.2196 (AT) TK2MSFTNGP14 (DOT) phx.gbl...