| Thread | Last Post | Replies |
|
| how to import an xml file to sql | 28 Jan 2008 14:41 GMT | 20 |
I am using 2005 Enterprise and Standard. I need to know to to import an xml
file to both of these.
Thank you
Dee
|
| importing xml that has dtd into an sql 2005 table | 23 Jan 2008 16:05 GMT | 1 |
I am trying import the data and column names from an xml file into an sql
2005 table. This is what I have used.
DECLARE @xml XML;
CREATE TABLE Products(xmlCol XML)
|
| Dimension question | 21 Jan 2008 15:23 GMT | 3 |
I asked this question in the MS OLAP and the SQL group but got no
response. I am
hoping somebody will have some answers here.
Thanks in advance
|
| Measure with aggregate None ... | 21 Jan 2008 15:10 GMT | 1 |
I have a measure that can't be aggregated (forecasted average item price per
month per productgroup), only values calculated based on this measure can be
calculated.
I have set its Aggreagatefunction to none.
|
| How to start learnig datawarehousing? | 20 Jan 2008 00:27 GMT | 3 |
I have worked with integration services and reporting services in sql
server 2005 and I am willing to learn datawarehousing, but how to
start?
|
| Unit Testing | 14 Jan 2008 12:06 GMT | 1 |
Does anyone have any ideas on how to unit test SSAS.
|
| load addition data to cube | 11 Jan 2008 06:57 GMT | 1 |
I've created some cubes for work.
The cubes are being loaded every night with changes of data.
Is there a way to load only additional data to cube?
|
| SSIS: Loading EXCEL into SQL Server - Cells w/ Data Load as NULL ! | 10 Jan 2008 17:49 GMT | 1 |
I've been trying to load the EXCEL Spreadsheet:
http://tonto.eia.doe.gov/dnav/pet/pet_pri_gnd_dcus_nus_w.htm
HTTP downloaded using the "Download Series History" link.
into SQL Server 2005 using SSIS.
|
| How change name of level (All) | 09 Jan 2008 14:31 GMT | 4 |
I’m creating dimension with SSAS 2005 – Business Intelligence Development
Studio. Dimension has attribute hierarchies and user hierarchies.
For attribute hierarchies and user hierarchies I can define my own all
member name ( property AttributeAllMemberName for attribute ...
|
| using OLAP on sql server 2005 | 05 Jan 2008 22:11 GMT | 2 |
I have huge server with lots of data. Approx 500 GB.
In order to let many of my users to make their own statistics I want to set
cubs for them.
I'm new on Analasys services on 2005. On sql server 2000 It was simple to do
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread