|
|
|
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 |
ADOMD Posted by Gema Sánchez at 5/27/2005 12:00:00 AM
Hello:
I've installed ADOMD.NET and I've tried to connect Analysis Service with
ASP.NET (using VB.NET). I receive errors but I don't know how I must use
ADOMD.NET. Can somebody help me and show me how I begin?
Thanks.
Regards.
...more >>
transferring data between dbs on sep instances of sql server group Posted by Kelly at 5/24/2005 1:44:05 PM they want to pass data between several distinct dbs on diff server groups.
I'm way new to sql server and not sure it can be done. Help! I use
enterprise mngr to do bkups and such, but that's the extent of it.
--
Kelly...more >>
Should I use a new Dimension or not? Posted by marcmc at 5/23/2005 1:22:04 AM I have about 16 new columns I am bringing into the datawarehouse from an
AS400 system. Getting them in is no problem. I need to 'massage' these
through the warehouse in either an existing dimension or a new one. I am
toying with the idea of a new one in order to be able to trace directly if
...more >>
MSSQLServerOLAPSevice Posted by Pravin at 5/20/2005 8:07:19 AM all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are
working excelp OLAP services, i even restarted the server. In service manager
it shows 'Starting' on status bar. when i try to connect server through MSA
it gives me error 'cannot open connection to Analysis server th...more >>
Connection OLAP with VS.NET Posted by Gema Sánchez at 5/20/2005 12:00:00 AM Hello,
I'm trying to connect with Analysis Service's Database and create, see,
drop cubes with ASP.NET (programming in VB.NET). What I need to do this?
(I'm beginner with Analysis Server, but already I knew SQL Server).
Thanks.
Gema.
...more >>
Newbie, Howto create trigger to delete an external image file Posted by robdob2003 NO[at]SPAM yahoo.com at 5/19/2005 6:51:05 PM Hello,
I'm using SQL2000 and I have a table which has a field within it called
"ImageFileName", what I would like to do is create a trigger to
automatcially delete the disk resident image file that is contained within
the "ImageFileName" field of the table upon the deletion of any of these...more >>
SQL EXPRESS install on system with multiple CPU's Posted by twahl at 5/19/2005 10:26:01 AM SQL Express is limited to 1 CPU. What are the ramifications to installing it
on a system with multiple CPU’s? Will it simply bind to one of the CPU's?
Thanks for your help!...more >>
Database Design - newbie question Posted by Nuala at 5/17/2005 10:25:53 AM Hi ,
First of all my apologies for this very basic question but I can n't find a
definite answers to this question.
I'm new to data warehousing and have started reading "The Data Warehouse
Lifecycle Toolkit" by Kimbal (and others). From it I understood that the
database in your applicati...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help in Design Posted by DNG at 5/12/2005 10:38:42 PM Fast food chain store (Think the likes of Burger King or McDonald's). Items
are sold separately or combined. Need to know, for each item sold, what are
the ratios that any other items are sold in the same order.
For example, one day during 5-6PM, 200 Cokes were sold in 160 transactions
(orders...more >>
Fact Table with Dimensions Posted by Bobbyx2405 at 5/12/2005 7:01:04 AM Hello:
I'm a newbie to Datawarehousing and using of the concepts of Dimensional
modeling. I read about Kimball's methodology too.
I started using Analysis Services, which is really great. I created tables
with the primary index values.
My scenario is like this.
I should be able to...more >>
How to convert binary or hexa to decimal? Posted by Adam at 5/11/2005 10:57:33 AM Hello,
I'm trying to decifer the data in the table that stores the data in the
binary format. All numbers are placed in varbinary fields. All I know is the
MS SQL 2000 database useing collation SQL_Latin1_General_CP1_CI_AS
(default).
For example the content of the field is:
(0xB4F500000000...more >>
Drawing up the spec for our Datawarehose Server Posted by Russell at 5/11/2005 4:31:03 AM I am in the process of drawing up the spec for our data warehouse server. The
setup that I am having to cater for is a server that will hold:
1) a replicated copy of the tables that are going to be used to extract that
data from as we have 22 offices this will be 22 databases. (ranging in siz...more >>
SQL Server 2000 Query tuning question Posted by MattODA at 5/10/2005 8:46:02 PM I have a star schema where the fact table is about 1.2M rows, and about 40
measures wide (a lot, I know). I've been tuning and studying Showplan and
have performance almost where I need it. But I'm encountering something I
don't understand. When I run this query:
select REGION_NAME,
Sum...more >>
Check File size before importing Posted by deheinz1 at 5/9/2005 1:57:33 PM I have a DTS procedure that runs 4 times a day. It has worked well until
now. It is reading infromation from a text file. Today the text file was
empty and DTS failed giving me this error; "The volume for a file has been
externally altered so that the opened file is no longer valid.". I bel...more >>
DTS from 2 sources ???? Posted by john1425 at 5/9/2005 3:38:11 AM
hi
i want to load Data from 2 sources (access and mysql) the 2 source have
same schema ;how to load to cube the data and retrive the data of each
source and how configure DTS to continue from the last ID of the last
load exp :
source1 : product(id,,name)
(1,nokia 3310)
source 2 : product(i...more >>
I am new to data warehousing and have a few initial questions Posted by Russell at 5/2/2005 1:55:01 PM 1. Just to clarify a datamart is collection of dimension tables that related
to a particular fact table within the data warehouse? I understand that the
same dimension table can be used more than once e.g. the Time dimension.
2. I would like to use Analysis Services with Reporting Services to...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |