Usage Analysis

[smither]

Hi,

I was wondering if anyone knows where the usage information is stored in Analysis Services? I want to bypass the Wizard and report the data through other means.

In addition, is there more usage information that I can log and extract from Analysis Services.

Thanks

 

[MDXer]

I believe it is in a log file in the cubes Directory.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[smither]

I did a search for a "Cube" directory but didn't find anything related. I also did a search for all log files on the server and I didn't find anything that seem to be storing the information. I'm able to get the usage information from the Usage Wizard so I'm sure its stored somewhere. Question is...where??

Thanks

 

[MDXer]

the cube directory isn't named cube each DB in MSSAS gets it's own directory and within that each Cube has a directory. typically like c:\programfiles\Microsoft Analysis Services\xxxx\xxx\xxxx. The usage log will only contain data for every X number of times used with X being what you have the logging value set to in the server properties, I believe this defaults to 10. So if you haven't changed this value you usage data isn't accurate for reporting but is for optimizations.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[smither]

I found an access database called MSMDQLOG.MDB in this folder on the Analysis Server machine:
C:\Program Files\Microsoft Analysis Services\Bin

It appears to have some log information but I'm not sure if this is where the Usage Wizard is getting its info from. Is this the right file??

Thanks.

 

[MDXer]

not really sure. Never really worried about the usage logs outside of the wizards.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck