|
|
|
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 |
periodicity Posted by rick at 4/30/2004 10:24:32 AM
Can someone help me with what steps are necessary to build a periodicity
dimension? What source do I use and how does this concept actually work?
...more >>
Programación de copia de seguridad. Posted by Gregorio Marcos Pacheco at 4/27/2004 7:45:59 PM Hola os cuento.
Tengo un Servidor de dominio con W2000 Server.
He montado otro W2000 Server que no está como controlador de dominio. Está
como servidor de aplicaciones. En este servidor necesito entrar con la
cuenta del Administrador del dominio para que la aplicación corra
correctamente. E...more >>
which datatype? Posted by anonymous NO[at]SPAM discussions.microsoft.com at 4/27/2004 8:37:48 AM I want to store a load of numeric value to 2 decimal
places, i.e. 28.65
I have been reading my SQL server guide, trying to decide
on the best datatype to use, but I have just got more
confused...
Can someone tell me which to use...
decimal, float, real, money, small money or numeric?
...more >>
VB 6 ADO vs Microsoft Query Analyzer Posted by Maurice Boers at 4/26/2004 3:51:02 PM Hello
I have a sql update statement thats quite large with several "select nests".
It generally takes an hour to run when I need to effect a lot of records.
In VB6 using ADO, I issue the statement and sometimes the update doesn't
actually preform the write (I think when I get over a certain ...more >>
need help with msmdarch Posted by Zachary M.C. Harris at 4/24/2004 3:49:37 PM I am trying to handle some code using msmdarch and keep getting an error
exec xp_cmdshell "cd C:\Program Files\Microsoft Analysis
Services\Bin\msmdarch.exe" /a zacwin2k "C:\Program Files\Microsoft Analysis
Services\Data\" "FoodMart 2000" "C:\FoodMart.cab"
Incorrect syntax near '/'
need ...more >>
Cannot connect to MSOLAP Provider Posted by qtao NO[at]SPAM doe.k12.de.us at 4/23/2004 11:05:09 AM I could not get my ASP pages to connect to the Analysis services
Server on a different box. The code that is not working is:
Dim cat
Set cat = Server.CreateObject("ADOMD.Catalog")
cat.ActiveConnection = "Data Source=asServer;Initial
Catalog=MyMart;Provider=msolap;"
My environment is:
The w...more >>
ELSE CONDITION IN MDX Posted by Luis Chiappara at 4/23/2004 10:32:58 AM
Hi, I'll appreciate your help to solve my develop problem.
I need to use a conditional expresion to assign a calculated member
value to cube members. I can't use the IIF function because I have 3
possible values (eg A,B,C). How can I implement the "ELSE" condition? In
pseudocode y say:
if x...more >>
Partioning a table Posted by jglickma at 4/21/2004 1:04:47 PM How do you partion a fact table in SQL server, it appears from
the documentation one would have to treat it as a
cube or even have to make a cube out of the fact.
Lets say I a huge table and I would like to partion
it for performance reasons without involving cubes
can that be done. Hate to me...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Newbie : Wharehousing Basic Question under SQL Server Posted by Hi,
Currently, I'm working on a SQL Server DWH.
I work on a snowflake Schema. Let say that I've on product table wich is
linked using a FK on a product grouping key to a product group label.
If I update my product refrential, this works but ...
in the real life, if a new product appears and ...more >>
# of Tables in a DB Posted by Caretaker at 4/20/2004 6:46:10 AM If I want to build an architected data warehouse, otherwise known as a star constellation of multiple facts and conformed dimensions, I'm trying to figure out how to separate the physical tables by database. Think about modeling the constellation in ERwin. You want to have mutiple fact tables with...more >>
Calculations involving NULLs Posted by Jeremy McMahan at 4/16/2004 12:56:12 PM I have a Calulated Member that is calculating an average.
[Measures].[Overall Satisfaction]/[Measures].[Count Of Survey]
The problem is that for some of the items there are no surveys, so there are
NULL values in the database for these.
When I view the cube as a pivot table in Excel I am g...more >>
large datawareouse - general advice needed Posted by Frank Spencer at 4/16/2004 4:16:02 AM Hi
we're considering implementing a datawarehouse with 100GB data and really need some general help
(1) has anyone heard of a well-known AS datawarehouse having a similar/bigger quantity of info (we need to allay management fears)
(2) what are any recommendations for hardware optimisation.
TIA...more >>
Dimension or Fact? Posted by groove_sf at 4/15/2004 9:57:46 PM Hi - I've got a dimensional modelling question that's got me stuck.
I have a "Student" entity and a "Student Transaction" entity.
The Student Transaction table will be a fact table -- that's easy.
And the Student will be a dimension of the Student Transaction table.
HOWEVER, the Studen...more >>
optimizing MDX?? Posted by rick at 4/15/2004 2:47:45 PM Has anyone any knowledge of optimizing MDX?
I have several MDX queries I have inherited, which take (some) in excess of
a minute to return.
I have been through Spofford's book and others. None seem to address a best
practices approach.
Any suggestions.
Thank you
...more >>
I need a calculated parent with 2 calculated childs!!! Posted by Agustin at 4/15/2004 6:01:10 AM I want to build a strcuture like this!!
Dimension Name
!_Calculated Parent
!_Calculated Children
!_Calculated Children
Ex
WIT
MEMBER [Measures].[C...more >>
use views for extending fact tables? Posted by wg at 4/14/2004 2:01:58 PM hi,
i'm wondering if it's an acceptable practice to use views to extend fact
tables in the warehouse. e.g., if you have an existing fact table, and
for some subset of the data in that fact table you'd like to add new
measures, etc., would it be better to create a new fact table containing ...more >>
Semiadditive dimensions / measures Posted by Cesar Luna at 4/13/2004 11:46:04 AM Hello there
The "issue", that I have, is that the OLAP server sums every measure regardless the type of dimension. For example, suppose that I have a fact table which loads every Friday the account balance for the customers. And for example the account balance is not additive by time as if I cut t...more >>
Data Load Posted by MS User at 4/13/2004 11:37:23 AM SQL 2K
We have a data-warehouse server which loads data from different databases
which resides in a different server, perform business logic and load into a
FACT table.
I created 4 SQL jobs which does the above same thing from different
databases and writing to same table.
This job is schedu...more >>
Non empty for calculated members Posted by T. Gylver at 4/13/2004 5:46:02 AM I have a cube with a calculated member The calculation for the calculated member "MyMembers" is a simple addition
[Measures].[NoOfOwners] + [Measures].[NoOfUsers
In the MDX select statment I use the "non empty" expression on both columns and rows. My MDX query goes like this
SELECT
non empty {...more >>
MSSQLOLAP Service stuck in a loop Posted by Lakshman at 4/12/2004 3:05:20 PM Hi
I had installed the SP3a patch for Analysis Services.
Everything was working fine for a day and then now when I
try restarting the MSSQLOLAPService it gets into a loop
and automatically gets restarted again and again.
I am not very sure whether this is because of the SP3a
installa...more >>
Need help with my concepts - Question for experts Posted by Learner at 4/11/2004 1:11:30 PM I have learned how to transfer data from my OLTP database into a
different database, learned and have ensured that the data has been
'scrubbed', have created tables which I plan to use for my dimensions
and fact(s) and and eventually successfully created cubes using Analysis
services.... I s...more >>
Deleting Model, MSDBData, Master Databases Posted by Carl at 4/7/2004 12:30:18 PM Can I safely remove the model, msdbdata and/or the master
databases from SQL2000 (they may actually have been from
SQL7) without affecting the program operation and
population? I am incredibly low on storage (that is whole
other subject) and have already removed the northwind
database. T...more >>
ETL system Posted by Wolverine at 4/6/2004 4:18:21 PM I want to move 42M rows of data from one OLTP SQL2K DB to a SQL2K data mart.
Would DTS be faster than a straight INSERT statement where the source is in
a different server than the destination?
Additional facts:
* The recovery model for the destination DB is set to "Simple".
* Servers are in ...more >>
Calculating a "running sum" within a year Posted by MrIgel NO[at]SPAM gmx.de at 4/6/2004 8:08:31 AM We have a proble within a cube measure. We ant to design acube
containing something like a "running sum". I am quoting this, beacause
i didn´t fin any similar expression for this.
So, if the column "Sum" is the expression we wanted, we want to get
this
result in the cube. (TIme is a dimension...more >>
reading matter Posted by ChrisB at 4/4/2004 1:26:03 PM Can anyone recommend some good reading on Datawarehousing theory ?...more >>
Stored procedures Posted by Chris at 4/2/2004 7:17:10 PM Hi,
I have a stored procedure and one of the parameters is of format
smalldatetime.
What is the format of the parameter when I call the SP ?
CREATE PROCEDURE sp_My_Insert
@org int,
@aDate smalldatetime,
AS
INSERT INTO MyTable(Org, ADate)
VALUES (@org, @aDate)
GO
How do I call this S...more >>
1-to-1 table relationships Posted by Jim Fidler at 4/1/2004 11:30:34 AM I want set a 1-to-1 relationship between two tables in a
diagram. The master table's (main)link field is a PK
(HQID). The second table (table2) has a PK (tbl2_id) and
a field (HQID2). I want a 1-to-1 between main.hqid to
table2.hqid2. How do I set table2.hqid2 to require unque
values?...more >>
what's wrong in partitioned views Posted by Snoopy at 4/1/2004 12:46:08 AM Hi,
here is my problem, I try to insert values in a partitioned view and it does not work! Please Help :
CREATE TABLE Mai1998Sale
(OrderID INT PRIMARY KEY
CustomerID INT NOT NULL
OrderDate DATETIME NUL
CHECK (DATEPART(yy, OrderDate) = 1998)
Or...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |