SSAS 2005 aggregations usage-based optimisation / COGNOS 8

Question

SSAS 2005 aggregations usage-based optimisation / COGNOS 8

dave-dj

SSChampion

Points: 11297
More actions
November 6, 2007 at 9:39 am

#183795

Does anyone know if SSAS logs the queries submitted when accessing the cube via COGNOS 8.
Does COGNOS 8 have any facility for recording submitted queries that could be used in the SSAS aggregation usage-based optimization design?
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 1

By default, SSAS logs every 10th query, no matter from where they come. You can change the frecuency in QueryLogSampling parameter of the server.

dave-dj SSChampion Points: 11297 More actions · Answer 2

ok,

Thanks for your reply. 😀

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Dave Balsillie SSCertifiable Points: 5589 More actions · Answer 3

Actually, to be clear, you have to turn on logging. (It's off by default.)

Initially, I would suggest you log every query, then back it off once you've got a good handle on the characteritics of your application. Remember, everytime you change your cube design (i.e. add / drop characteristics) you invalidate the log for the cube and you're back to the begining.

Shcedule a regular job to clean up the log, depending on the frequency of your cube updates and the volume of entries going into the log.

dave-dj SSChampion Points: 11297 More actions · Answer 4

ok thanks.

Appreciate your comments.

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)