|
|
|
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 |
The Problem of Unary Posted by angi at 9/30/2004 10:13:29 AM Hi,
I have a dimension table named "DimAll" in SQL Server as the source of all
of the parent child dimensions.
I defined two members 'X999' and 'Y999' use to be the filters, and use the
column "dim_oper" as customer operator.
So, in Dimension Edit of AS that I enable the Unary Operators.
Whe...more >>
sql 2000 analysis manager Posted by cmato at 9/29/2004 2:09:04 PM I am practicing building cubes with the analysis manager tutorial. I follow
their instructions exactly. Starting from the first tutorial. But I still
get the error "unable to browse dimension "New Dimension". Provider cannot
be found. It may not be properly installed." When I get to the ...more >>
Concept confused... Please help Posted by Ed at 9/29/2004 12:15:04 PM Sorry for this dump question!!!
I am confused with the concept...
I install a SQL Server and Analysis Services at home and I would like to
play around the Analysis Serverices function.
I need to build the datawarehouse on SQL Server and use Analysis Services to
Gerenrate the Queries I want ...more >>
Reporting Database Posted by csl at 9/29/2004 11:48:07 AM We want to create a reporting database from our OLTP database. We are
thinking to take an initial snapshot and then use transactional replication.
However, we also want to keep the OLTP database with only one year of data.
If after one year, we remove records from OLTP, the transactional
replic...more >>
Exportar OWC to Excel Posted by ing_hgonzalez at 9/29/2004 6:51:08 AM some times when exporting a cube of a pagina Web with OWC to Excel, after 5
minutes does not finish and if it finishes not they see the data. That I can
do? thank you very much to help me...more >>
How do I rename an a/s database? Posted by jono at 9/26/2004 7:03:27 PM Hi
Does anyone know if this can be done, and if so how?
Thanks
Jono...more >>
Good Book on Datawarehousing with SqlServer? Posted by Snake at 9/23/2004 3:13:06 PM Can anyone recommend a good book on designing and implementing a data
warehouse using sql server specifically? Not just one in your library, but
one that stands-out?
Thanks,
Michael...more >>
using col_name Posted by vali gheorghiu at 9/23/2004 6:41:05 AM how can i use COL_NAME in where?
SELECT *
FROM table
WHERE COL_NAME(OBJECT_ID('tableTTT'),6)=value_to_compare
the column is int && value_to_compare is same int
in fact COL_NAME(OBJECT_ID('tableTTT'),6) returns just a string with the
col.name && not the value
thx...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Set dimension write-back capability step Posted by Victor Feng at 9/18/2004 10:41:02 PM I am following the tutorial to create a Parent-Child dimension Account. Why
cann't I see the step "Set dimension write-back capability"? I am using SQL
2000 Standard.
Thanks
Vic ...more >>
Master Database Management/Master Data Management Posted by MANDLA MKHWANAZI at 9/17/2004 11:12:55 AM I would like to find out what is Microsoft's Position in terms of Master
Database/Data Management Solutions. I was looking at one article where SAP
talks about Master Data Management and here is what they say :
SAP Master Data Management is the foundation for harmonized, consistent
information...more >>
How to implement OLAP Posted by Bob at 9/16/2004 11:07:27 AM Hi,
I have an SQL Server 7 transaction Database for which I want to implement
OLAP.
I had a play around with OLAP using SQl server 7 but I now wish to give it a
go using an SQL server 2000 platform.
I can't find any mention of OLAP under SQl server 2000.
Questions.
1) Assuming it exists, can...more >>
There is a loop in the schema. Please remove the extra joins Posted by Jean-Gabriel Tourigny at 9/14/2004 10:41:21 AM Hello
I created a cube with 2 Snoflakes dimension. The first
dimension use table A and table B. The second dimension
use table C and table B.
When my both dimesion was created, my fact table is join
to table A. The table A is join with table B. The table
B with table C. And tabl...more >>
Refresh Data In Cube Posted by Yash at 9/9/2004 12:09:01 AM Hi,
How to refresh data for a day in a cube. I want to do this without deleting
the records from the fact tables for the specified day.
--
Regards,
Yash
...more >>
Question about Top-down and Bottom-up approac Posted by Hari at 9/8/2004 11:23:04 PM Hi all
As we all know that there are two approaches of implementing a data
warehouse project. One is the top-down approach where in we create the
central data warehouse first, and then we go about creating different data
marts. Another approach is Bottom-up where in we create individual dat...more >>
Database record disappear Posted by salamol at 9/8/2004 12:20:31 PM I has a strange question.
My company is using a old system with Win NT 4.0 Server + MS SQL 7.0.
The system is busy and handle a lot of SELECTs and INSERTs all the time.
Sometimes, some transactions are blocked by some other transactions.
For those INSERT transactions, we usually call a stored ...more >>
Help - Multi values dimensions ? Posted by r_samir at 9/8/2004 12:19:13 PM Hello all
we developped a software with a data warehouse in sql server, without using
analysis services, and following the star design.
we are working with data about transactions, with caracteristics modeled in
dimensions. in general each transaction has one single value for each
caracter...more >>
Analysis Service Connection Pooling Posted by Manoj at 9/6/2004 4:49:02 AM In SQL Server documentation it is mentioned that the SP3 Code sample contains
the Analysis Service Connection Pooling sample. Please help me in locating
the code sample.
Thanks in advance.
Manoj...more >>
data cleansing and translation tools for relational databases Posted by karenmiddleol NO[at]SPAM yahoo.com at 9/3/2004 10:25:31 PM Hello All
We have a data migration project. This is basically what we plan to
achieve we have a legacy system which as some data with German long
texts like material texts,etc
We want to take data coming in flat files which as this german texts
and convert this to English text the texts are...more >>
2 MSSQL db data integrity concern Posted by Barbean at 9/1/2004 11:32:30 PM Hi all,
I have 2 physical DB with same tables access by different
applications on the internet. Any idea or suggestion in
fullfilling a requirement of data integrity and record
locking mechanism?
thanks
barbean...more >>
MTD Posted by MANDLA MKHWANAZI at 9/1/2004 6:54:45 PM I have created the following calculated member on my cube
Ancestor([Time].CurrentMember, [Time].[Month]), i want to link this to the
measures so that i can give me previous month versus the current months
sales figures, at the moment when i process the cube this member returns
nothing on the cub...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |