all groups > sql server data warehouse > july 2006
MS Analysis service over the web
Posted by msnews.microsoft.com at 7/28/2006 10:35:11 PM
Can I access the MS Analysis service over the web to delivery data to my
customers that use Pivot Excel tables?
RMelo... more >>
excel add-in
Posted by swetha at 7/28/2006 1:59:14 PM
Does the add in for excel work against RS reports?
Does it work against local cube files?
... more >>
Client tools to view cubes
Posted by RMelo at 7/28/2006 12:00:00 AM
Hello!
I'm a new in DW world and I'm searching for tools to my clients view the
cubes generated using SQL 2005.
I already found some good products like "Business Objects" toolset but
the price is inacessible... :-(
The problem to use Excel to visualize the data, for example,... more >>
data ware housing
Posted by vidhya at 7/28/2006 12:00:00 AM
Hai
i have just started to learn about the concepts of dataware housing. i
came to know there are about 5 services in data warehousing.
Namely, 1.Analytical services 2.Integerating services 3 Data Mining 4
Notification services and 5 Reporting services.my doubt i that is there any
order... more >>
offline cube
Posted by swetha at 7/26/2006 9:41:57 AM
Hi
I tried to view the offline cube created through MDX in a system
without Sql server 2005.
The error is that there are no visible tables in the data source.
The .cub works fine in my m/c with excel 2003(I have SS 2005)
So, how do i make it work?
... more >>
fact-less fact table
Posted by vidhya at 7/26/2006 12:00:00 AM
hai
can you get give me some ideas for constructing a fact table for dataware
housing.And also about the different types of measures in the fact table
like full additive measures,semi-additive measures and fact-less fact table
vidhya
... more >>
SQL Server 2005 64 bit Connect to Informix.
Posted by Tam OShanter at 7/25/2006 4:02:01 PM
Hello,
Looking to see if anyone has had any success with 64 bit drivers for
Informix. Specifically, trying to import data into an SQL Server 2005
datawarehouse box with limited success.
Any all responses welcome.
Thx.
Tam.
... more >>
Data Warehousing
Posted by vidhya at 7/24/2006 5:41:09 PM
HAI
i have read about few pages in Microsoft dataware housing toolkit by ralph
kimball.i find it little difficult and vague to understand the concepts.so i
kindly request anybody who have worked with dataware housing to recommened
me a book to get a clear picture to start with and then to ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
datawrehousing
Posted by vidhya at 7/24/2006 11:27:18 AM
hai,
Am using sql server 2005 standard edition ,can you suggest me any book to
get started with data ware housing.
Thank you
... more >>
Create star schema in SQL Server 2005?
Posted by Ronald S. Cook at 7/23/2006 4:55:45 PM
Consider me brand new to data warehousing. I'm looking for a simple,
real-world example taking a simple transactional table, and getting all
"data warehouse" on it.
I know there's a star schema to design, but wouldn't I just do that within a
regular (OLTP) database?
We're looking to get... more >>
unable to deploy analyses services sample project
Posted by julian.kooiker NO[at]SPAM gmail.com at 7/18/2006 2:35:39 AM
I have succesfully followed all the steps in the tutorial, but when I
have to deploy my project I get some error messages:
Error 1 The following system error occurred: Logon failure: unknown
user name or bad password. . 0 0
Error 2 Errors in the high-level relational engine. A connection cou... more >>
Passing strongly typed parameter to MDX to Reporting Services 2005 via URL
Posted by Boby Huntington at 7/17/2006 7:21:21 PM
Hi guys,
We've been developing a BI project with SQL Server RS 2005 and AS 2005.
The problem is client needs to access RS reports through URL.
Things are fine in query analyzer and report manager. However; MDX
queries written by the db team expect strongly typed parameters
(dimension.hirarcy.... more >>
Cube Deploying error in SQL2005
Posted by P at 7/16/2006 2:36:01 PM
Hi All
When I deploy a cube it starts processing then comes up with the error
"connection was either timed out or lost". This also manages to stop the
Analysis Services Service on the Server.
Any ideas?
Thanks
Pete... more >>
Analysis Services Cube using SQL2000 database
Posted by P at 7/12/2006 10:52:01 PM
Hi All
I'm trying to build my first Analysis Services (2005) cube based on fact and
dimension tables on a SQL200 database on a different server.
I'm having problems setting up the data sources - I'm assuming I need two:
one for the source SQL2000 tables and one for the target SQL2005 cube.... more >>
Creating your first data warehouse
Posted by weluvpaul NO[at]SPAM hotmail.com at 7/6/2006 3:12:53 PM
Hello,
I am doing a research project on data warehousing so that I can see
what it can do for my workplace. I have googled on this subject and
the web sites I found relating to this have not been too detailed. I
have a basic set of data and business questions that I want answered
already scop... more >>
SCD component in IS
Posted by Stijn Verrept at 7/1/2006 12:13:27 PM
I have a table that I'm importing with IS and a slowly changing
dimension component. I followed the wizard to say which columns are
historical and which are fixed (I don't have any changing columns).
I have a From and Until column in my destination table so I set those
too in the wizard. I u... more >>
|