1. I got the price and the qty in the data source. when I create the calculated member Amount = Qty * price, I found out the total is equal to the total qty * total price. How can I define the calculated member Amount = summation of (qty * price). 2. secondly, I would like to count ho...more >>

Hi, I have a problem. My problem is : I have two tables reprezentoing a tree, first table representing nades, and second representing links first - ID, Name second- ID1, ID2,weight --------------------- ---------------------- | 1 | name 1 | | 2 | 1 | ...more >>

hi all, i am looking for a good program to query sql server olap data. i tried ms excel but i was looking for something better. i've seen proclarity,it is good but the new version cost too much for my customer. i've seen cubularity knowledge prospector but do not like it , seems too poor. i...more >>

How to implement M-to-M dimensions in SQL2000 Analysis Services?...more >>

Is there a way to monitor schedule jobs and restart the jobs automatically when it faills and if it fails then notify the responsible person, is there a tool to do this ? ...more >>

Hi, Apologies if this is not the correct newsgroup - I've also posted this message to the microsoft.public.dotnet.framework.adonet newsgroup... As part of a datawarehoue application, I have a Windows service which iterates through a mySQL DataReader (using the CoreLab native .NET provider)...more >>

We're putting together our data warehouse, and I had a questions regarding design of fact tables for our situation. We have invoices and payments to those invoices...would I include all information in one fact table, or would I separate them into two tables? If I do two tables, can I include...more >>

Hi, I have to create a query which evalaute, for each year, the employees who reached a particular number of absences and when this value is reached. I have 1 000 000 records in my absence table. my table is like this: DateID, EmployeeID, ActivityID, AbsenceDurationInDays I want a lis...more >>

I have 2 instant of SQL server on the same machine. 1st instant keep most of the static information - Dimensional data 2nd instant keep most of the transaction information. When I try to use the Analysis Services, I have 2 connection, but they can't talk to each other. after I define the f...more >>

-what is the best method that to implement the near real time updating of a fact table without affecting all those users who are reading from it? -fact table in question is only 1.8gb in size, 3.1 million rows, expect near real time updating of approx 1000 new fact table records every 15 min, ...more >>

Hi, I need an extraction software that needs to be capable of capturing a table (or tables) displayed on the web and converting it to a file as a list of records with comma separated values. The records will be converted to insert commands after the cleansing process. The software will be ...more >>

Hello all, I have a datbase design problem I have a hierarchy that includes 5 levels and each level have a table EX : TABLE_L1 L1_ID INT AUTO L1_CODE nvarchar(50) L1_NAME nvarchar(255) TABLE_L2 L2_ID INT AUTO L1_ID INT L2_CODE nvarchar(50) L2_NAME...more >>

Hi, I'm about to build data warehouse of approx 15 Gb. The biggest table is expected to be of 10 000 000 records. How will MS SQL 2000 Standard Edition cope with it? Thanks, Alex ...more >>

For some reason, I am unable to test roles I have defined in my cubes. I have done this before, but now the Test Role button is not appearing in the Role Manager. Anyone have any ideas? Thanks...more >>

I am creating a table with following fields: CREATE TABLE Employee ( EmployeeID bigint NOT NULL, EmpName Varchar(50), EmpAge int, ImageSize int, EmpImage image, Comments varcha...more >>

Hi I am running Sql Server 2000 Enterprise on a Windows 2003 server with Analysis Services. Everything works good but AS had a long time to log in. I've instaled SP3a on the server and workstation. I have IBM Datacenter with 16 CPU and 64 GB RAM and GB-LAN. What should I do? Please advise, or ...more >>

I have an ODS system and a Data warehouse system I have a Sales fact table in the ODS system and I have these fields: SALES ID_CUSTOMER (PK), ID_MODEL (PK), ID_TIME (PK), SALES, QUANT_ART, COST Then in some records in the fields ID_Time or ID_Model or ID_Customer I don’t have va...more >>

Is there a way to rename an Analysis Services database? Can I do it through the Analysis Manager interface? Thanks!...more >>

Would like to know how to use SQL 2000 command to modify a IDENTITY column previously defined as YES...and now need to change it to Yes (Not For Replication). Thanks...more >>

I expect a 3 terabyte warehouse would need no less than 8 processors 32 GIG ram SAN storage for data, logs, backups Note: Analysis Services on the same box. Hits coming from ProClarity, Excel and Crystal. What do you think? d. ...more >>

I have a customer dimension with two levels: Master Account Num Child Account Num where each level has a member property called "Branch". I have a role called Branch20. I want to apply a custom MDX expression to filter master and child accounts for property Branch when I'm restricting acc...more >>

Hi, Anybony knows how much free space on disk should I have to process a new OLAP cube? And, if I have a processed cube and I just want to do incremental update, how much free space on disk should I have ???? Thanks Richard_SQL...more >>