| Groups | Blog | Home |
|
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 |
error deploying analysis server cube Posted by Garza_JP at 10/31/2006 9:46:02 AM Has anyone ever received this message before?
"The Description element at line 3123, column 29 (namespace
http://schemas.microsoft.com/analysisservices/2003/engine) cannot appear
under
Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Database/Cubes/Cube/Dimensions/Dimension."
A...more >>
How to find the NULL counts and non NULL counts? Posted by dba_222 NO[at]SPAM yahoo.com at 10/31/2006 6:39:01 AM Dear experts,
I am finding a LOT of rows with NULL columns in the Sybase
tables I'm querying.
Say, there is a table, with 100 rows.
25 rows are NULL
75 rows are NOT NULL.
What I'm trying to eliminate is:
select count(*)
from some_table
where fieldx is null
and then running the ...more >>
DataWarehouse Posted by TBoon at 10/30/2006 10:24:32 PM Hi there,
Let' look at the following scenario:
Database A with a Customer table, PK ID#.
Database B with a Customer table, PK ID#.
Both Database A & B are 2 different system and not related.
However, same Customer may exists in both system.
Now, I would like to create a common Customer...more >>
dwh problem Posted by rufian at 10/24/2006 6:25:23 PM Hi,
I have to choose between
a) using one single fact table
b) using one fact table and several dimension tables
I know that if you have no dimension tables (i.e. you store all the
information on one single fact table) your sql will not include any joins. I
understand joins penalize per...more >>
Using Alerts Posted by somuthomas NO[at]SPAM gmail.com at 10/24/2006 2:53:14 AM I am using SMO 2005 to assign alerts for error number 20574. My doubt
is whether we hav to assign job for the alerts that are created?? And
also will the alerts be generated when the error occurs and the
operators be notified thru email????
Thanks,
Somu
...more >>
Export Cube Structure Posted by Ibon Colias at 10/16/2006 5:37:41 PM Hi all !!
I would like to export a cube from a server to another. I don't need to
export any data, just the structure, fact table and some DTS packages. Any
idea ??
I work with SQL Server 2000 Standard Edition.
Thanks in advance. IBON
...more >>
Capture delta or SQL DML Posted by shahab at 10/16/2006 12:07:02 PM Is it possible to capture delta for a specific table or capture DML statement
executed against a specific table?
thanks...more >>
Advice on database volume Posted by Jerome at 10/15/2006 6:16:01 AM Hi all,
I'm new to datawarehousing. I've built a DW with two fact tables, each one
will be added with more than 5 to 10 millions rows each day. Do you think
that this volume is compatible with Analysis Services 2005 or do I have to
change the model I use, by creating a fact table for each cu...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
VLDB nearing 85% space utilization on underlying drives. Posted by gottaknow at 10/10/2006 1:32:01 PM I need help tracking down some information regarding SQL Server 2000. I have
a VLDB that is at approixmately 85% space utilization on all of its drives.
Is there a recommended threshold where not enough free space is available for
SQL Server to maintain it's performance levels?...more >>
Naming Conventions in Data Warehouse Posted by Corvette1964 at 10/10/2006 3:11:01 AM We're at the beginning of expanding our reporting system into a
datawarehouse. I'm conscious that column names need to be user friendly :
easy to understand and easy to find.
For example to help users find columns alphabetically I could prefix all
Date columns with "Date_" and Revenue with "...more >>
usage of uniqueidentifier as keys fields Posted by .·:m·a·r·l·a:·. at 10/10/2006 12:00:00 AM Hello everyone ::
we would like to ask you a question acording the usage of uniqueidentier as
key fields
we are planning to start designing an application in SQL server which should
have a WEB front end (under .net) and exports of data to other systems
(other SQLs and reporting systems)
...more >>
Data Validation Challenge Posted by Murali at 10/9/2006 10:01:01 PM We have data migration process that transfers around 450 million records from
one DB to Another DB. There is a validation that takes place for the migrated
data that is time consuming (few days). The following validations takes place
on migrated data
NULL check
Length Check
Numeric Precis...more >>
How to create or learn AdventureWorks Data Warehouse Posted by frankie lo at 10/9/2006 12:00:00 AM Would like to learn how to create Data Warehouse. "AdventureWorks Data
Warehouse" sample is great sample. but it seems like that there is no
source/book to show that how to generate it from "AdventureWorks OLTP".
I would like to want to know the "PROCESS" or 'WHY ->>>> design these fact
or ...more >>
Analysis Services 2005 Deployment Wizard Posted by somuthomas NO[at]SPAM gmail.com at 10/7/2006 3:24:57 AM Hi,
I used the deployment wizard in the analysis services 2005 to convert
the cube into XML script. Using the SQL Management Studio I opened it
as Analysis Server scripts and used the local host as the system in the
connections windows then loaded the XML script into the Queries window
as a X...more >>
UBO - Wizard fails because of Group or Order By clause(s) Posted by stevefromoz at 10/6/2006 2:03:48 PM Hi Dev guys,
Have hit a snag trying to use Usage Based Optimization (64bit AS 2K5
install, olapquerylog on SQL2K 32bit). Going through the wizard I can
select the partition(s) I'm interested in applying the aggregation design to
but on the next screen (filter screen for the queries in the ...more >>
Retaining Format in Excel Pivot Table Posted by prabodhjp NO[at]SPAM gmail.com at 10/2/2006 10:49:18 PM I have set formatting of a calculated member in a cube to 'percent'.
When I view the calculated member in an office 2003 pivot table, it
does not apply the formatting defined in the cube. Is there a way I can
get measures to display the format defined in the cube in a pivot
table?
Every time I ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |