I am trying to figure out the best way to design a database that links to
external information like freedb.org and amazon, ect.  I have created the
tables of the information I am looking for, but am wondering if I have to
create a table to link to those places to import the ...

I'm new to database design and I have a design question that I hope I can get
some ffedback on. I want to setup a table structure to accomplish the
following scenario:
The goal is to create a tracking system for tracking attendance in meetings

Good afternoon,
Lately there has been discussion of what the best practice would be for
enterprise reporting needs. Specifically, we currently have online OLTP
servers for our business apps, as well as a data warehouse server.

I'm having a bad time with Oracle and Analysis Services 2005. We are
migrating a Cube from AS2000 wich uses Oracle as Data Source.
The installation is clean. The machine haves only SQL Server 2005 installed,
with instances for Database Engine and Analysis Services, and client ...

we have a legacy database on a UNIX box for our production system (OLTP).
This is the only database used for both OLTP and custom reporting. The
database is now hugh and reporting is very limited as well as slow
processing. When certain reports are run the users have latency in ...

I am using AS 2000 and would like to create a calculated member that shows a
calculated value back to a particular month regardless of year.
Here is an example.
I am looking at data for the month of July, 2005 and I want my calculated

Hi there, I try to migrate olap db to Analysis Services 2005, and error shows :
Error Messages 6164
                    Errors in the OLAP storage engine: The attribute key cannot be found:
Table: dbo_Dim_Proper, Column: Kode_x0020_Proper, Value: 1632001. Errors in

Looking for some suggestions to implement time and calendar data within a
DWH.
I've done a fair bit of investigating best practices for implementing time
as a dimension within a DWH, but none of them talk about breaking time down

I would like to use the max function on cacluated Member.
IS there way to do this?

We are still fairly new to data-warehousing. We have a fact table that has a
fk to the dimension table... and the lookup translation is too SLOW...
We are currently using t-sql and stored procedures for our ETL work. We open
a cursor to read the source (stage table) and do basic ...

Hi,
I am trying to confirm a hypothesis on the Network traffic that a certain
DTS will generate, my environment is configured as follows:
Server A: SQL Server Instance to act as source

we have cubes partitioned on the time dimension. The majority of data that
comes in if for the last 4 days or so. The new data is loaded into a seperate
fact table, and loaded into a partition. This partition is then merged into
the current month partition.

I know that I define what makes up a cube. I know that I point Analysis
Services to a data source. But when I create a cube, is it actually making a
copy of that data source defined by my dimensions and measures? Or is it
just creating meta data with my definitions?

I just learned today that a project I'm working on has a couple of very
large tables that need, somehow, to be optimized for searching.  One table
has roughly 7 million rows, and another, its relative, has over 16 million.
At present, client applications only insert into these ...

Im a total newbie to Analysis Services and MDX, so please bear with me.
This code works:
IIF(Ancestor([Product].CurrentMember,[Product].[Category]).Name =
"Bread","Bring","Don't Bring")