NULL values and when to use 'N/A' or not to use
Wed, 30 Apr 2008 13:48:03 -0700
When profiling our data sources - we discover what OLTP sources have what
percentages of NULL values for given columns. My rule of thumb was, if the
% of null values was high - even past 50% - it wasn't too valuable to ETL in
the DW. However when smaller % of values was null, just to 'N/A' the
columns into th ...
|
Memory error reported during scheduled cube process
Mon, 28 Apr 2008 05:39:00 -0700
Hi.
I have a strange issue to my scheduled cube process.
Some days ago my cube process reported an error about missing available
memory "..memory quota estimate (xxMB) exceeds the available system memory
(xyMB).."
After reading some solutions from internet, I changed to False an advanced
parameter named M ...
|
Hierarchies and levels
Thu, 24 Apr 2008 12:44:01 -0700
Hi,
In the SSAS tutorial online Lesson 4, I am not sure what is the major
purpose of creating a "new attribute relationship" in "Dimension Structure
--> Hierarchies and levels"? I understand it is for the sorting purpose if
creating a "new attribute relationship" in the Attributes Pane. Can someone
pl ...
|
Partitioning Child Tables
Thu, 24 Apr 2008 11:16:54 -0700 (PDT)
I have a parent table with a column I want to drive partitioning off,
but the child tables, as you can guess don't have that same
information in them, hence a normalized database :). Is there an
approach to add the same criteria for child tables in the same
partition? The only solution I could come up with is ...
|
Browser error - analysis services tutorial
Sun, 20 Apr 2008 12:50:32 -0700
Hi, folks - I tried this question in the OLAP group without any responses,
so I'm casting my net a little wider in hopes one of you may be able to help
me:
I'm an Analysis Services noob, running the SQL Server 2005 Analysis Services
tutorial for the first time.
In the Visual Studio 2005 IDE, after follo ...
|
restore file/filegroup for partitioned tables
Fri, 18 Apr 2008 14:53:12 -0400
Hi.
Our DB has Primary file group (data and log files are there) where all
lookup are.
has 2 big tables each on own partition (by date) with their indexes.
so
Primary has file xxx_data.mdf and xxx_log.ldf
the 1 big table1 and its indexes are on paritions by year.
data of 1970 on part_1970 filegroup ...
|
Design Question Again.
Thu, 17 Apr 2008 14:08:01 -0700
Hi,
I am a newbie and I have been studying DW for a while and I've
successfully built some cubes.
There is still one thing I am not sure how to design it in the fact table
which is the COUNT. Let's say I have an Order Fact to record the order from
customers. Then I have OrderDate, ShipDate, CancelDate, ...
|
|
|
Incremental cube update with changing data in M2M dimension
Thu, 17 Apr 2008 01:29:07 -0700 (PDT)
Hello,
I have a question about use of many-to-many dimensions. There is a
huge fact table joined to a dimension, and that dimension has a
factless many-to-many table with attributes attached. Question: when
attribues of a dimension record which has been used in the fact table
in the past change, do you have ...
|
Modeling time intervals
Wed, 16 Apr 2008 13:59:00 -0700
Hi,
I am looking into expanding the reporting capabilities for our organization
by doing a data warehouse and using analysis services cubes. I am fairly new
to these concepts but have a solid understanding of OLTP databases. The
first issue I want to tackle is how to model time intervals. The final
resul ...
|
CFP: Data Mining 2008 - submissions until 5 May
Tue, 15 Apr 2008 08:29:11 -0700 (PDT)
Apologies for cross-postings. Please send to interested colleagues and
students
-- CALL FOR PAPERS - Deadline for submissions (extension): 5 May 2008
--
IADIS EUROPEAN CONFERENCE ON DATA MINING 2008
Amsterdam, The Netherlands, 24 to 26 July 2008
(http://www.datamining-conf.org/)
part of the IADIS Multi Co ...
|
