Hi, Can anyone explain me how to work with the filter tab on Cube drill through options? I added an extra table and specified the joining clause in this tab. It works fine for the first time; but after saving the cube it gives invalid alias or alias cannot be located. I tried putting the sam...more >>

Hi, I will rewrite my question. I'm having trouble to show averages of a measure in a cube, where the normal aggregation function for a measure is SUM. I see no AVG aggregation function for measures (I see Min, Max, Count, Distinct Count and SUM). If I hide the measure (cost), and creat...more >>

Hi All; I have a table and it has one primary key i.e. BID , one Foriegn Key LOCID and one EntryDate column which has datetime datatype. It has so many other columns. We do most of the searches on LocID and EntryDate. This table contains data in millions. We already have index on LocID and...more >>

Was looking at the FoodMart 2000 Database in AS and the HR cube as an example and had these quesions 1) I was looking at MetaData on the right pane and see the following dimensions : Time, Store,Pay Type, Store Type, Position, Department, Employees Also see the following sourc...more >>

Does it also listen on 1433 like SQL Server ? ...more >>

1) How can I schedule a daily full backup of the AS Database ? I know in SQL server, therese a SQL Agent that i can run a job .. But on my AS Server, all I have is AS.. Also what the command to use ? Can one send me an example ? 2) I looked at the data folder and I see so many different files o...more >>

I am in the first step of creating a data warehouse and am in an argument with my co-worker on structure. I have two locations both using sqlserver 2000. Each location has a location id. (1 and 2). I want to warehouse certian data about each location. I want to store data for both locat...more >>

1) Can an AS database be created from multiple data sources .. i.e. can we create cubes with tables( dimensions) that may belong on different data sources ? 2) What kind of storage mode do I currently have ? How do I check ? I know there are a few types such as ROLAP,MOLAP,HOLAP. Is there a wa...more >>

Hi, I have to prepare a deployment plan for a data warehouse solution which include this: * 1 Data warehouse server (SQL Server 2000) for a 32 gb database / 4 processors * 1 OLAP Server (Analysis Services) / 2 processors My reports target the database himself, the olap cubes are here for...more >>

I am trying to manipulate data before it is inserted into a column. For instance I am reading in a MAC addreess which looks like '00DE0B16AA99' and when I do an insert into the column I want it to be '00:DE:0B:16:AA:99' In other words I am trying to insert the semicolons. I thought I was...more >>

I am evaluating the BI Accelerator samples Excel 2003 SP1, however I receive this warning "The Analytics Builder Workbook requires Excel XP, SP1 or greater" and then the Excel file closes. Is there a work around for this please?...more >>

Hi, What is correlation name and how can I use it? I get this error when trying to process the cube for the first time using DSO. An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in AutomatedCubeCreation.exe Additional information: Tables or functions ...more >>

All, I was looking for a database centric developer conference. Any suggestions please ? Thanks in advance. Bill ...more >>

In our company, we have DB2 (currently moving from Informix) on Unix and SQL Server on Windows are the two primary database engines. Now, when top management decided to select a server for upcoming data warehouse project, they selected DB2 because of more stability and again an understandi...more >>

Hi All; I have a web application which is being used at large scale and there are upto 10,000 entries per day. Currently, there is no Begin Tran/Commit Tran/Rollback Tran and b/c of that we found some data corruption. Now, I changed all the transactional Stored Procedure and used Transacti...more >>

I know a data warehouse stores historical data and the fact and dimension tables could be huge with billion rows and could be more than 100s of GB in size for just one table. Can someone share some design tips on whether they partition those fact tables based upon time and then maybe use some pa...more >>

Hi, With my OLTP on another server, OLAP cube design works up to the point of actually processing the cube, then it errors processing the dimension. If I move the OLTP database (SQL Server 2000) onto the machine running the OLAP it works fine. It seems to be a rights issue but the ODBC tests wo...more >>

I have recently created cubes using the company I work for data. I would like to switch form using Crystal Reports to using AS and Reporting Services. However I am not the greatest public speaker. Does anyone know where I can find a few good web pages that will help to convince my bosses th...more >>

I have a little problem with a mdx query using topcount. My query looks like: SELECT {SOMEMEASURES} ON COLUMNS, NON EMPTY(TOPCOUNT([Dim1].AllMembers, 50, ONEMEASURE)) ON ROWS FROM MyCube WHERE ([Dim2].&[SomeValue]) The problem is that the query does not return all rows I expect (mybe 1...more >>

I am in a situation where I have a table which has Primary Key which is actually IDENTITY Column as well. Now, I want to implement Partitioned View on it. I went thru your different article about it in SQL Server Magazine but I did not find how to handle this situation If I have an IDENTITY Co...more >>

Any experience with WhereScapeRed (Data warehouse lifecycle management software: design, build and manage data warehouses) with MS SQL Server 2000 + MS Analysis Services 2000 www.http://www.wherescape.com ? Regards, Marco www.gmsbv.nl...more >>

Hi, I am new to this OLAP stuff. I am trying to create a cube which has a count of sales per month per year. How do you make a datetime field a dimension of a cube? I seem to specify the dimension OK and get the Year Month heirarchy I want (simple star dimension and a MOLAP) but when I process...more >>

What's the best way to archive tables with binary data? Flat files/bcp/DTS may not work if need to import binary data(not a fixed length column) with quotes etc. What I am thinking is to export to another database and back it up/archive on a regular basis. That way it will be easy to restore w...more >>

In general what's best practice for page density of indexes in a DW db? I can understand having space in a OLTP environment where page splits can cause degradation in performance. However, is there really any need to not have a fill factor of 100% in a OLAP DW environment with GBs of addi...more >>

I'm new to OLAP, and just tried build OLAP & Data Warehousing using DTS. Now I'm arrive at the step where I must concern about performance. There some questions that I want to ask, there're: 1. Where should I store OLTP database and OLAP database, should they in separate database or even in ...more >>

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

Hi, I have a set of disks available on my server (but 1 controller only). I want to use it to improove queries performance... I want to know what is better to improove the performance: * moving all (non clustered) indexes on a separate file group on this set of disk * moving some tables ...more >>

Hi All, I'm trying to design a large DB and considering which direction to go. The planned login user accounts will be 10,000, and each user has 15 DB Tables. Each Table's structure similar to other users, but user's data records have no relation with each other. 1. Create 1 Database for a...more >>

Right now we tend to provide extracts to our data warehousing system once a day. Users seem to be presseing for near real time warehousing. It seems to be a lot of processing to happen on the production side to get this data during regular hours and hence the nightly extracts.. I am critical t...more >>

Hi, I have an old Datawarehouse server with 8 disks in these disks I have a Raid 5 setup for my datawarehouse based on 4 disks. I want to move these 4 drives to a new server (better processors). My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000 ent. edition. Can I...more >>

I get an error populating a dimension that says that there are over 64000 members. The dimension only has one level. Is that a limit, bug or am I doing something wrong? Thanks in advance, Philip ...more >>

I have a table with numerous text fields. When importing the data the transfer put in a space in all of the text fields instead of a NULL value. Now the table size is much larger than it should be. I have replaced the spaces with a NULL value, but the table size has not shrunk. Does anyone ...more >>

How big can a database be in a sql 2000 and in SQL 7.0?? Is it 6 gig the largest size!...more >>

Hi all My company is using Microsoft SQL Server 2000 on a Windows 2000 server, in its head office location. We have a second office, which is connected to head office via a 2Mb fixed link - users of the databases in that second office are connecting directly to the server in the head offic...more >>