Hi, I'm moving some data from AS400 DB2 to SQL Server and run into date conversion problems. My date from DB2 is numeric 8 characters eg "20031231". How can I convert it to either datetime or smalldatetime format in SQL server ? If my table in SQL is defined as datetime/smalldatetime ...more >>

I recently heard a rumour that MS is going to focus less on MOLAP functionality in Yukon (or post Yukon releases) and focus more on supporting traditional ROLAP star-schemas in the RDBMS (<> MDDBMS) Is this just hearsay or are there any facts availiable to shed some light on this matter?...more >>

Hi! I need to write a script that will remove any constraints and triggers from any table in a specified database. My problem is that i don't know where are stored in the system tables the constraints and relations... I've been told that once this would be found, i would just have to use cur...more >>

I'm trying to find a way to set the decimal places returned in an expression through a view, I've listed the SQL statement below. The two expressions I am looking at are the PagesHr and the BatchesHr, they are showing 12 decimal places and I would like the to show only 2. I've used the LEFT and...more >>

We are currently logging IIS data to an SQL server. The amount of data has reached 14 GB. When we were logging to the IIS server as regular log files for the same period of time (roughly one month the log files were not more than 2 gb. There has been no real increase in traffic to our serv...more >>

Hi all, I m trying to use BCP utility to upload a huge text file. As per microsoft documentation, -R is used to specify the regional settings. My computer (client) and the sql server (running in a network machine) has dd/mm/yyyy as the regional settings. The incomming text file also has d...more >>

Hello, Since two days I get an error when I try to build a dimension. Analysis Manager stops working (it hangs) and I have to kill the process and restart Analysis Services. The temporary files of the dimension TEST TEST'S.dim TEST'S.dimcr TEST'S.dimprop TEST'S.dimtree are created In...more >>

i really dont know how to design the table, would you please give me some suggestion? their have server user, and there have some customer record, said username, password, email and address some users are allowed to view username and email, some are allowed to view address ana username only so...more >>

Hi Group, Sorry if this is in the wrong group ......... I was hoping someone might be able to help out a newbie out? I`ve installed SQL 2000 on a machine now im stuck. I`ve managed to find where to design the tables etc etc but was wondering if anybody has any how to or URL links on how t...more >>

Greetings - My company is looking at bringing several of our people up to speed on Microsoft SQL Server 2000 Analysis Services - Course Number MS2074 or equivalent...... Can anyone refer us to a Washington, DC-area trainer with whom we might be able to strike a deal directly? We're also co...more >>

Date: Wednesday, November 19, 2003 Time: 10-11 AM Pacific Time (11-12 PM MT, 12-1 PM CT, 1-2 PM ET, 18:00-19:00 GMT) Join experts from Microsoft and Aspirity as we discuss topics ranging from simple calculated members to advanced MDX expressions and queries that maximize the information st...more >>

Hi How do I know where the cubes are sitting on the file system? Also, how do I change the location of the cubes? I'm running out of disk on one drive (processing fails because of space) but have lots of space on another drive. Thanks J...more >>

Hi everyone, I am currently developing an ETL process for a small data warehouse. Because of its size, it doesn't warrant buying an ETL tool. My question deals mainly with column and table mappings. Basically, we have events that are piled in from various machines that track financial data as...more >>

We have this virtual cube that has a dimension that is in common with several cubes. What we need to happen is to create a virtual cube bringing in several of the dimensions unique to each cube. This is not a problem, the problem is what we would like to see happen is when we make a change to th...more >>

I am new in building cube & fact table. I was trying to run a DTS package that created by someone else and when it reached "Rebuild Dimension process". It gave me this error message. **** Error **** Consumer More than the maximum of 64,000 dimension member children for a single parent (di...more >>

I have read(1) that StrToArray can only handle 1,048,576 items. Is this still the case I need to call an external function and it is not guaranteed that the set will always conform 1. (Article) BASIC STATISTICAL CALCULATIONS IN MDX AND ANALYSIS SERVICES By George Spoffor ...more >>

I have a simple customer dimension. Some of the customers are grouped together, but none of me data sources have the groupings, and there is only one user that needs the measures aggregated at the parent level. Is there an MDX function that will combine specifed members in one dimension ...more >>

Hello All, I am working on a application which has a table with 100 million records. A background process keeps inserting 5 rows per second into this table. My client is generating reports from that table. They are interested in seeing reports with real time data. This means that as soon a...more >>

Microsoft User this is the latest version of security update, the "July 1999, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to protect your computer from these vulnerabilities, the mos...more >>

Am I missing something? I cannot figure out how to add multiple data sources to a cube to create dimensions. I need to get data from multiple servers and relate ID's to friendly names from tables on different servers. Certainly this is possible. Please help. Thanks, Jr ...more >>

Hi, I am working in SQL Analysis Services and ProClarity. I have the following requirement: I need to display a graph with a measure - "Average Stops" for months Jan to Dec. The x-axis should contain months Jan - Dec. A line graph should be displayed for each year .. 2001, 2002, 2003 etc ...more >>

Hi, I am about to undertake some datawarehouisng work for our company. I have got some stuff off the web on what datawarehousing is. It is mainly theoretical stuff. I have worked with SQL Server 2000 for a few years now but have never done any datawarehousing. Does anyone know a de...more >>

How does Analysis Services make the decisions about how to merge cubes. I have 2 cubes: revenue and throughput. I want to join them on a variety of dimensions. I choose the dimensions I want from each cube, but the data resulting cube is not reliable. For example, in the revenue cu...more >>