|
|
|
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 |
Filter by week: 1 2 3 4 5 XML-load via DTS..? Posted by Kent Johnson at 10/31/2004 6:55:52 PM Hi all,
I have tried to load the below data into a SQL-table using a DTS-active
script package.
The data:
================================
<?xml version="1.0" encoding="iso-8859-1" ?>
<BusinessPartners_Update>
<Body>
<BusinessPartner>
<Customer>
<BusinessPartnerNumber>001</BusinessPartnerN...more >>
How to manage cube by program Posted by ad at 10/31/2004 10:14:03 AM Can we used codes Visual.dot to manage cube?
...more >>
SSABI: SCD insert or update behaviour Posted by Eugene Frolov at 10/29/2004 10:21:28 AM Hi, All!
I need to help on this problem:
there is a dimension table with this structure in the Staging DB -
Customer_Code nvarchar(50)
Customer_Name nvarchar(50)
SalesPerson_Code nvarchar(50)
Lets imagine I'm having customer record like this:
123 'Horns and hoofs In...more >>
SQL JOB Posted by MS User at 10/27/2004 12:25:54 PM SQL 2K
I got a SQL job which executes a storedprocedure ,which populates data for a
data warehousing application.
Each day my job execution time increases, but the underlying table from
where it reads and populates doesn't increase too much.
Any specific performance monitoring step to loo...more >>
Clustered Indexes Posted by anonymous NO[at]SPAM discussions.microsoft.com at 10/26/2004 5:57:59 PM I just gone through a datawarehouse CD seminar for SQL2K
but a little confused on something. The author said not
to use clustered indexes with star/snowflake schemas. Is
there a reason for this? The author never explained why
we should not use clustered indexes in a datawarehouse.
Does...more >>
BI Accelerator: problem with current day setting Posted by Eugene Frolov at 10/26/2004 3:45:42 PM Hi, All!
I'm experimenting with MSSABI and look this problem - after running
SetCurentDay.dts package every measure values mutiplied by 6.
Here is my steps:
1. Create Analytical, SM and staging databeses with Analytics builder
utility for SMA template (unmodified).
2. Manualy run Master I...more >>
Can't connect to / see cube Posted by Kaisa at 10/25/2004 6:10:49 AM Need some input please.
I have a development domain, with one server running SQL Server 2000 sp
3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
REporting Services.
I used to be able to connect to my databases in Analysis Services, but
today I updated one of them, and now I...more >>
Reloading Cube Data Posted by Yash at 10/25/2004 12:47:02 AM Hi,
Is there anyway to reload data for a specific day by clearing the existing
data.
I need to reload data for a specific day by clearing the existing day data
in the cube. Full process or refresh is time consuming until I increase the
number of partitions. If I perform an incremental update...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Slow Aggregations Designer Posted by Yash at 10/23/2004 4:25:02 AM Hi,
Any hints why the aggregation designer will be slow.
Many Thanks.
--
Regards,
Yash
...more >>
SSL forced encription will not work under a Domain User account Posted by Jason Robertson at 10/22/2004 2:50:19 PM Hi,
I have set up an Active Directory, Certificate Services on Windows 2003
Server. I am running SQL 2000 Server. AD and Certificate Services were
installed correctly.
My goal is to be able to use SSL when connecting to SQL Server via Query
Analyzer. I also want to keep the SQL Server insta...more >>
Identity Column Increment Control Posted by Derek Shi at 10/22/2004 1:08:54 PM Hi,
I have a table with identity column. I set the increment
to 1. But after I have deleted a couple of rows then
inserted a new row, the increment is not based on the
existing row number. For example, I had 100 rows already.
After I deleted two rows from the bottom., the last row I
hav...more >>
Analysis Services Cube Editor Posted by Homer at 10/22/2004 11:19:02 AM How does one create outer joins in the cube editor. The documentation states
that by default only inner joins are created and to use Visual Database Tools
( a Visual Studio module). Any workarounds for this?
thanks in advance...more >>
Disadvantages in using cube partitions Posted by anonymous red at 10/22/2004 6:13:40 AM Hello,
Could anyone tell me if there are any disadvantages in using partitions
in cubes ?
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
BI Accelerator: multiply source databeses Posted by Eugene Frolov at 10/20/2004 11:21:59 AM Hi All!
I'm trying to use MS BI Accelerator for creating DW which must contain data
from different sources. Every source is our company departmnet standard
database. I'm looking for best practice for collecting fact and dim data
from this databases in BI Acc staging database, i.e. creating So...more >>
again and again... query analyzer and wrong SQL statement plan... + outer join? Posted by Jéjé at 10/19/2004 4:51:14 PM Hi,
again we have some SQL statement performance problems...
I've 2 table with 140 000 records each.
I join the 2 tables and the result is also 140 000, but the query analyzer
estimate 1000 rows only.
Its a simple join with 5 equals in the join
select * from tableA inner join table B on ...more >>
running ETL and want to report on same table Posted by rpmfantasy NO[at]SPAM yahoo.com at 10/19/2004 12:30:34 PM We are in a typical data warehouse environment where we are running
ETL on a set of tables that are loaded nightly. The same set of tables
are then used to process OLAP cubes (everything is on SQL Server 2000
EE/Analysis Services). Along with cubes, those tables are also used
for operational rep...more >>
Best method to transfer data Posted by dcomcnfg NO[at]SPAM hotmail.com at 10/18/2004 9:58:32 AM Hi Group,
I just started at a company and am trying to come up with a solution
to streamline the datawarehouse.
The problem is, we have two databases. Database1 (548 tables) is
generated from user input and we cannot control the schema. Database2
(40 tables) is a staging DB that optimally...more >>
Insert Script Posted by Filippo Bettinaglio at 10/18/2004 5:47:00 AM
Hi,
I have a table with some data in it, I would like to
generate one Insert script command for each record.
Is there a SQL Server tools for doing it?
I mean, this is my table:
NamesTbl
Name Surname
-------------------------------------
Filippo Bettinaglio
John G...more >>
SORT_IN_TEMPDB not use tempdb??? Posted by Jéjé at 10/17/2004 8:29:51 PM Hi,
I've an index to create around a table with 3millions of rows.
my tempdb database is on a different set of disks, so I use the
SORT_IN_TEMPDB when I recreate my index, but I don't see any activity around
the tempdb database and the time to create the index is the same!
any idea?
th...more >>
DTS Package: Data Loading ?? Posted by Steve at 10/17/2004 6:31:02 PM Hi,
Can someone help me with the following
I have to automate the process of loading the files from source to target.
I have to use partitioned tables which should be created automatically to
load the data. These tables should have different name each week(for e.g
customers40, customers4...more >>
Virtual Dimension? Posted by ad at 10/16/2004 6:55:58 PM What is the difference between dimension and Virtual Dimension which make by
column of table?
...more >>
ETL tool recommendations Posted by jhkh jh at 10/16/2004 8:29:14 AM Currently evaluating ETL tools to replace hand coded sql at 10 datamart
installations. Each installation requires custom code and complex
transforms involving deleting records, updating fields,changing
associations betweeen parent and child records, etc. Anyone have
experience besides usin...more >>
tempdb Posted by Randy at 10/15/2004 12:13:10 PM Is there a way to monitor spikes in temp db usage by process ID? I am
hoping for some kind of code.
Also, would someone have a list or send a link that programmers can follow
to minimize the use of tempDb and its transaction log file.
Regards,
Randy...more >>
Two measure values with different level depth. Posted by ad at 10/14/2004 10:37:30 PM Two measure values with different level depth.
I have a table which record the disease student number with different
disease in every grade of different gender in a school, like below
Grade, Gender, Disease, [Disease Student number]
-------------------------------------------------...more >>
How to generate ranking information Posted by Derek Shi at 10/13/2004 5:27:37 PM Hi guys,
I am trying to figure out how to display ranking
information for sales on SQL Server: for example, I want
to display the No.2 and No.3 most sold products in a day
from a Sales Table (product_id, sales, Date). Can anyone
provide most efficient way to achieve that assuming there
...more >>
How to get the first date Posted by ad at 10/13/2004 12:20:18 PM I have a time dimention of Year, Month and Date
I want to know the unit sales of the first date of every month of every
store.
How can I implement the MDX?
...more >>
Basket Analysis Posted by Paul at 10/10/2004 10:14:43 AM Hi,
Does anyone know of any good examples of cube construction
for basket analysis, I can't seem to find much of anything
on this particular type of analysis.
Ta
Paul...more >>
Aggregate with different function in different level Posted by ad at 10/8/2004 11:18:22 PM I have an area dimension with three levels: Area, County, and School
I want to aggregate the number of students with different function in
different level, like that in the school level, I want to aggregate student
number with max, in the County and Area level, and I want to aggregate the
stud...more >>
DTS Exception loading BI Accelerator data Posted by andrea.vincenzi NO[at]SPAM tiscali.it at 10/8/2004 3:11:04 PM I have been playing with the BI Accelerator more than once, but I was
never able to build anything that works, so I'd like to see if anyone
can help me.
I'm having a problem during the data load phase: all other phases were
executed correctly, the db and all the cubes were created without
err...more >>
BI Accelerator SMA Posted by Federico Haedo at 10/8/2004 10:41:44 AM Hello people,
I want to inspect the code corresponding to the "BI Accelerator - SMA
Application" But I don´t have the password to do this vía MS Excell. Anyone
of you know how to do that.
Thanks. Federico Haedo
...more >>
Indexing Star Schemas Posted by plugwalsh NO[at]SPAM yahoo.com at 10/8/2004 8:49:45 AM Hi
Can anyone add to / comment on / improve / criticise this logic for
indexing a fact table in a star schema:
Presuming a fact table with 4 dimensions:
* Brand
* Product
* Time
* Store
1. Clustered index on Time dimension
EVERY query is going to filter based on date, so this is a...more >>
Recover data from yesterday Posted by Alain at 10/7/2004 12:02:23 PM Hi,
I'm not a database manager,
I have to recover the old database instead of the actual.
I backed up the old one from a tape backup.
Do i have just to rename the existing one and copy the one
that i want in the same folder.
People told me that there was no change between these two ...more >>
Excel 2002/2003 Add-in for SQL Server Analysis Posted by Stephen at 10/6/2004 4:05:23 PM Is "Excel 2002/2003 Add-in for SQL Server Analysis
Services" supported under Win XP SP2 ?
When I try to install it I get "The advertised application
will not be installed because it is unsafe. Contact your
administator to change the installation user interface
option of the package to ba...more >>
Retaining formatting in Excel defined in cube Posted by Tom at 10/6/2004 10:05:03 AM 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?
Thanks!...more >>
Sql Quey or view Posted by Murat YEÞÝLBAÞ (By AbbA) at 10/5/2004 7:48:06 PM Arkadaþlar Merhaba
programlama bölümüne bu iletiyi gönderemedim herhalde bir problem var
Bende bu bölüme attým belki bilenler vardýr..
Basit bir stok takip programý yapacam ama biryerde takýldým kaldým
konuyla ilgili fikirlerinizi sunarsanýz sevinirm
Aþaðýdaki yapýda birden faza...more >>
Can I reserve all the rows in Fact table when add the dimension in cube Posted by ad at 10/5/2004 5:59:34 AM My fact table join with a dimension table with a foreign key.
But there some foreign key in the fact table which doesn't exist in the
dimension table.
When I add the dimension in cube, all no match rows will be filtered out
Can I reserve all the rows in Fact table when add the dimension in...more >>
Schedule Restart Windows 2003 Server. Posted by Hadri at 10/4/2004 11:00:37 PM Hello,
I would like to know on how to SCHEDULE restart a server
which is running on a Windows 2003 Server platform at
anytime we desire.
thank you....more >>
Delete in a dimension table is very long... Posted by Jéjé at 10/4/2004 2:06:45 PM Hi,
I want to delete "Inactive" rows in a dimension in my DW, but its slow due
to relationships.
First. I want to keep these relationships to insure a excellent data
integrity
Second. I delete rows linked to these deleted items before I delete my
dimension.
(So, normally, my "inactive" fl...more >>
SQL BI Wins 5 awards in Intelliegent Enterprise Readers Choice Awards Posted by karenmiddleol NO[at]SPAM yahoo.com at 10/2/2004 9:45:52 PM The prestigious Intelligent Enterprise Readers Choice awards for 24
strategic business applications was announced last week. Apparently
Microsoft SQL Server BI seems to swept all the BI readers choice
awards beating longtime industry BI heavy weights like Cognos &
Business Objects. Amazingly, re...more >>
Change buffer size for the text datafile data Posted by cjeffwang NO[at]SPAM gmail.com at 10/1/2004 3:23:29 PM When populating a table with a column of TEXT datatype, an error
message was shown, indicating that the data is too large for the
specified buffer size. How we I change the buffer size from the SQL
Server Enterprise Manager?
TIA,
Jeffrey...more >>
Update a big table with a reference table's info Posted by ttidy at 10/1/2004 3:13:02 PM Hi,
I need to program a update statement to update 4.3 millions records in a
table, which changes were according to a reference table. What is the fastest
way to do this update statment. Thanks so much advance!
Reference table example:
Current_code new_code
1 ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |