Search results for query: *

Thanks for the reply...I've looked at the data selection more carefully and have realized that the OR statements were causing some problems. I've reorganized the criterias in the data selection and the report is working fine now. Thanks again.

Not sure if anyone has come accross this problem or not but this is the first time I've had this problem. I've written a pretty lengthy SQL Command but after the designer retrieves the data it is not apply the filter in the data selection. This is the data selection: {Command.GBOBJ}="9300" or...

Hi, I was wondering if there was a way to script something through a batch file that would open the latest instance of a report that has been scheduled. I know it possible to execute a report but was wondering if there was a easy way to open the completed instance and display it. We are...

I was wondering if anyone has worked with ragged hierarchies before. If so, I was wondering how you were able to report from it. In general I have a hierarchy that looks like this. 1000 (lvl 3) 1100 (lvl 4) 1110 (lvl 5) 1120 (lvl 5) 1200 (lvl 4) 1210 (lvl 5) 1215 (lvl 6)...

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.

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...

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