I have one server where is installed SQL Server 2000 and Analysis Services 2000. I´m creating a cube with 50 dimensions and 30 measures. The workload of this server is heavy. There are a lot of batchs that import data to a OLTP database. When these processes were happening I try to procees the...more >>

I am trying to create a ratio in Analysis Services 2000. This ratio is called "GMROI" (Gross Margin Return on Inventory). The ratio in being developed in the virtual cube called "Sales and Inventory". The ratio consists of a numerator with a full year of gross profit and a denominator w...more >>

As I have mentioned before I am still trying to increase the performance for a fact table load. This solution could be my best bet. The database recovery will be set to either Full or Simple. I do not need the operation logged and I have another tool that will log errors. Could I set the...more >>

I need to increase performance on a fact table insert. There is one Primary Key identity column defined on the fact table with a clustered index defined by default. Can I drop the constraint and the index on this column or maybe just the clustered index to increase performance for inserted...more >>

I want to increase performance on a fact table load. The table has only a pk defined on an identity column. Since it would help performance to drop all indexes and then load a fact table. Is there anyway I can drop the clustered index that is automatically created on the identity column and ...more >>

Hi, I am moving the access to SQL server 2000. I just wonder if it has the function like Link table to link up other instance?? thanks ---------------------------- Ginola...more >>

I have been trying to get a results from a third Party accounts system. From all the help given i the past i have managed to get this far. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tmpnomdat]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Tmp...more >>

Hi, What the best way to start in datawarehouse? Which books should I read? Web Sites? Etc. Thanks a lot. Denis ...more >>

Hello, This is an opinion question i guess : i am about to write a multitable lookup that looks at 7 differant tables basically to think about writing a timetable lookup. There are 2 tables of 1 to 1 and 5 of 1 to many. The results will be called via asp.net web site; and the number of...more >>

Hi, I tried to run a view SELECT TOP 100 PERCENT * FROM dbo.[LIMITS] WHERE (DATEDIFF(D, [NEW BUSINESS DATE], '31/07/2003') > 0) which returned an error said "The conversion of a char data type to a datetime data type resulted in an out-of- range datetime value." It seems SQL serv...more >>

Hi, We are populating staging tables using DTS . We are indexing our staging tables after loading. Our question is whether do we have to index our source tables before loading ? How it will effect the performance ? Thanks ...more >>

I'm going through the Analysis Services Tutorial. The first section under Advanced Analysis has you use the Dimension Wizard to create Parent-Child dimension with writeback capability. When I get to the "Select advanced options" step in the wizard, there is no writeback option. The tutorial ...more >>

Hi: When a full process of an OLAP cube is perform, does it also automatically perform a restructure/"full process" of the related dimensions? Or does the restructure/"full process" of the related dimensions need to be handled separately? Thanks! .. ...more >>

Performance-management.it is a public resource, born on june 2003, dedicated to business performance management, business intelligence,data warehouse and OLAP stuff. I'm italian and my contributions are written in italian language, but english or other languages contributions are welcome. Of ...more >>

Can I have a cube using a fact table and specific dimensions from a database (data source) and general dimensions which are in another database ? i.e. Cube Sales: Fact Table (Sales), Dimension Table (Color) from database (ProductA) and Dimension Table (Gender) from database (Dbgener...more >>

Hi, How do you calculate storage space for about 4 millions records in a data warehouse Regards Dally...more >>

Do I made the things more commplicated? I found that to populate the fact table is very difficult, even with dimemtion more than 4. Say if you have 4 dimensions S,W,Y,Z. For each measure, you need to identify a record (s,w,y,z) prove to be humongious task, particularly when you business data are...more >>

Hello Guys, We have often a timeout message when we try to connect to the OLAP server using Analysis Manager. After the message "Connecting to the Analysis Server..." (which takes about 1 mn), we have "Cannot open connection to Analysis server 'xxx'. Timeout occurred." Then we have to...more >>

HI All I have a db with 5 year data. I want to save space by burning the first 3 years data on CD and leave the last 2 years data on db (production). Can I create a removable db using CD to keep the first 3 year data so at any time anyone want to access this data they can do it on CD? Does ...more >>

Trying to understand this new technique of data warehousing, the BOL mentions quite a few times that data/table structure in the OLAP warehouse will be much different from the OLTP live system. They give an example table in the warehouse: FoodMart 2000 sample database, fact table sales_fact_...more >>

Hi, I am very new in SQL server, When I do import from MS Access to Sql server 2000, it doesn't import the link table. Can I do any function similar to link table in SQL server ?? My Ginola...more >>

this relation is working fine in Aceess but not in SQL table relation. the error message shown as follow: ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_EQUIPS_Store List'. The conflict occurred in databas...more >>

Hi there, Can some please direct me to the new MS SQL Server Reporting Features? Thanks ...more >>

OK...I need someone's opinion on this: My database1 is growing so big (70 GB) that the time frame it takes for nightly dbase backup to disk and tape backup will eventually run over my daily morning ETL. Currently, the database1 structure consists of daily fact tables, monthly fact tables...more >>

Hello, I'm not sure if this is the best place to post my query, hope someone might have some ideas. I have a simple database of customer details of which I would like to include a jpeg per customer, how might I go about doing this? Do I just put a string reference to it's disk location? To...more >>

I need help. I'm working with SQL Server Analysis Services 2000 and I have a really big problem with a virtual cube. I processed the cubes and then I archived the database without problems, but when I restore It, the virtual cube is not processed. Could someone help me with this issue??...more >>

SQL 2K I am creating a table for holding data used for data wear-housing project. This table will eventually going to have millions of records. Planned to have a primary key and proper indexing in this table. This table will be queried against various columns and will be refreshed (fill data)...more >>

I have been going over the requirements for SQL Server Accelerator for BI and mostly everything makes sense except the requirement for Windows 2000 Advanced Server or greater for the relational server (Staging, Subject Matter Database, BisoCatalog) in a production environment. The requirements ...more >>

I have a virtual cube which has 4 physical cubes. The virtual cube has 103 dimensions. while processing it throws me an error that the cube has exceeded the maximum no of levels in a cube. I guess the max limit is 256. Is there any way of overcoming it? Its urgent and can somebody help...more >>

This is addressed to the well-experienced dimensional model gurus... I am currently loading a dimensional model of more than 100MM rows of data each week. The source data is being put in a database within the database server. I am using TSQL to populate the FACT table and then run the aggreg...more >>

I want to make summerize of one collumn from a fact table of a cube. How can I do it ? ...more >>