I am in the process of designing a Booking, Billing and Backlog datamart. My backend is going to be SQL Server 2K. Data source is Baan ERP system. The transaction level I have to populate the datamart is at sales order line level. My problem is that the data model I have come up with is more...more >>

One of my tables contains the transaction dates. So based on this table I tried to create a Time dimension (using the first option - I think it's called single table or something in the Wizard of Analysis Manager).... I select everything else correctly and selected the Year, Quarter, Mont...more >>

I am creating the data model for an insurance related datawarehouse, I have 3 types of Claims that we want to report on health, dental and drug. Some of the data the user needs will be in all 3 but others will be in only one or two of the fact tables My question is should these 3 types of claims...more >>

I was running SQL 2000 Standard with the Analysis Services repository in a SQL database. I upgraded SQL to Enterprise. When a user tried to create a partitioned cube he got: user-defined partitions are available only if you install Analysis Services SQL Server 2000 Enterprise Edition ...more >>

Hi, Maybe a silly question since I am new to SW/OLAP/etc. etc. I was wondering that if I have a single table having all the things that can be used as 'measures' PLUS all the possible information about dimensions in the same table. Basically this would end up with a highly un-normalized...more >>

Hi, One of cubes when browsed through proclarity showed nothing. To debug the same, I browsed through analysis services and the values were "#ERR". There was no change to the structure of the cube. The cube processing log shows that the cube was refreshed successfully. I then ...more >>

I installed SQL Server and MS Analysis Svcs on my PC but I have a problem while trying to browse data. Can somebody tell me if I have did something wrong??? ...more >>

how to import data into sqlserver2000 from oracle 7.please give me a solution...more >>

Does anyone know the Total number of Columns or Column size on SQL 2000?...more >>

Hi, Definitely a silly question for the experts here :) What exactly is a Data Mart? Is it more like a fact table and the associated dimension tables or is it the same thing as a cube or??? I'll appreciate your guidance and if you can also recommend a couple of URLs from where I can UNDE...more >>

I am doing performance tuning on a data warehouse load process that executes a series of stored procedures to migrate data from one database to another. The processing is an elephant that takes 4 days, and I am currently focusing on indexing. I have a procedure within this load process that is...more >>

I am currently developing data warehouse design documentation for our company as our first step in creating a data warehouse. During the design I ran into an issue: Our users want to answer this question: "What are our Export sales? Now that is a tricky question and I'll explain why...Export s...more >>

Hello, Can some one tell me how i could automatically refresh the cube when the DW is updated, I know its possible through DTS, can someone refer me to a site which gives step by step details on how i could accompalish this? Regards Imran...more >>

Hi, I hope this is an appropriate group to ask a question about basic SQL SELECT performance. I'm creating a VIEW which draws together two tables; T_ONE and T_MANY. Basically, the VIEW creates a LEFT JOIN from T_ONE to T_MANY so that the Ad Hoc SQL submitted from the software is simply a SELE...more >>

Hi, I hope someone can clarify this to me. I have DW Database which is the for a OLAP Database I created in AS. I have created cube with the necessary fact tables and the dimensions. my question is whenever the Data in the DW is updated, do u need to manually refresh the cubes so th...more >>

Hi, In Microsoft Abalysis Manager one can browse the cube data by right clicking the cube and drag and drop columns to view data. Can the same be achieved with reporting services. Thanks in advance Bajirao...more >>

I have de normalised tables in the source for use in a star schema.However the grain of the facts that I may need are different from that in the source also the source database has got denormalised database which has data according to the three diferent companies where the data is generated.... ...more >>

How do you backup a SQL database so the logs are commited to the database file? Will a backup using Veritas Backup Exec do it for us or do I need to use SQL to backup the product? Thanks, Scott...more >>

My data warehouse is now 4 years old and the size is about 600 GB od data. We had only data insert no update in this duration. PKs are all clustered indexes and in chronological order. Some of tables are as large as 100 GB. I wanted to check if the PKs are in good figure and ran DBCC show...more >>

i asked a year ago, but didn't get any real answer. i would like links to an introduction to warehousing. It sounds like a useful and interesting idea - but it's like pulling teeth to get an explanation of what it is. This means, you can't use terms like "warehouse", "dimension", "cardina...more >>

Dear all, I’m a student whose doing extensive research on data warehousing and data mining. With me, is a full dataset of students’ record from a local university. Information’s which is in the dataset consists of students subjects, grades, personal information, library information, to hoste...more >>

Hi, I've a strange behavior on my server. The response time is good after a reboot of the computer, but, after a long work on it (half day or a day) The performance slow down, so I reboot the server to recover my performance. Why? How to diagnostic this problem? Thanks. Jerome. ...more >>

Hi! I want to write some MDX queries that pull the same data I'm retriving into an excel pivot table that is hitting my cube. Up front, I'm pretty sure this is not doable, but need to ask anyway. I want some way of hooking into the MSOLAP provider to see the MDX that's generated and sent to ana...more >>

hi ppl... i'm a final year student in information systems and a new comer in the field of data mining. i'm developing the application using VB 6.0 for the front end and i'm using SQL server 2000 : Analysis services for the back end. taking customer transactions, my aim is to predict customer buying...more >>

I keep getting an error when I try to set up a merge replication... Cannot insert duplicate key row in object 'TRDFIL' with unique index 'ITRDFIL0'. (Source: CMTSQL2 (Data source); Error number: 2601) I can't seem to figure out how to prevent this from happening, any ideas on what is not co...more >>

This very important online survey will give you the opportunity to provide feedback on the availability of SQL Server information and peer support in the SQL Server communities. This will help Microsoft and its community partners to better understand customer needs and how to improve your experienc...more >>

Hi all SQL gurus, I know I am with some real expert brains now! I am here seeking some help... I have a log table with one of its columns holding multiple values with a comma deilimiter. The data looks like LOG_TEXT --------------- MS WinNT5.0 (Professional),Check Point FW-1,73,Networ...more >>

I have 10 years in my time dimension but I only want to display 5 of those years in certain cube. How would I limit the number of years from a dimension? ...more >>

Can you please let me know which is the best site to get the Currency exchange rates from. Can DTS automatically download currency exchange rates from any of these sites into the data warehouse. Thanks Simon...more >>

I am an MS Access developer who is writing his first SQL Server app. In MsAccess we have the AutoNumber data type to give records a unique sequential value. There doesn't appear to be an equivalent type in SQL Server. I am adding records from a ASP.Net web page. What would be the conve...more >>

Hello ! I am currently evaluating ability of Reporting Services (RS) to work with output of MDX queries. RS looks very appealing when working with relational output. But working with multidimensional output is somewhat cumbersome. I haven't found any examples so f...more >>

I have created a few calculated members under one dimension (meaning the parent dimension is not Measures, but other dimensions). It can be showed in the Analysis Manager, but cannot be displayed in MS Excel PivotTable (MS Office 2k, xp, even 2003). Is there any solution to display the calculated me...more >>

Sorry for the wide posting, but i really need some help and I posted somethind a few hours ago and have heard nothing, so i thought that I would try reacing more developers... I am trying to get a date range from the first of whatever month is previous to the current one to exactly one year pr...more >>

I dont know the difference between OLAP and the datawarehouse newsgroups, and i really dont know how many ppl frequent both the groups together - but Im posting this topic here in hopes that it may start a discussion. I apologies for any inconvenience. Thks. =) ------------------------------...more >>

If you have two fact tables that share a dimension is it better to duplicate the dimension by adding a copy of it to the warehouse or should you share the single dimension between the fact tables? ...more >>

This is more of a design question. I am trying to create a fact table for time spans. For example an order might go through the following status of Created, In-Progress, Delivered. The time span between any 2 states could range from minutes to days to months. I want to be able to see the current sta...more >>

Hi Does anybody know of any official documents comparing 64-bit SQL Server performance against 32-bit on a similar hardware platform? Apologies for any cross posting that may have occurred only I need answer ASAP. Ideally I need OLAP & OLTP benchmarks. Regards. ...more >>

Hi all, Say I have a table w/ a IDENTITY field as PK. Is it possible to change the IDENTITY SEED of that filed programmatically thru SQL script or any other method? Thanks for any input. Calvin ...more >>

Hi, hope someone could help me out with these issues I have. (1)when u do an extraction from the source database table to the destination database table using DTS, does dts copy only the data that is not available in the destination table or does it Reload the entire sets of rows in ...more >>