|
|
|
January 2003 March 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
MDX Query - Help needed from experienced Posted by saiser at 3/28/2006 9:24:16 PM Ingen
=====
GA - Georgia
--County1
--- SharedFlag
--County2
--- SharedFlag
NC - North Carolina
--County1
--- SharedFlag
--County2
--- SharedFlag
MD - Maryland
--County1
--- SharedFlag
--County2
--- SharedFlag
Query 1:
Select Non Empty [InGen].[State Name].Members on...more >>
Are there any Datawarehousing webcasts from microsoft ? Posted by Rose101 at 3/28/2006 8:33:10 PM
...more >>
database design: primary keys Posted by Bill H at 3/28/2006 2:17:40 AM Is it recommended to keep primary keys limited to a single field?
I have an account_id in all tables, and I wanted to make the rec_id in all
tables unique within an account_id, so the primary key would be based on
account_id + rec_id. I like the idea of each Account starting at 1 for
their...more >>
MS SQL Sever 7 to SQL Server 2005 Migration Posted by lonskie1030 at 3/27/2006 5:11:02 PM Hi,
I would like to ask, is there any way i could migrate data on my SQL Server
7 to SQL Server 2005? Is there any available white paper or article regarding
this? Kindly refer one to me.
Thanks in advance.
...more >>
Indexes vs Statistics Posted by Magnus Österberg at 3/26/2006 7:31:11 PM Hi!
A beginner's question...I would look up the answer myself if I had the time,
I'm in a bit of a hurryy...
Indexes vs Statistics:
Does running sp_updatestats mean that all indexes in my database is updated?
If no, then how do I do in order to update the indexes? I know CREATE INDEX
...more >>
Product Dimension Posted by Statsman at 3/24/2006 2:16:57 AM I have a parent-child product dimension.
It is parent-child because it is unbalanced - some products have more
levels than others.
This dimension has the product members for the entire Group.
However, because different products have different relevant dimensions
I have a number of cubes - i.e. ...more >>
Storing attendace - design question Posted by Henrik at 3/16/2006 1:08:22 PM 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
for members of a project group. I want the proj...more >>
Course for Designing and Populating a Data Warehouse? Posted by jwgoerlich NO[at]SPAM gmail.com at 3/16/2006 4:34:33 AM Hello,
A while back, I took Microsoft Course 2092A: Designing and Populating a
Data Warehouse with Microsoft SQL Server 2000. I have been reading
about SQL Server 2005 and see that it has several new data warehousing
tools. I want to learn more. Is there a course for building data
warehouses ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problems loading data from Oracle Posted by Rafa® at 3/15/2006 5:02:27 AM 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 tools
(to deve...more >>
general question about handling times and calendars Posted by Immy at 3/10/2006 4:53:50 PM Hi all,
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
by calendar types and i'm wondering if there is a ...more >>
error migrating olap db from analysis server (SQL Server 2000) Posted by octoni at 3/7/2006 10:10:27 PM 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
the OLAP storage engine: The record was s...more >>
SABII on SQL2000 / Time dim problems Posted by Antonio Ramos at 3/7/2006 11:46:52 AM I have SABII on SQL2000. When we fisrt configure using the excel spreadsheet
we generated the time dimension until 12/31/2005 so we have no more time
data after that date. We have no idea on how to populate the time dimesion
for marketing, fiscal and standard. Can anyone help?
...more >>
error: CoCreate of DSO for BULKIMPORTSTREAM Posted by Chris Trailer at 3/7/2006 11:14:30 AM Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experie...more >>
using Max on analysis manager Posted by Roy Goldhammer at 3/6/2006 4:20:34 PM Hello there
I would like to use the max function on cacluated Member.
IS there way to do this?
...more >>
DTS Network Traffic Posted by i-DLT at 3/6/2006 9:37:28 AM 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
Server B: SQL Server Instance to execute DTS Package
Server C: File Server at remote location to be tar...more >>
Foreign Keys in Fact Table - performance help Posted by Ray at 3/2/2006 3:16:21 PM 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 insert operat...more >>
Calculated Member Posted by Bill Walo at 3/2/2006 12:31:26 PM Hello All.
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
member to show a calculated value for the...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |