| Thread | Last Post | Replies |
|
| Design question | 27 Apr 2007 18:45 GMT | 1 |
I have 2 tables like this:
First table has rows indicating is someone comes in (InOut = 1 or goes
out (InOut = 0)
InOut
|
| Problem in loading data from Excel | 24 Apr 2007 13:34 GMT | 1 |
I am building a DTS package in Sql Server 2000. Data source is an
excel file and destination is Sql Server 2000. This package runs
monthly and loads the data into database. But evey month the number
of
|
| BI Deployment Experiences | 23 Apr 2007 16:28 GMT | 4 |
I'm trying to get some info on how other companies are handling BI
implementations. We have a data warehouse project that we expect will have
continuos changes. That is, new data sources coming in, more reports, etc.
That implies new Integration Services packages, new Reporting ...
|
| Design datawarehouse schema | 23 Apr 2007 10:31 GMT | 2 |
I need to design a datawarehouse for the manufacturing industry. I'm
sure that this has been done a dozen times, and I was wondering if
there are workgroups where I can find a sample schema, reports and
others?
|
| Kimball Templates | 23 Apr 2007 10:24 GMT | 1 |
When using the Kimball templates for designing Dimension tables, there are 3 columns I have questions about.
Isn't the RowStartDate and RowEndDate the way to manage historical values? If so; why is the need for RowIsCurrent?
In my example dimension below, it is capturing slow ...
|
| How to run a xmla script from an SSIS package | 11 Apr 2007 12:46 GMT | 1 |
I have a xmla script that adds an role to a SQL Server 2005 Analysis Services
database (see below). How do I run that from an SSIS package ? Is there a
specific SSIS task that will do it ?
Here's the script:
|
| How to auto-refresh cubes | 10 Apr 2007 18:09 GMT | 5 |
Is there anyway to auto-refresh the Analysis Services 2005 cubes when data
is updated in SQL server 2005? I tried configuring the cach options under
Paritions, but that's not doing it.
Thanks,
|
| Using addextendedproperty in DB for documentation | 09 Apr 2007 18:45 GMT | 2 |
We are using Kimball templates to model our Dimension/Fact schemas in an Excel sheet. It allows us to captre extra columns per row such as, "Source System", "Source Table", "Source Field Name", etc. Then it generates a script to run in t-sql to create the given table with the ...
|
| Attribute relationship doestn't exisits between | 07 Apr 2007 20:13 GMT | 3 |
I am using SSAS 2005 (64bit)
i have client table
Dimension is
ClientShortCode (First letter of clientcode)
|
| ETL tables advice | 03 Apr 2007 15:53 GMT | 4 |
We have a fairly large BI database on SQL Server 2005. The whole thing takes
up just short of a terabyte right now. This is a project that was started
before I came along and of course I have now inherited it.
Currently we have EVERYTHING in one database. The ETL tables, the ...
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread