Archived Months
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
all groups > sql server data warehouse > october 2007

Error with SSAS project
Posted by Frank Doosey at 10/23/2007 10:13:28 AM
Hello, I am learning how to use the BI tools with SQL Server 2005. I am following the tutorials on creating an SSAS project. My connection string tests successfully and all SQL Server services are running, but when I try to analyze a cube or deploy the package, I get the following error: ...more >>


SQL 2005 Tables
Posted by Krista at 10/22/2007 8:04:02 PM
What is the maximum page size of SQL 2005 tables? TIA! -- Krista...more >>

what is the best way to store passwords and credit card information in SQL Server 2005?
Posted by dr at 10/18/2007 9:35:23 PM
what is the best way to store passwords and credit card information in SQL Server 2005? ...more >>

SQL Server 2005 Express as a Data Mart environment
Posted by Andy Henderson at 10/16/2007 1:10:36 AM
I am brand new to SQL Server. I'm decently versed in VBA though will be leaning SQL as part of this process. Currently I am using Excel 2007 for my validationn and data storage requirements and am the sole designer and daily user. The data workbook has 36 sheets which represent a utility mete...more >>

Tutorial about dwh and SSAS 2005
Posted by Pasquale at 10/13/2007 2:34:01 PM
I need to find a good tutorial that talks about building datawarehouse, cubes, dimensions, etc. with SSAS 2005. Many thanks for your suggests...more >>

SSAS and viewing errors
Posted by Joe at 10/12/2007 11:03:27 AM
I get the following error when I try to process my cube. What is killing me is if I really do go open these tables and look for the attributes it says are missing - they really are there. Not sure what to do: "Errors in the OLAP storage engine: The attribute key cannot be found: Table: de...more >>

Reporting on a cube with SSAS 2005 e RS 2005
Posted by Pasquale at 10/11/2007 7:58:01 AM
I want to create a RS report on a OLAP cube built by SSAS 2005. This report has to allow to an user to select or not dinamically which dimension to calculate the measure. Is it possible? As report action in SSAS 2005? Many thanks for your suggests...more >>

XML Data type in SSAS 2005
Posted by Bhupesh Mohan at 10/9/2007 1:09:07 PM
Hi, I am having the XML data type attributes in the SSAS 2005, when I am process the Dimension then it is giving the exception like "Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated. Erro...more >>



Analysis Services 2005 and Web Services
Posted by Doomed ReportsGuy at 10/5/2007 8:17:19 AM
Can Analysis Services read Web Services, then relate that data to other cubes or data sources? Thanks *** Sent via Developersdex http://www.developersdex.com ***...more >>

Transaction LOG
Posted by Allan M. Grafil at 10/5/2007 12:00:00 AM
Hi guys, I dont know if im in the right group. My scenario is like this. = Transaction logs are eating up my server's hard drive. Almost 60% of my = space is transaction log. What are these? Can I simply delete it? Can I = compress this? Can someone explain this log file. Thank you in a...more >>

Design for star schema
Posted by Jean at 10/4/2007 11:30:59 PM
Dear newsgroup readers, I am working on suggesting a data warehouse design for an insurance company. The business logic is that there are Customers and each Customer has a Captive. Also, each Captive has a Cession. On the technical side, there is at present an OLTP database for the Front ...more >>


DevelopmentNow Blog