|
Lost or Missing Records??
Our database is a SQL Server 2000 (sp3). We are
populating the database from transactions on the web which
run through an IPSEC tunnel.
Over the course of several days our counter column on one
of our tables has gaps in the numbering. The gaps stopped
for a few days and then one day started again. Thi ...
Mon, 24 May 2004 08:37:28 -0700
|
Reporting Services Book Available
I would like to introduce you officially to my book "Reporting Services in
Action" and let you know about its availability. I wrote this book for
information workers, system administrators and developers who are planning
to leverage Reporting Services to author, manage and distribute RS-based
reports. It is a s ...
Sun, 23 May 2004 14:52:59 -0400
|
Working with Unicode data
Hello.
I am working at multi-language web site. I need to save Unicode data on my
MS SQL 2000 Data Base. I would like to save data on utf-8 format but on this
case I have a problem with sorting non English records and transferring them
to UPPER case.
Could you suggest any ideas or methods to solve this pr ...
Fri, 21 May 2004 12:59:07 +0300
|
Analysis Services
Hi,
why AS isn't able to browse the data of a cube?
-->Error Messages:
"Unable to browse the cube Sales"
"Unable to locate the cube 'sales'"
Although the cube Sales is manually included in the programm!
A have already installes the SP3a. What is wrong here?
Will be greateful for any help and many thank ...
Wed, 21 May 2003 10:09:37 +0200
|
Need some suggestions...
I need some suggestions on the best way to setup my files for a particular database. I have the following disk configuration available. I'm not a hardware guy, so I don't completely understand Raid configurations, etc. I'm trying to decide what would be the way to set up my indexes & log files (what filegroups, dri ...
Thu, 20 May 2004 16:31:05 -0700
|
Reporting Services Training in DC and NC
Check out http://www.sqlpass.org/community/usergroups/chapter_tour.cfm
PASS is hosting some neat RS training in DC and NC in June
---
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. ...
Thu, 20 May 2004 11:52:55 -0700
|
Restatement: Utility to copy a cube with a new data source?
Does anyone have sample DSO code to copy a cube to a differenct Data Source?
I
am aware of the DSO/XML utility, but have been unsuccessful in using it.
Thanks,
Nate Shedd
...
Thu, 20 May 2004 13:24:56 -0400
|
Operational and Analytical CRM???
Hi,
While going through an article I came across the subject terms and
wanted to ask the experts if these are "basically" the same thing as
"BI" or are these totally different?
I'll appreciate any pointers/help from anyone.
--
Thanks. ...
Thu, 20 May 2004 19:18:30 +0500
|
Trying to get Measure Description
In the cube editor, I can define a description for a measure. When I do
a MDX query and then double click on that measure, I see a description
field, but that field doesn't contain the description I entered in the
cube editor. I then tried adding PROPERTY DESCRIPTION to my mesaues
axes. Now, there is a new ...
Thu, 20 May 2004 09:45:28 -0400
|
Data Type (Time Format)
Hi all,
I have a colume assigned to datetime format, where the value is say
"06:31:31" rather than 20/05/2004 06:31:31. When I retrieve the value from
the table, the result were 30/12/1899 06:31:31. Is there a way to change the
format so that I only need to put the time variable into the field as
opposed to ...
Thu, 20 May 2004 12:55:51 +0100
|
Utility to change Data Source of a cube?
Does anyone have some sample DSO code to change the Data Source of a cube? I
am aware of the DSO/XML utility, but have been unsuccessful in using
it--consumes all available memory on my PC (1Gig of RAM).
Thanks,
Nate Shedd
...
Wed, 19 May 2004 16:58:51 -0400
|
Purpose of BI?
I'm wondering in general about the main purpose of BI. More specifically,
should BI be used only for internal business intelligence, e.g., trends and
analysis for senior managment and marketing, or can it also be appropriately
used for daily operational reports? We have daily/weekly/monthly reports
that need ...
Wed, 19 May 2004 12:10:51 -0700
|
different values between Relational and MOLAP in a sum measure... BUG?
Hello,
I'm working in a Windows 2003 Server, SQL Server 2000 and Analysis Services 2000.
I have created two models in Analysis Services (MOLAP):
- MODEL 1 gets info directly from the relational FACT table: "FCT_SALES"
- MODEL 2 gets info from a view with: "SELECT * FROM FCT_SALES"
FCT_SALES has a measure (sum a ...
Wed, 19 May 2004 09:11:01 -0700
|
SQL Server Accelerator Install Problem
Hi there,
I am trying to install the SQL Server Accelerator trial, but am having problems.
I have installed Office XP and already have the other pre-requisites for it.
The install complains that the version of Excel is not installed, even though Excel 2002 SP1 is definitely installed.
If anyone can be of an6y he ...
Wed, 19 May 2004 07:16:06 -0700
|