|
|
|
January 2003 March 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
beginner Analysis Services question Posted by Jack Vamvas at 4/28/2006 4:41:57 PM I'm looking into learning how to use Analysis Services- the problem , (for
learning purposes) I have set up is 1,000,000 rercords , which are made up
of opinions about various topics . It is one column , with up to 1000
length.
Does Analysis Services posess algorithms that will estimate , for e...more >>
Processing cube error Posted by beatmasta at 4/24/2006 2:39:02 AM Hi,
I have a small problem when trying to process the cubes in AS. We have a
datawarehouse and have done couple of cubes also. In the beginning the cubes
processed fine, but after a while I have begin to get lots of errors. The
error message is "The attribute key cannot be foun. The record wa...more >>
Relation between datawarehousing and OLAP Posted by Tor BÃ¥dshaug at 4/23/2006 2:56:02 PM I am currently looking to get some insight into the BI-world (in the context
of SQL Server), and I find the distinction between datawarehousing and OLAP
somewhat vague.
My say would be that OLAP could be a part of a data warehouse, but it is not
clear to me where the between the two is to be...more >>
Using Fuzzy Logic From SQL or API Posted by tronn at 4/19/2006 2:44:03 AM We were hoping to use fuzzy logic transformation in a non-data warehouse
application where user of one application search for an address match in
another app. Is it possible to access fuzzy logic functionality through
T-SQL or through an API?
Thanks
T...more >>
SQL Server 2000 AS cubes Posted by Sonya at 4/17/2006 6:02:02 PM Does anyone know if you can exclude tables from a cube in the Analysis Server?
Meaning, when creating a cube off of a database and you do not want to
include all the DB tables, how can you exclude them?
Thanks...more >>
Performance Posted by Josema at 4/17/2006 6:08:02 AM Is there any difference between:
executing 2 queries in the same database at the same time
or
Executing 2 queries in 2 different databases at the same time
The same conditions for the 2 databases (same query, tables, indexes).
The concrete question is: is there any performance advantages i...more >>
"Stored Procedure" working every 5 minute, how? Posted by Tark Siala at 4/13/2006 7:59:41 PM hi
i working on SQL2000, and want to make "Stored Procedure" that's working
every 5 mibute, without making any calling.
how i can make that ?
--
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: ...more >>
# of files in group, CPU, and RAID Posted by Brian Shelden at 4/12/2006 9:33:02 AM Not sure if this is the right forum...
I have a fact table that ha sits own filegroup on a dedicated RAID 10 array.
Somewhere in Books Online I read that you should create a file in the
filegroup for each CPU in the server. My understanding is that in SQL 2000,
this triggered the server to ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
user security on dimension data for Analysis Services 2005 Posted by Joe at 4/10/2006 4:51:52 PM Hi -
I am using roles in a cube to limit what data a user can see. When I go into
the cube browser and select the "change user" option and select a specific
role, the security works fine. However, when I log in as a user that is
clearly defined under that role, it doesn't take effect. Has a...more >>
Drillthrough Posted by Immy at 4/10/2006 3:11:41 PM Hi all,
I'm new to OLAP and especially drillthrough and just have a question about
the way it works.
I can see clearly why the process exists and the complete benefits of it,
but correct me if i'm wrong but:
1. It appears to issue an SQL query against the data source to return the
informat...more >>
Progress v9.1C database connection for SQL Server 2005 ETL-tool Posted by plupos at 4/10/2006 2:44:01 AM Hello,
I'm evaluation SQL Server 2005 to use it as an ETL-tool. We need to connect
to a Progress v9.1C database as datasource. SQL Server 2005 operates on the
..NET platform, I'm not aible to connect to progress from the datasource tab
in the ETL-tool part of SQL Server 2005 (there is no A...more >>
Re: Data Warehousing Posted by Michael at 4/5/2006 7:12:42 PM Hey Everyone,
I have both SQL 2000 and SQL 2005 Standard, I was wondering how tough
it would be to offer data warehousing I have an OC12 backbone and I am on a
t1 burstable so bandwidth would not be a problem, Where would I start if I
wanted to do something like this? Also what would b...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |