64-bit querylog setting: AS2K error -
06-15-2006
, 07:39 PM
Hi
I have been trying to find a solution to a 'little' problem. I have a 64-bit
install of AS2000 Sp4. The querylogging seems to be successfully captured in
the machine's SQL server OLAPQuerylog database (and querylog table). But, for
some reason, the optimization wizard in Analysis Manager does not work. It
shows no queries logged.
I thought it may be the querylog connection strings in the registry. But
they look fine (and they must be since entries are being made). Its just
running the 32-bit AM against a 64-bit OLAP instance that does not seem to
work. I have 2 separate 64-bit servers, both have the same issue.
I can see the cubes, edit them, run aggregations - do everything - except
for running the usage based optimization wizard. I really need to use it.
Can anyone help!!!
thx
Avi |