Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ram1975

    Urgent: Transaction Log Issue...

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

    Table size on Disk

    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'
  3. ram1975

    Last Record In A Table

    Just press CTRL + End to reach the last record.
  4. ram1975

    calculating avg

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

    Optimization Locks up database

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

    Matching cubes to databases - redefine cube over and over?

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

    Dimension based on 2 different 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.
  8. ram1975

    ADO & Recordset: Where is the recordset (or table) stored?

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

    ADO & Recordset: Where is the recordset (or table) stored?

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

    custom rollups in Analysis Server

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

    SQL Server 2000 Transaction Log Build up

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

    Getting Error When Viewing Dimension

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

    How to design Table for Cube?

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

    Problems Consolidating OLAP Databases

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

    URGENT: Access 2000 with Data Control Coding in VB 6 error

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

    SQL2000 Analysis Services cannot count

    It is very simple. The only reason for that is that there might be no records in the fact table. Please make sure that atleast one record in present in the Fact table. Even after this if you are getting, please let me know.
  17. ram1975

    I cannot browse the Sample Cubes or any Cubes

    One of the reasons for this is if the OLEDB driver is not installed you will get this. The same problem i solved by installing Office XP, with which the OLEDB Provider for OLAP will be installed.

Part and Inventory Search

Back
Top