Hi, I need your assistance with 2 questions: 1. I just got my new server and ready to setup as my warehouse (Data). It's has 2 logical drives: a. C: at 31GB b. D: at 260GB I installed SQL Server 2000 Analysis Server successfully. How can I move the data to be stored on the 260GB drive?...more >>

Is there any easy way to create a dictionary or lookup function based on Dimensions in a cube? We only have 4 cubes so far but the big one has some 50 dimensions and sometimes finding the attribute you want to report on is consuming. Would like to for example to search somewhere for where ...more >>

Hi everyone I've got another issue in my company's datawarehouse system. SQLAgent eventually loads CPU with 20 - 25% of activity. What can be the reason for this? Thanks Luis ...more >>

Hi, My problems with SQL Server 2000 SP4 multiplies. Long running queries are blocking each other (even themselves); i.e.: SPID:58 blocked by 58 locktype: PAGEIOLATCH_SH I've discovered a lot of I/O contention due to PAGEIOLATCH_SH lock type. I'm going to review the queries and database...more >>

Hi, I wonder how can I diagnose where is the bootleneck of my system. DTS are running very slow as there is CPU usage about 20% and Avg. disk queue about 100% all the time. Is this mean that disks are too slow ? Is there any possibility to do some memory tuning ? regards Peter ...more >>

In SQL 2000 Analysis Service, Is it possible to create a dynamic MTD, LMTD, YTD LYTD dimension in the cubes? As it is the most common information that the user is looking for, I would like to build a time dimension with MTD, LMTD, YTD and LYTD for the user to drag and drop. ...more >>

I used Excel 2003 to show the cubes in SQL 2000 analysis services. when I show the lowest level of the customer, then add the product dimension and Expand to the lowest level. the responsible time is very horrible. When I look at the CPU performance on the Server, the Server is not busy. les...more >>

Hi there, For ETL purposes, I'm wondering whether it would be better to: - grouping all my heterogenous source systems tables into a same Staging Database or - Using a dedicated Staging Database for each source system Thanks, Chris ...more >>

I want to retrieve Primary key value from my OLAP Cube. can you please tell me how can i do this in below query? SELECT NON EMPTY { [Measures].[Total Test Count] } ON COLUMNS, NON EMPTY { ([Dim Station].[Station Name].[Station Name].&[1ST CHOICE EMISSIONS & INSPECTIONS] * [Dim Test Cycle]...more >>

in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last ...more >>

Hello, I have an e-commerce database that has both OLTP and Reporting applications. OLTP applications mostly write and do very little reading, only few records at a time (POS type of client), but there is a lot of clients. Reporting applications read large amounts of data, all day long. 90% o...more >>

ERROR "Too many columns found in the current row; non-whitespace characters were found after the last defined column's data." SOLUTION Try changing the "Row delimiter" field from {CR}{LF} to {CR} within the "Select file format" dialog of DTS Import Data wizard (it's the 3rd dialog of the Wiz...more >>

Hi, I want to build Dynamic MDX query in SQL Server 2005. Is it possible? ex. I have one SQL Server Report parameter which contain following value: 1. Station 2. Free Test I have three Dimension Station, Free Test, Overall Result and one measure Total Test. If I select Station in re...more >>

I have implemented SQL Server 2005 Developer Version at Windows XP Home. I'm working on localhost. I want to do an assoziation analysis and creating data source and data source view is successful. But when the data mining wizard comes to the point where to choose the data mining algorithm, the...more >>

Is there any way to import a cube created in AS 2000 into SSAA 2005? If not a direct import is there any way to make that job easier? Any suggestions/pointer/comments would be helpful. I have a lot of AS 2000 cubes and I am really sick of that development environment!...more >>

What are fact tables? Y is it neccessary for Cubes.... ...more >>

I am investigating whether there might be some commerical package that might meet this kind of requirements. I need a reporting system that will allow users (e.g. programmers for the users) to write their own reports. However, I need to be able to limit access to particular records within the ...more >>

Hi What can I use instead of "Ignore" function, which I could find in AS 2000, in SQL AS 2005. Regards. Sebastian ...more >>

hai can we use our relation tables as our dimension tables.or is there any procedure to convert relational table to dimensional table. thank you ...more >>

Is there a way to have changes that were made directly to an analysis services 2005 database be reflected in a project without having to do all the changes agian directly to the appropriate project? ...more >>

Hello All, I was asked this question : " How will you go about optimizing Star Schemas ?". I understand data warehouses and understand what a Star Schema is. However, I was not sure how to address this question. Can someone point me in the right direction. Thanks, rgn ...more >>

Hello, My question is about database partition. I know how to define a filegroup, Partition Function, Partition scheme and do a partion on brand new table. But my question is how can I partition a existing table without droping it!! Thanks for help Hooman ...more >>