|
|
|
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 |
Measure change updates in Fact tables Posted by Conrad at 12/29/2005 8:43:02 PM Is there an industry standard method to populate Fact table columns with the
amount of change of a measure from one row to the next?
I have a FactSubscriptions (1 row = 1 week), and I wold like to have a
column of the price change from the previous week.
I'm wrestling with using tsql to j...more >>
Programatic cube partition creation? Posted by K. Brooks at 12/28/2005 3:15:28 PM How can you programmatically create cube partitions? I have a cube that
is 3.2GB in fact data size and a year should contain about 35GB of fact
data. I would like to partition it into several slices, however I do not
want to create 50 partition through the GUI. Help me please. Thanks.
...more >>
BI Accelerator in Slq Server 2005? Posted by dchaffee NO[at]SPAM chartermi.net at 12/28/2005 8:10:56 AM Has the BI Accelerator tool been dropped from MS or does anyone know of
any plans to "upgrade" this tool to Sql Server 2005? We are working
on a BI project where we would like to use the BI Accelerator to help
generate the schema and data movement and would like to use Reporting
Services as th...more >>
Moving data to data warehouse Posted by KC at 12/21/2005 7:38:02 AM I have data in SQL2000, Access, and MSDE 2000. I am trying to move the data
into a data warehouse (SQL2000). I am thinking of using replication tools to
get the SQL and MSDE data in the warehouse but how do I get the Access data
into the data warehouse? The Access data is limited to the las...more >>
MDX Query Builder Posted by esl at 12/21/2005 6:23:18 AM Hi All,
I'm looking for a tool that would help me to build mdx queries and
display the resulting mdx so I can copy/paste it wherever I want.
The Report Server in SQL Server 2005 does have one but for some reasons
it does not allow generation of matrix result within the request.
For example, is ...more >>
Cube insteadof warehouse Posted by Maryam Arshi via SQLMonster.com at 12/18/2005 10:28:07 AM is cube a Replacement for data warehouse in sql server 2005?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-data-warehouse/200512/1...more >>
Rapidly Changing Dimension Posted by DePuurt at 12/17/2005 1:25:22 PM Hi All,
I'm trying to figure out how I would best model the following situation
:
I'm trying to model a retailing case which is fairly easy except for
one mind boggling thing (at least for me). I'm having a SKU dimension
of around 150.000 unique products which is already a SCD Type 2 for
s...more >>
New at Data Warehousing Posted by Maryam Arshi at 12/17/2005 12:30:14 PM Hi
i'm New at Datawarehousing and sqlserver 2005, i don't know how can i Design
a Data Warehouse based on an Original Relational Database? dows sql server
2005 have a utility to do this?
tnx
Maryam...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Measure with "Distinct Count" Aggregate Function and Null value Posted by Paulo Andre Ortega Ribeiro at 12/15/2005 5:02:39 AM
I Have a cube with many measures. One of them use as "Aggregate
Function" the function "Distinct Count". But some records of fact table
has null value in the field of this measure. In SQL Server, when I
execute a "SELECT COUNT (DISTINCT field)" command, it eliminates the
Null value, as showed ...more >>
Trigger...??? Posted by Richard Oliveira Bento at 12/13/2005 9:27:31 PM Alguem sabe como referenciar uma determinada coluna?=20
Exemplo:
/* Variavel @xCOD */
SET @xCOD =3D nome da coluna <<--- Coluna =E0 ser referenciada...more >>
time stamp magicaly updated when ever update event occures on a row Posted by Daniel at 12/8/2005 3:12:21 PM time stamp magicaly updated when ever update event occures on a row
in sql server 2000 i have a table. when i do any update on the table, a
field of the effected rows gets a new time stamp, there are no triggers on
the table, nothing special in the DDL of the table, is there any other way
bes...more >>
DW design question - Dimension for currency Posted by Bigalexx at 12/7/2005 7:17:44 PM Hi everybody,
I struggle with a DW design issue that I hope somebody can provide a
solution for?
I have a traditional Star Schema, and are building an OLP cube on top. The
development is taken place using SQL Server 2005.
For the purpose of this question, the layout is the follo...more >>
Partition views vs partition tables Posted by jxstern at 12/7/2005 6:29:55 PM I was just going over the new partitioned tables features in SQL2005.
They are very proud of how you can move a partition from one table to
the other and it's just metadata so it happens quickly and
efficiently.
But then it struck me that with partitioned views as in SQL2000, you
put the data...more >>
Loading Lata from Excel spreadsheet Posted by Harsh at 12/6/2005 1:06:05 PM Hi,
I am new to SQL Server and need to load the data from Excel Sheet into a SQL
table? Could anyone please help ?
Thanks
Harsh...more >>
Selecting the same week day a year ago Posted by badlydressedboy at 12/5/2005 3:37:02 AM Hi all,
In a calculated member I need to be ale to select the same day of the week a
year ago as opposed to the same date. For example, if the current day is
wednesday of week 50, 2005, I need to get the wednesday of week 50, 2004.
This means that a -1 parallelPeriod is useless.
I have put...more >>
dimensional modeling Posted by viki at 12/4/2005 2:37:03 AM I need some guideline for designing diemsional model for the situation
given below. Suppose we track individual sales transactions alongwith
different categories of product, areas and employee who made sale.
Sales targets have alreay been assigned to employees for a given time
period eg. quarter...more >>
Horizontal Security in OLAP Cubes Posted by Erdal Akbulut at 12/2/2005 4:42:07 PM Hello,
I have designed a simple Sales cube which has the data of 7 different
companies. The Cube has both sales and cost data.
I want to manage security using Active Directory. I can manage securtiy by
columns for AD accounts, I can hide or show cost data for based on AD
Accounts. Is it poss...more >>
can excel view drill throughs in a pivot table Posted by Andy S. at 12/1/2005 11:24:35 AM I'm building pivot tables in Excel 2000 based on data cubes from SQL 2000
Analysis Services. Is there anyway to view the drill down from the data
fields in a Excel pivot table? I try doubleclicking in a data field cell
and get a message saying that I can only get detail from rows or columns....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |