We are using MS SQL Server 2000 with its Analysis Services and Excel 2002 We have 3 facts tables (less than 100 rows each) 8 dimensions (from 10 to 1000 members) 3 regular cubes and 1 virtual cube (with 20 calculated members) The pivot table is produced from the virtual cube In Excel, when I p...more >>

Can any one Suggest some good books on Data Warehouse (Begner to Expert Level) Thanks Sai...more >>

A new Systems Architect is trying to tell me that a data warehouse typically contains thousands of fact tables and hundreds of thousands of dimensions. So you know, my business is in the retail sector. I specifically asked if he meant THOUSANDS of MEMBERS, not dimensions, and he's sticking to hi...more >>

Hi, I have started to learn Analysis Services. I did the tutorial step by step, but the last step "create the 'Sales' cube" doesn't work. I get the error message "Unable to create cube 'sales'" - Unspecified error. It doesn't even work with the manuelly in footmart creatd cube. What is wrong h...more >>

Hi We build Analysis Services cubes sitting on Sybase relational end. We have partitions on of our big cube. When I try to process any of the partitions(that are worth 10 days of data) after an hour or so I get an error "Timeout occurred." and the whole transaction rollsback. We ...more >>

What is the procedure for moving a database from one c:\ to D:\ on the same computer. I figure I have to use sql analyzer but once there what are the steps. Thanks...more >>

Hi all Is there a way to reconstruct a table which was deleted without restoring the whole data base? Database recovery model is simple. Sqlserver version is 2000 sp3. TIA Rea ...more >>

I have the following table. EXISTING TABLE: COL1 COL2 COL3 MESSAGE TOM CLERK VA TOM IS A GOOD CLERK. AGE:32, SINCE:12/12/2001, PLAN:4 ROBERT INTERN DC ROBERT IS A FRESH RECRUIT. AGE:21, SINCE:1/1/2003, PLAN:3 RICHARD STAFF VA RICHARD IS THE AD'S NEPHEW. AGE:30,...more >>

Our database is a SQL Server 2000 (sp3). We are populating the database from transactions on the web which run through an IPSEC tunnel. Over the course of several days our counter column on one of our tables has gaps in the numbering. The gaps stopped for a few days and then one day sta...more >>

Hi, While going through an article I came across the subject terms and wanted to ask the experts if these are "basically" the same thing as "BI" or are these totally different? I'll appreciate any pointers/help from anyone. -- Thanks....more >>

Hi all, I have a colume assigned to datetime format, where the value is say "06:31:31" rather than 20/05/2004 06:31:31. When I retrieve the value from the table, the result were 30/12/1899 06:31:31. Is there a way to change the format so that I only need to put the time variable into the field...more >>

Does anyone have some sample DSO code to change the Data Source of a cube? I am aware of the DSO/XML utility, but have been unsuccessful in using it--consumes all available memory on my PC (1Gig of RAM). Thanks, Nate Shedd ...more >>

I'm wondering in general about the main purpose of BI. More specifically, should BI be used only for internal business intelligence, e.g., trends and analysis for senior managment and marketing, or can it also be appropriately used for daily operational reports? We have daily/weekly/monthly rep...more >>

Hello I'm working in a Windows 2003 Server, SQL Server 2000 and Analysis Services 2000 I have created two models in Analysis Services (MOLAP) - MODEL 1 gets info directly from the relational FACT table: "FCT_SALES - MODEL 2 gets info from a view with: "SELECT * FROM FCT_SALES FCT_SALES has ...more >>

Hola a todos, tengo un problema bastante a menudo con este tema, y me gustaría AUTOMATIZARLO de alguna forma. sabría alguien decierme como podría hacerlo Gracias de antemano. ..- chema ...more >>

I have created a cube that uses "calculated members" for % calcs. The data has processed fine on the SLQSERVER 2000 Analysis server. Using Excel 2000 I tried to build a Pivot Table using the "calculated members" by connecting to the OLAP cube. Although the summarised fields appear ...more >>

Hi! I'm involved in building a medium sized ware house with MS SQLServer 2000=20 as the backend. I've been searching for some good tools for SQLServer to=20 help me with the demanding tasks of planning and building the database and = (preferrably the same tool) making the mappings and data t...more >>

I am trying to migrate timestamp fields in Teradata and DB2 to SQL server. The problem is that Teradata and DB2 store timestamps to an accuracy of 1 microsecond, while SQL Server stores it to the nearest 3.33 milliseconds (the datetime datatype). The original accuracy needs to be preserv...more >>

I can't find where it forward engineers, only that it will reverse engineer - but want to make sure before I close the book on it. How do folks that model using Visio publish their databases from the model? Do they just have to recreate the db manually, or use another case tool such as ERwin? It ...more >>

Hi, I am trying to set up an orders datamart, which would be fed from our ERP daily. Requirement is to know at any given time what are the bookings, what is the backlog and how much has been billed. I am trying to create a dimensional model. My structure is as follows. Table 1 Ord...more >>

Please see below a section in the BI Accelerator 1.2 documentation. This is not present in the v1.1 documentation. We would like to know why this restriction (we are forced to go to lowest level when 2 hierarchies are included in a cube) was imposed in version 1.2. o When a cube i...more >>

hi doesn anyone know what the maz size is for an SQL database (either standlone or installed on 2000 server)...more >>

Hello, Could you tell me where can I found some information about "Query optymalization in data warehouse"? I really need this info very urgent :( Or could you send me some info ? Thank you very much Bartosz CREDIT Morawiec ...more >>

What is the best approach in data modeling FACTS with different granularity? For instance, I have Volume measures (item count, item amount) at daily intervals, but Cost measures (Processing costs, service costs for those items) at monthly and quarterly intervals. How best to construct ...more >>

Hi please tell me where is the UI of the MS SQL Server Explaining the problem I am new to MS-SQL Server. I installed it from my MS-Office CD. Now I can see 'SQL Server Service Manager' icon, on my System tray, but it doesn't have a place to input commands. When I try to use sql data adapters in...more >>

My user sent me this error when trying to create a new dimension: "Failed to load control 'POMDimensionBrowser' from . Your version of may be outdated. Make sure you are using the version of the control that was provided with your application. This menu item is unavailable at this time...more >>

I used the sample data (FoodMart) to create cubes. I was successful creating the cubes but when I tried to browse the data, I get this error message 'Unspecified errors'. What should I do? Thank you Jenna...more >>

hello, ppl. i have problem when i use russian language to build AS database. (all cubes, dimensions, members are named in russian). the previous db in english was working fine. i used roles to restrict access to 'Products' dimension. (each manager has access only to his product group). whe...more >>

Is there any managed website which maintains the list of cities across the globe and their time zones in it. Thanks,...more >>

What are some good ways to get development cubes into production? I currently use a developer's edition of SQL Server 2000 with Analysis Services. In the past couple of years I have been responsible for running reports. The plan now is to let users run reports for themselves by connecting...more >>

What are the factors to consider on whether to use surrogate foreign/primary keys in fact/dim tables? Is it a requirement to use surrogate keys in a data warehouse environment? It does complicate things more in the ETL process and maintenance wise by using surrogate keys, agree or disagr...more >>

Hell Creating a report in reporting services in the .net ide and the line thicknesses all defined as 1pt appear different thicknesses. Why is this how can I make them all appear the same thickness?...more >>

I have a requirement to publish dashboards for SQL Server like gauges, sliders, graphs, etc to a digital dashboard. Please advise which is the best way to publish dashboards on SQL Server. Also please point me to some resources on some sample dashboards to SQL Server. If it is Sharepoint ca...more >>

Hello, I was wondering what kind of performance increase can I expect if i change to a 64 bit system running sql server? What kind of problems can i run into changing to sql 64 bit or only advantages... Are there benchmark tables available on the internet? thanks, Tune-a ...more >>