Hi Friends,
Any recommendation for DW and BI books ?
Thanks,
Pat

Is anybody using the Excel 2007 version of the data mining add-in with
Excel 2010 successfully yet?  From what I can fathom out there is no
2010 version yet.
There doesn't appear to be any information on setting this up for 2010

** Apologies for cross-postings. Please send to interested colleagues
and students **
-- CALL FOR PAPERS - Deadline for submissions (last call): 3 September
2010 --

Apologies for cross-postings. Please send to interested colleagues and
students
-- CALL FOR PAPERS - Deadline for submissions (last call): 3 September
2010 --

Apologies for cross-postings. Please send to interested colleagues and
students
-- CALL FOR PAPERS - Deadline for submissions (2nd call): 6 September
2010 --

What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
Why?

I am running AS2008 on Windows7. Each time, when i execute an MDX query, my
perfmon is always equal to 0.
Any Idea ?
Thanks

I am using the Microsoft.AnalysisServices DLL to access my Cubes KPIs. From here I can set a Value, Goal etc.
What I am trying to do now is apply a filter to the KPI, for example all values for the year 2004 and the manufacturer 'Good Year'.
From BIDS I can do this from the browser ...

Hai
Learn TIBCO and  via video tutorials,contact
http://tibcovideotutorial.webs.com/
PLEASE PASS IT YOUR FRIENDS

Hello, after I formulate an mdx script that returns the results I want from
the cube using the SSMS, what is the process for getting the results to a
table in SQL server?
I would like to run the mdx code using SQL Agent, and then have the results

I have a client that is getting the error "Unable to prepare the SSIS bulk
insert for data insertion".  The Sql Server is the same server as the SSIS
package and I have
changed my connection type from SQL Server to OLE DB with still get the

What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
Why?

I have a web report that I can access from a URL. The web report
displays the following values on the web page:
Minimum   Maximum Value
10                1000      920

I want to export data from SQL server 2000 to text file. I am using Transform Data Task for the same
I am facing peiculiar problem in exporting columns which have 'bit' data type. In text files, the values for these columns appear as True/False instead of 1/0
How can I ensure ...

I need to write a script task to check if there is any file exists in c:\test
folder.
If there is a file, then return a failure.  If there is no file, then return
a success.  The file in that particular folder could be with any name.

I get this error from sql server 2005 developer edition on  windows.  I ca't
seem to get any connection to work sqlnative client og file connection. I
have installed all features from the sql developer dvd.
* The connection "SourceConnectionOLEDB" is not found. This error is ...

I need to use SSIS Package to parse an XML file and pass the xml data to a
stored procedure parameter.
Example:
<Xml>

I have SQL Server 2008 and I am running a job.  The job says everything was
fine and it was successful, but the job didn't run.  The job runs an SSIS
package.
I have an SSIS package that executes a .bat file. When I execute the package

I am new to SSIS and I need to query a list of tables from a table. Then from
that list create a CSV file from each table in the list. So far I was able to
do this for only one table by creating a Data Flow Task, then an OLE DB
source with data access mode Table or View and a ...

What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
Why?

How can i delete a transaction log file in sql server 2005
I need to delete an old and big file and create a new one with default size
Thanks
SA

hi I have a string of jobs that execute in sequence. From time to time I will
find my SQL server  unresopnsive. Screen saver frozen,  no reponse with
keyboard/mouse.
I have been forced to use power button to restart the server.

In short, "Dynamic MDX Queries" don’t work as described in the BOL.
I’ve lifted the sample code directly, tried to run it, and it fails.
It’s documented at http://msdn.microsoft.com/en-us/library/ms172589(SQL.90).aspx
The “Analysis Services Event Provider” queries a SQL table, ...

doesn't look like too many members or lots of activity.  Is this an
active group?

Hi, everyone.  I'm embarassed to admit that I set up a SQLNS app some
time ago, and it's been so long since I worked with it that I'm at a
loss for where to start troubleshooting.
A SQLNS server that I work with is experiencing an inordinately high

I have a report that has 2 groups. The first group Company, I get a page break, so between each company there is a break. I did not specify any page breaks for any group or the report.The second group is policy type and there are no page breaks, multiple policy types show up on a ...

Hi,
  We have a report server running. Unfortunately the people who were
here before us spent as little as possible on any software purchase.
As a result we have sql server standard 2005 and can't do table based

I have been working on this for over a month and have seen many
requests for help on this. Classic asp does not support SOAP. The soap
toolkit 3.0 keep passing invalid parameters to RS2k5. The best way I
have found to access some aspects of reporting service without

A couple of days ago, I asked about changing the Reporting Services web page.
I asked about changing the "SQL Server Reporting Services" text, and
including a company logo where the folder icon now resides. I got a response
that I could change the text by clicking the Site ...

I have a header and footer in the RDL file in SSRS 2005. They contain
a horizontal line.
The page body has a table. The visibility of its columns is controlled
dynamically based on parameters.