|
|
|
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 |
Filter by week: 1 2 3 4 5 Including non-hierarchial date information Posted by Mike Austin at 10/31/2003 2:19:48 PM My date dimension has many columns that are either not
hierarchical or do not fit into the day/month/quarter/year
hierarchy. For example, I have several flags, for example,
weekday, and day of week text, fiscal quarters, etc. Is
there some way to make these columns available to users?
TIA...more >>
Dimension too large error Posted by Mike Austin at 10/29/2003 11:55:49 AM I am creating a number of data marts that will be using
conformed dimensions (I hope). I have a slowly-changing
account dimension that will have 100 million+ rows in it.
However, some of my data marts have only 65,000 rows. When
I run the storage wizard, I receive an error that the
64,000 ...more >>
Data Junction / VB Developers Contracts in GA Posted by Denise Pratt at 10/29/2003 11:44:05 AM Seeking several Data Junction / VB Developers for 3 month contract with
possible renewal in Alpharetta, GA.
These opportunities require 3-5 years development experience with Data
Junction, Visual Basic (VB6) and SQL2000. Must be US Citizen or US
Permanent Resident. No 3rd Parties. Healthcare...more >>
How to integrate 2 dimensions in a virtual cube Posted by Charles at 10/28/2003 6:57:13 PM I am a beginner of using Analysis Service. I used the
Cognos PowerPlay previously. I prepared two cubes with
similar dimensions (like Location_1 and Location_2). How
can I merge these two dimensions into one so that my users
can browse the virtual cubes (maybe in web access) just
through a...more >>
datawarehouse Posted by *kersob* at 10/28/2003 4:36:26 PM Our customer is using CS2k 2000 with sp3.
He has re-installed a new Olap Server and re-created a new Data WareHouse
resource..
now the DataWarehouse is empty.
He wishes to reattach the old DataWarehouse DB (about 10GB) for recovery the
old data. Is this possible?
If no, what is the best pr...more >>
Invalid Datetime Posted by Henry Jartu at 10/28/2003 11:03:15 AM Somehow primary constraint was violated as group by
clause to eliminate dupplicates does not catch the
invalid date until attempt to insert data into
destination table:
Where clause produces the dupplicate row
"CONVERT(VARCHAR(50),sales_dt,101) = '10/23/2003'" but I
am unable to see the du...more >>
Datawharehouse loading methods. Whats best? Posted by Michael Polombo at 10/27/2003 11:58:00 AM In the event a you need to view data from an OLTP database with no(or very
little) latency and the aggregations from the normalized structure make it
impractical to do this without loading into a datawarehouse what is the best
load solution?
i.e. replication, job that runs every minute.
I w...more >>
URGENT: recovering or re-formatting *.BAK file Posted by AT at 10/27/2003 5:46:56 AM Hello; what process do i utilize in order to recover or re-
format a backup SQL Database file with the (*.BAK)
extension.
Thank you in advance
AT
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Mapping Table / Procedure dependencies in sql2k? Posted by Nick at 10/24/2003 7:26:07 AM Dear all,
I need to map the procedure and table dependecies in our
data warehouse running on SQL2K.
The system is partitioned in 3 databases (Staging +
Normalised + Dimensional (Fact)) and every table have one
or more corresponding SP's that load/update it.
I have sofar found depende...more >>
Storage Design Wizard and Aggregations Posted by Asa Monsey at 10/23/2003 12:23:11 PM I have a cube with 29 shared and private dimensions.
Several of the dimensions have multiple hierarchies.
When I run the storage design wizard, I chose MOLAP as my
storage option, and I move to the aggregation wizard.
I select stop when the performance improvement reaches
50%, and hit...more >>
URGENT: Is it possible to use a view as a fact table in Analysis Services?? Posted by Nelson Lainez at 10/22/2003 10:54:02 PM Hi,
Is it possible to use a VIEW as a FACT TABLE in Analysis Services?
If the answer is YES, how do I select it, because the table list in cube &
dimension editor doesn't list the views, just tables.
I need that because I want to UNION two tables in a View, then use
it as the fact table in a ...more >>
Scripting out cubes Posted by Jono at 10/22/2003 5:51:17 PM Hi
Does anyone know if there is a way to script out a cube?
In SQL EM, you can generate a script from just about any
object but I can't seem to find out how to do it from the
Analysis Services Manager. Can it be done?
Thanks
Jono...more >>
BI Accelerator and Office 2003 Posted by Paulo Pega at 10/22/2003 6:58:34 AM Is SQL Server Accelerated for BI incompatible with Office=20
2003.=20
After i install Office 2003, When i open Analytics Builder=20
Workbook it gives me a message saying that "... requires=20
Excel XP, SP1 or greater".=20
Because Analytics Builder Workbook its protected with a=20
password i do...more >>
Call a stored procedure from another Posted by Boni at 10/21/2003 12:17:02 PM I'm sorry for my english!!!
I have 2 stored procedure.
The first accept a Input Var, this is a Id from a Table. My first stored
procedure check if exist the Id and return the value for another field, else
return a string "not present"
My second stored procedure return a list from another ...more >>
Rebuilding indices of a SQL Server 2000 DB Posted by Jean-Marc Filiatrault at 10/20/2003 1:16:21 PM What is the recommended frequency for the rebuilding of
the indices of a SQL 2000 production DB to ensure
responsiveness of the DB?...more >>
How to check SQL database size? Posted by Mirko at 10/20/2003 6:45:48 AM How to check SQL 2K SP3 database size? How much space is
SQL database taking from the disk.
Please help.
Thanks in advance. Mirko...more >>
Populating Datawarehouse Posted by Gil at 10/18/2003 11:46:27 AM Hi,
What information do you have for populating the data warehouse ( With ETL
tools ) ?
Where can I find books/e-books or any web site about the Subject?
Thanks.
...more >>
SQL 2000 - convert local time to GMT Posted by apm at 10/17/2003 5:52:43 PM I'm working with SQL 2000. The database server is located
in the Pacific Time zone. Data will to be collected from
other time zones (CT, MT, ET, etc.). Is there a stored
procedure that can convert the time stamp on the data
retrieved from the time zones into GMT?
Thank you in advance. ...more >>
Eng ver support chinese char ?? Posted by Sunny at 10/17/2003 1:00:07 AM Hi,
My company are using SQL Server 2000 Eng ver, but I need
to store chinese char data on the server, what things I
need to do or upgrade ??
Thanks a lot !!
Sunny
...more >>
SQL databases on NAS Posted by Eric Piersol at 10/15/2003 8:38:29 AM I am trying to find out how to configure a SQL 2000
server to be able to store and access databases on NAS or
a mapped drive that physically exists elsewhere on the
network. The knowldege base is not much help. Can anyone
help me here?...more >>
shrink database files and log files Posted by JJ Wang at 10/14/2003 4:42:29 PM Hi
is this a good practice if I shrink the database files and
its log files after each day's full backup? Is this a
good practice for data warehouse databases?
many thanks.
JJ...more >>
Reporting Services Posted by Mark at 10/14/2003 11:21:50 AM Does anyone know how SQL Server Reporting Services will be
delivered? Recently released white papers indicate it is
a component of SQL Server. Wondering if I should delay my
SQL Server purchase until it is available or if I'll be
able to get a download later...
...more >>
local packages Posted by killer at 10/10/2003 10:56:11 AM How can I export in one other server my local packages?(and scheduled job)
DTS go only for the objects in a database?
...more >>
"what-if" add-in Posted by carlos O at 10/9/2003 5:24:57 PM Anyone know if exist an excel-addin for an "what-if" analysis type.
My client need something like that, but i don't know what exactly is it.
In the sql server documentation is mentioned, but i don't find more than 3
lines of explanation.
Help
Thanks in advance
Carlos Ortiz.
...more >>
READ_UNCOMMITTED and view indexes Posted by Terris Linenbach at 10/8/2003 5:14:52 PM Let's say all of my report queries use READ_UNCOMMITTED in order to avoid
deadlocking with load processes. The queries select from views which have
indexes.
Now suppose a query is running while a nightly load operation is running.
The nightly load operation inserts additional records into the...more >>
SQL2K - Data mining - Clasification Tree Posted by Iks at 10/7/2003 4:09:25 PM Hi,
I tried to use sql2k mining model - clasification tree.
Result - graphical tree with lot of nodes/leafs (it is ok),
each has condition, predicted value of dependent variable etc.
Base on this result I would like to create SQL code to classify
each record in learning table and other tabl...more >>
Handling Dimensions having more than 64000 children Posted by Satish Sainath at 10/6/2003 5:08:05 PM Hello all,
I have a dimesnion with two Levels
Country
CustomerId
For one country the number of customer Id exceeds 64000 . So the dimension
fails to build
I Changed the registry settings
of VLDMThreshold to 1000000 (1million) and VLDMShmSize to 10 million. I
rebooted the system and when ...more >>
schedule job Posted by MANDLA MKHWANAZI at 10/1/2003 4:52:40 PM How can i create a stored procedure that runs a sql schedule or update the
date and time for a schedule job.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |