Recent content by ram1975

If the harddisk is full and you are unable to take the logbackup, right click on the database, select properties, select options tab and change the Recovery model to "Simple" and say ok. Again right click on the databased and select shrinkdatabase. I hope this should solve your problem.

System stored procedure 'sp_spaceused' will give the amount of disk space occupied by a table. In the query analyzer type the following exec sp_spaceused 'table name'

Just press CTRL + End to reach the last record.

Best way to get average in analysis services is to add a measure with sum as aggregate formula. Add same measure again with count as aggeregate formula. Then use a calculated measure with sum/count to get the average.

Can u be a bit more specific what type of optimization you are trying to do? i.e. the DBCC commands u are using ?

If the both the fact tables structure in both the databases is same and if you want to use that in the same cube, you can create a partition in the cube. i.e. different partitions can refer to different fact tables.

Yes u can do that using Parent child dimension. Use the wizard and select the third option, which will guide you in doing so. I hope you are referring to analysis services 2000 only.

please check your code i think what you have given is wrong i.e. the following code will run smoothly. rs.close set rs = nothing However, the other way around it will give the error what u said set rs = nothing rs.close THen that error will generate in the statement rs.close.

Please use any one of them i.e. either rs.close or set rs = nothing. Using any one of them would solve your problem. If you don't want to open it again, better to use set rs = nothing

If i understood your probelm i think you want to find an average of a particular measure instead of sum. There is a work around for this. For example you want to find the average of Sales Measure. DO the following 1. Add Sales measure by name "Sales_Sum" with Aggerage function...

Do the following which will defenitely solve your problem. 1. Right click on the database and select properties. 2. In the options tab set the Recovery model of the database to "Simple". This will allow your database log to shrink automatically. Also make sure auto shrink is on also.

One of the reasons could be if you would have uninstalled a program, which removes the oledb olap provider, you cannot view either cubes or dimensions. Try doing this, which will install the provider 1. Either remove the analysis services and reinstall 2. Or install office xp, which will install...

Good question. Whether to denormalize or normalize depends on the amount of data you have. Say for example in the master table if you around 5000 to 10000 rows, you can denormalize that table. Because as compared to the fact table records i.e. say for example 10 million rows, these are very less...

If i understood your problem correctly, it is related to partitions. As you are saying u already have three different databases. In the first phase database, create two more partitions and change the fact table location accordingly. I hope this should solve your problem.

Please check whether you have adodc1.refresh after setting the record source.