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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|