Submission Deadline extended: 13 November 2006 ************************************************************* IADIS INTERNATIONAL CONFERENCE APPLIED...

natty2006@gmail.com

10-23-2006 10:06 AM
natty2006@gmail.com

We're at the beginning of expanding our reporting system into a datawarehouse. I'm conscious that column names need to be user friendly : easy to...

Corvette1964

10-21-2006 03:06 PM
michanne

Hi all, I'm new to datawarehousing. I've built a DW with two fact tables, each one will be added with more than 5 to 10 millions rows each day. Do...

Jerome

10-20-2006 06:07 PM
susiedba@hotmail.com

We have data migration process that transfers around 450 million records from one DB to Another DB. There is a validation that takes place for the...

Murali

10-20-2006 06:09 AM
Tomasz Borawski

Hi, We are working on a project with SQL Server 2005 and SSAS. We created several roles using dimension security and one special role that requires...

athena no seinto

10-19-2006 05:48 PM
athena no seinto

I have an activeX script that has an inputBox, takes a string value and puts that into a global variable. I then want that global variable...

nataliesarahtaylor@gmail.com

10-19-2006 08:10 AM
nataliesarahtaylor@gmail.com

Hi, I currently have a system which contains a bunch of relational tables in Sql Server. I am currently reading a book on Analysis Services...

quortex@hotmail.com

10-18-2006 03:13 PM
quortex@hotmail.com

MS SQL Server 2005 - Analysis Services - Decision Tree Algo Can set up parameters to force the Decision tree to break down to the nodes we...

Light Warrior

10-17-2006 04:22 PM
Light Warrior

Hi all !! I would like to export a cube from a server to another. I don't need to export any data, just the structure, fact table and some DTS...

Ibon Colias

10-17-2006 03:20 AM
Ibon Colias

We have a .NET application that uses ADOMD to query a MS analysis OLAP cube. In a typical query, we get data for about 3 dimensions (800 x 15 x 2...

vipul.tankariya@gmail.com

10-14-2006 04:36 AM
vipul.tankariya@gmail.com

Dude, Microsoft doesn't listen to customers... don't kid yourself Umachandar Jayachandran wrote:

susiedba@hotmail.com

10-13-2006 02:20 PM
Kent Tegels

I have set formatting of a calculated member in a cube to 'percent'. When I view the calculated member in an office 2003 pivot table, it does not...

prabodhjp@gmail.com

10-12-2006 08:45 PM
susiedba@hotmail.com

Hello everyone :: we would like to ask you a question acording the usage of uniqueidentier as key fields we are planning to start designing an...

.·:m·a·r·l·a:·.

10-11-2006 11:42 AM
Thomas

Hi, I am getting errors while synchronizing databases between two machines in my LAN using the SQL server 2005 Management Studio -...

somuthomas@gmail.com

10-11-2006 12:36 AM
somuthomas@gmail.com

Would like to learn how to create Data Warehouse. "AdventureWorks Data Warehouse" sample is great sample. but it seems like that there is...

frankie lo

10-09-2006 10:17 AM
frankie lo

Hi, I used the deployment wizard in the analysis services 2005 to convert the cube into XML script. Using the SQL Management Studio I opened it as...

somuthomas@gmail.com

10-09-2006 07:45 AM
somuthomas@gmail.com

Assumptions: using AS2K5 ent edn; assuming no aggregations to allow me to say 'server would read from partition' rather than aggregation. If you...

stevefromoz

10-08-2006 10:52 PM
stevefromoz

Hi Dev guys, Have hit a snag trying to use Usage Based Optimization (64bit AS 2K5 install, olapquerylog on SQL2K 32bit). Going through the wizard I...

stevefromoz

10-06-2006 03:57 PM
stevefromoz

Hello All, I need suggestion in designing of the datamart .I am using SQL Server 2005 Analysis Services The scenario is : Judy, Carol are two...

AnalsisCoder

10-06-2006 12:43 PM
Bill Robinette

I'd like to start learning about data warehousing, specifically with the proper design of them. Does anyone know if there is a certification...

ChrisR

10-06-2006 12:29 PM
Bill Robinette

We have 3 Cubes rolled out into production on SQL 2005 - works great. The methodolgy used was OLTP to Staging (3 different levels) and finally to a...

Joe

10-04-2006 04:47 PM
Joe

Does anybody know if it's possible to use MDX statements to query MIS Alea? if so, does anybody have an example? Thanks! Simon

sk

10-04-2006 10:25 AM
sk

I have a simple cube, dimensions are time and customers (id, name, address, contry, etc), fact are quantity On Y axes I have to show the customer...

Alessandro

09-27-2006 10:18 PM
Peter Yang [MSFT]

I run several DTS Packages that load databases residing on two seperate instances of SQL Server 2000 on the same server. For security reasons,...

PGene2

09-25-2006 11:42 AM
PGene2

Hello I have imported some mdb tables to SQL server 2005 Problem is that in access, you could specify date/time data type and use format to display...

Davor

09-24-2006 05:26 PM
Nigel Rivett

I am looking into using Apex SQL Log explorer's command line interface to implement a source system data update trigger process. The...

rghazarian

09-24-2006 05:15 PM
Nigel Rivett

when I use sql server user id as the autentication for the package connection, I receive an error "The AcquireConnection method call failed...

Srini

09-24-2006 05:14 PM
Nigel Rivett

Hello, We are about to create a new reporting platform for our application. We are considering different solutions and I would like to get some...

Henrik Skak Pedersen

09-21-2006 01:20 AM
Charles Wang[MSFT]

I am looking into using Apex SQL Log explorers command line interface to implement a source system data update trigger process. I was wondering if...

rghazarian

09-18-2006 06:58 PM
rghazarian

We have created a few data marts and have many cubes now. We are moving forward with a Reporting Services endeavor to get a common reporting...

Joe

09-15-2006 01:44 PM
Joe

Using the UDM methodology - would I be able to fascilitate many-to-many dimensions?

Joe

09-15-2006 01:31 PM
Joe

Looking for good UDM SQL2005 tutorial. I have small set of tables I would like to try and use UDM to build cubes with.

Joe

09-13-2006 05:43 PM
Joe

We have existing data marts and cubes all working fine. We are about to embark creating a new cube which means another mart. However; I like the...

Joe

09-13-2006 12:31 PM
Joe

Hi, I am trying to connect to MS Analysis Server 2005 from a product called Axapta and I get this error message...

Harish Mohanbabu

09-13-2006 04:25 AM
Harish Mohanbabu

Submission Deadline: 9 October 2006 ************************************************************* IADIS INTERNATIONAL CONFERENCE APPLIED COMPUTING...

natty2006@gmail.com

09-12-2006 11:37 AM
natty2006@gmail.com

Hi guys, We've been developing a BI project with SQL Server RS 2005 and AS 2005. The problem is client needs to access RS reports through...

Boby Huntington

09-12-2006 12:24 AM
Mariel

Is there an Operations Guide for Analysis Services 2005 besides the REAL guide? Finding information on incremental backups, clustering,...

Ray Cochrane

09-11-2006 01:28 PM
Ray Cochrane

I got SQL Server 2005 Standard edition and Visual Studio 2005 from the Microsoft Launch I attended. I installed them but i cant use...

Sudhir

09-11-2006 06:36 AM
Sudhir

I got SQL Server 2005 Standard edition and Visual Studio 2005 from the Microsoft Launch I attended. I installed them but i cant use...

Sudhir

09-11-2006 06:31 AM
Sudhir

I got SQL Server 2005 Standard edition and Visual Studio 2005 from the Microsoft Launch I attended. I installed them but i cant use...

Sudhir

09-08-2006 06:05 AM
Sudhir

I used Excel 2003 to show the cubes in SQL 2000 analysis services. when I show the lowest level of the customer, then add the product dimension and...

Kam

09-08-2006 03:14 AM
Helmut Knappe

In SQL 2000 Analysis Service, Is it possible to create a dynamic MTD, LMTD, YTD LYTD dimension in the cubes? As it is the most common information...

Kam

09-08-2006 02:26 AM
Helmut Knappe

All SQL Gurus, We are in the exercise of planning and designing a data warehouse for our company. But at same time we are having a debate over...

Swagener

09-08-2006 02:06 AM
Helmut Knappe

From: "Denny" <denny (AT) newsgroup (DOT) com> Subject: Linked Server - AS400 - Missing Data Date: Thursday, September 07, 2006 3:34 PM I set up a...

Denny

09-08-2006 01:49 AM
Helmut Knappe

We are about to create a new reporting platform for our HR application. We are considering different solutions and I would like to get some...

Henrik Skak Pedersen

09-06-2006 12:24 AM
Wei Lu [MSFT]

Hi, I need your assistance with 2 questions: 1. I just got my new server and ready to setup as my warehouse (Data). It's has 2 logical drives: a. C:...

Chris

09-04-2006 06:52 PM
Chris

Hello All, I'm evaluating various databases for our DataWarehouse purpose. I was wondering if there is any comparison between Teradata and SQLServer...

gopi

09-02-2006 03:32 PM
gopi

Hi, I calculate a value in % for the utilization of a certain room --> this works fine. When I have 2 rooms the automatically generated total...

florian

09-01-2006 04:23 AM
florian

Hello Joe, I have seen this error before. It was caused by the SQL server being renamed Check the following: 1. Use the full server name instead of...

Joe

08-31-2006 01:35 PM
Joe

Hi, I wonder how can I diagnose where is the bootleneck of my system. DTS are running very slow as there is CPU usage about 20% and Avg. disk queue...

Piotr

08-31-2006 09:47 AM
Piotr