|
|
|
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 |
Data Mart corrections Posted by Joe at 9/28/2007 11:58:16 AM We had to manfully correct a couple records in our data mart - but don't
have the luxury of changing the source OLTP tables.
What is the best approach to prevent the ETL to pick this change us as a SCD
entry and move back the data correction to be in line with the source
tables?
...more >>
Importing tables from Access to SQL Server Posted by Shane Jones at 9/28/2007 10:31:56 AM I've inherited a project which has numerous fields that have extra spaces in
them -- this is causing a problem with data Inserts, Edits, and Deletions in
my .ASP Website.
I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I need
to know if there's a way that I can Right Tr...more >>
SSIS QUESTION Posted by at 9/26/2007 1:16:41 PM Hi
I am new to this area, please be nice to me.
BTW, am I in the right group?
I am very new to SSIS, but tons of experience in SQL programming. I
would like to do an SSIS package, a simple one. can I do it in SSIS
with something like this in SQL or I have to use SQL.
SELECT TABLE1.col1, TAB...more >>
OLAP Connectivity from Pivot Table Posted by Deva at 9/25/2007 12:36:01 AM Hi,
We are using Pivot Table object in MS-Excel 2003 to display the reports
using OLAP objects like Cubes. It connects to an OLAP Server and database to
fetch the data.
When we try to refresh data in the pivot table, it internally checks whether
the windows user from the current system h...more >>
storing documents Posted by Pure Heart at 9/24/2007 10:56:09 AM hi
can SQL Server 2005 enterprise of any other version store documents such as
word, acrobat, Excel
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643...more >>
null in Cubes measures Posted by ERS Developer at 9/21/2007 12:44:03 AM Hi,
I have a simple cube with one measure group and 3 dimensions (A,B,C).
The cube is deployed and processed sucessfully.
When I browse the cubes with Dimension A and B the measure is showing the
data. But when I start using the third dimension C the measure is showing as
null.
Any help...more >>
Error in Cube Browser SSAS 2005 Posted by ChiWhiteSox at 9/20/2007 3:18:03 PM hi all, i was finally excited when i got to process the whole cube without
the errors.
but now im facing another catastrophe!!
when i try to browse the processed cube, dragged the gross revenue measure
and the hierarchy on the rows, i get repeated values on the measures !
pls check out ...more >>
Relational Views as Transformation Method in Data Warehouse Posted by DanUp at 9/20/2007 12:04:04 PM Open Question:
A recent post-reply, one expert (Marco Russo) indicated that he doesn't like
to use relational views as a quasi-ETL method, but rather prefers real
data-moving ETL to de-couple OLTP data from DW Data. I do agree with the
importance of the classic de-coupling approach, but woul...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Is there any helpful tool could manage data movement? Posted by YesGoGoGo at 9/19/2007 10:43:16 PM hi!
I join a datawarehouse project which already run in 2 years.
There is few document left,so I can't see the whole picture of the
project and data movement.
Now I've tried to trace these data movement and keep it in record.
I wonder if there is a helpful tool could manage these data movement....more >>
Seek Book on DW Modelling for UDM Posted by DanUp at 9/19/2007 11:44:00 AM Hello,
Although I'm familiar with Kimball Group methods for DW modelling, I am now
in search of a more specialized learning resource (preferably a leading book,
but perhaps also a blog or website) that covers dimensional modelling best
practices (in relational engine) into line with the use...more >>
Fighing for Business Intellignece Posted by Joe at 9/17/2007 8:55:17 AM We have a couple data marts and a handful of users accessing the data =
mostly through Cubes. We work for a govt agency that doesn't have much =
money - so our analysis tools are limited to using Reporting Services; =
Report Model to query the cubes. =20
We are now having to fight to continue...more >>
Issues with BI DW and Virtualization Posted by Nickg at 9/14/2007 6:52:03 AM We are creating a new environment for our BI DW. This includes servers for
SSIS and one for DW and disks on a SAN. Because of licensing the current
environment uses virtualization.
My question is, what are the drawbacks of using virtualization with MS SQL
server for BI DW?
Does anybody ...more >>
SCD Type 2 Modeling Question Posted by Mike C# at 9/12/2007 11:40:25 PM Hi all,
Quick question about modeling a Type 2 SCD. Assuming I have a dimension
table that resembles this:
DimCustomer
--------------
Id /* Surrogate Key */
CustomerNumber /* Business Key */
Name
City
State
Current /* Y/N Current Flag */
StartDate /* Start/effective date */
...more >>
End Date . . . ? Posted by GGill at 9/11/2007 9:02:04 AM The date i select from my report to pull data 'End Month Date'. I need to
calculate my 'TotalAmount' base on my 'End Month Date' and previous 'End
Month Date'. For example:
if i selected '20070831' and 'TotalAmount'= '100', base on my selected date
i need to get 'TotalAmount' from previous '...more >>
Discover hierarchy Posted by Al at 9/10/2007 4:53:49 PM Is there a way with MDX to discover the hierarchy of a dimension. In other
words a calendar dimension would have year - quarter - month - week. I want
to create a MDX query that would return [Calendar].[month] instead of
"January 2007" for a month or [Calendar].[Quarter] instead of "First
...more >>
SCD Wizard Question Posted by Mike C# at 9/8/2007 7:41:59 PM Hi all,
I've been playing around with the SSIS SCD Wizard. I noticed that I seem to
be getting better performance updating my SCD's with stored procedures. Is
there a list of best practices concerning the SCD Wizard or something else I
might be missing? Also, I have about 30 Dimension ta...more >>
Drill through from excel 2003 into analysis server 2000 Posted by Tore at 9/6/2007 4:32:01 PM I am using MS Analysis Server 2000 to build cubes. To display the result I am
using MS-Excel 2003. In the cube which I have made, I have enabled the Drill
Through option and selected all fields to drill through in the cube. I am
able to see the row level data in the data pane of that cube in...more >>
Newbie Question Posted by Fresno Bob at 9/4/2007 11:09:11 PM Just getting started with Analysis Services. In my first cube I have a table
of cases broken down by geographical area. I am looking at it in the browser
and I have regions along the top with sums in each column. But regions do
not show up if they have no cases. Is there any way to force SSAS ...more >>
General Question on Slowly Changing Dimensions Posted by Nestor at 9/3/2007 8:28:33 AM Hi all,
Some questions on identification of Slowly Changing Dimensions. When
exactly do we determine if a dimension is classified as SCD?
For example, if I have a Customer Dimension table
Customer Key Name Country
1001 John USA
If John changed his state to Australia,...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |