dbTalk Databases Forums  

Sponsored Links

microsoft.public.sqlserver.datawarehouse microsoft.public.sqlserver.datawarehouse

Discuss in the microsoft.public.sqlserver.datawarehouse forum.

Post New Thread
Threads in Forum : microsoft.public.sqlserver.datawarehouse Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I have a need to build a SQL data warehouse that will lend itself to storing data offline on a SAN. Basically I am attempting to implement a...
Randy L
12-19-2008 07:39 AM
Todd C Go to last post
8 255
How can I add multiple datasources to a single cube? In other words, how can I join data from several different SQL databases to use in a single cube?
12-10-2008 07:11 AM
Ohjoo Kwon Go to last post
40 609
Hi, Is it possible to refresh cube partition of SQL Server Analysis Services 2005, so that the data in the partition gets overwritten? In SQL Server...
12-03-2008 06:14 PM
honeybee Go to last post
16 240
I installed a copy of SQL server 2008 Express. I can see SQL Agent from the Server Configuration Manager, but I can't start it - get error. Any...
11-14-2008 02:04 PM
Russell Fields Go to last post
8 180
Hello! As I understand the "unknown member" means that the dimension key is not found in the fact table. In my case, the dimension table IS the...
11-10-2008 05:23 AM
David Go to last post
32 353
Hello everyone, I am using Microsoft Dynamics GP Analysis Services on SQL Server 2005. I am using Microsoft Office Excel Add-in for SQL Server...
Abu Owais
11-06-2008 09:45 AM
Ohjoo Kwon Go to last post
24 302
Hello, I have a question/scenario. I'm creating a cube in Analysis Services (which works fine) but my 3rd party control is not showing my data...
11-04-2008 05:13 PM
Ohjoo Kwon Go to last post
8 89
I realise this is a very general question, but after hours of Googling I am none the wiser. I think I want to use SSAS, because I have views and...
Charles Law
10-27-2008 06:11 PM
Charles Law Go to last post
32 514
Hi, I would like to add another measure into cube which is counting distinct employee_id instead of employee_key (surrogate key) This is the...
10-26-2008 07:27 PM
Ohjoo Kwon Go to last post
8 100
My drive on which the olap cubes are built for deployment has ran out of space, so I need to move the mssql.2\olap... dir and all files to...
Carl Henthorn
10-22-2008 12:26 AM
Ohjoo Kwon Go to last post
8 96
Hello, Im working with MDX functions. I would like to calculate the sum from the first month in my Time dimension till current month. e.g Jan 2007...
10-21-2008 05:51 AM
Ohjoo Kwon Go to last post
8 202
can anyone point me to a routine or util that populates a time_dim table? Given a date range, routine creates all rows for each day in...
10-17-2008 05:10 PM
Sandra Mueller Go to last post
16 219
This is not a question of a degenerate dimension, I have that implemented and it works fine. I have a cube with three fact tables. each fact...
Jeff Ericson
10-14-2008 11:01 AM
Marco Russo Go to last post
16 369
I am trying to establish Replication wherein my Publisher would be SQL Server 2000 SP3 and the Subscriber / Distributor is SQL Server 2008 I...
10-12-2008 10:47 AM
sqlmonkey Go to last post
8 113
Good morning, I have a new application I'm building, and the users want to be able to do some analysis of the data managed by the application. ...
The Man From SQL
10-06-2008 08:06 AM
The Man From SQL Go to last post
24 459
Hi all Our company is expanding into Europe and we need to get some sample databases so we can learn the input methods. We mainly need to learn how...
10-01-2008 01:04 PM
Marc Scheuner Go to last post
8 108
We have one solution that manages our DW ETL. Every table is it's own package. So we have about 18 packages. What is hard to manage is we have 5...
Joe H
09-29-2008 01:50 PM
Joe H Go to last post
24 329
Is there a way to reverse engineer a cube back into SSAS? Microsoft sent me some demo's many months back but all I had was the .ABF SSAS Cube...
Joe H
09-23-2008 10:11 AM
Joe H Go to last post
16 185
Cube usage (Multi-page thread 1 2 )
How can I determine how much our cubes are being used? Is this all in the SQL log files?
Joe H
09-22-2008 04:23 PM
Joe H Go to last post
16 329
Cognos (Multi-page thread 1 2 3 4 5 )
Anybody using Cognos and have comments on it? Our shop is using SSIS, SSAS and browsing cubes with Excel 2007. But Cognos tool looks like it may...
Joe H
09-11-2008 04:22 PM
Łukasz Go to last post
40 521
All my connections are dynamically set at run time to run against local/dev/qa/prod. The Backup Database Task doesn't seem to have a "Server"...
Joe H
09-08-2008 05:44 PM
Joe H Go to last post
16 261
Hi, I'm required to implement address standardization in my data warehouse. Daily a SQL Server 2005 SSIS package processes a excel file which...
S V Ramakrishna
09-05-2008 09:27 AM
Russell Fields Go to last post
32 353
Hi All, I have a design question . I got the requirement of 2 TB starting for enterprise dataware house in my project. I want to implement next...
S V Ramakrishna
09-04-2008 03:32 AM
S V Ramakrishna Go to last post
16 208
Hi , Is there any difference for disk configuration for OLAP systems in comparison to OLTP ,Please suggest the consideration for disk design and...
08-19-2008 07:26 AM
Jeje Go to last post
8 108
I need to load files from different source. They may provide different granularity of dimensions. For example, there is a dimension...
08-11-2008 02:23 AM
Ricardo Junquera Go to last post
8 121
Can anyone tell me what the best practice is to reindexing a SQL-Server 2005 database that has an extensive number of deletions to it. Thank...
07-25-2008 10:40 AM
Ola Hallengren Go to last post
24 273
hi before years it says that store files on the hard drive and stor only links in databse is that role true till now or new versions of sql work...
Pure Heart
07-22-2008 02:56 PM
Joe H Go to last post
8 91
Does PP actually take care of our ETL process? I always thought I would have to populate the DW then PP would take it from there. The...
Joe H
07-19-2008 09:51 PM
Jim Hummer Go to last post
16 210
Had a question about how folks are managing "change management" on their DW projects. One of the biggest problems we face on the DW, is most of...
Joe H
07-16-2008 03:43 PM
Joe H Go to last post
48 355
I need to store our ASP files into a SQL 2005 database. Average file size is about 35 KB. Could someone please explain an easy way to store text...
07-10-2008 07:33 PM
Jeje Go to last post
16 184
Is it necessary to install sqlserver cal licenses on the server machine. We have purchased sqlserver standard edition with three cal We have...
07-10-2008 01:32 AM
Cdude Go to last post
16 412
Hello Community, I'm a new comer in MS DW/BI stream. Can anyone please suggest me some good books/links on Analysis Services 2K5? And also similar...
06-30-2008 05:15 AM
Bhushan Go to last post
16 339
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I...
Travis McGee
06-29-2008 10:02 AM
Travis McGee Go to last post
16 178
Fact Tables (Multi-page thread 1 2 3 4 )
Was looking at Kimball SSIS templates and note that when he is updating Fact tables, he first dumps the original extract into an "extract" table,...
Joe H
06-23-2008 05:59 PM
Michael Coles Go to last post
32 479
The company I work for track refinery capcities around the world and what to put this data into a data warehouse. At first glance it looks simple...
06-21-2008 01:24 PM
Michael Coles Go to last post
8 118
I would highly appreciate if anyone provide me any website from where I can get the quick idea to create cubes in SQL Server and add that cube in...
06-20-2008 12:01 PM
Eric Russell Go to last post
16 342
What are folks using to manage your metadata? We were thinking of possibly coming up with something custom to manage all our 10 to 12 different...
Joe H
06-20-2008 11:49 AM
Eric Russell Go to last post
8 175
Hi, the customer wants to measure the time of some processes. E. g. you produce cars: Before the car leaves the factory their is a final control. In...
06-18-2008 08:53 AM
naggy Go to last post
32 287
Hi, SSAS 2005. I am trying to view the cube data from Excel through HTTP Connection with 'Basic Authentication' ticked for Authentication method,...
John Jayaseelan
06-18-2008 05:02 AM
John Jayaseelan Go to last post
8 96
Hi, SSAS 2005. I am trying to view the cube data from Excel through Cube data with 'Basic Authentication' ticked for Authentication method, but...
John Jayaseelan
06-18-2008 04:48 AM
John Jayaseelan Go to last post
8 96
Hi guys! In my dimension I have included an attribute "CustomerName" which I only use for securing dimension data belonging to different...
06-13-2008 10:57 AM
Tom Dacon Go to last post
8 124
Our business is we have contracts, which one to many contractors can work on. I have a working cube for the contracts and 3 measures...
Joe H
05-31-2008 08:28 PM
Marco Russo Go to last post
8 190
USE GO /****** Object: StoredProcedure . Script Date: 05/20/2008 11:02:24 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ALTER...
05-25-2008 08:47 PM
Nigel Rivett Go to last post
8 96
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...
Joe H
05-25-2008 06:08 PM
Nigel Rivett Go to last post
8 82
This place seems pretty quiet, where else do people go for data warehouse queries?
05-24-2008 06:19 AM
JamesCarters Go to last post
8 97
We have a SQL table that consists of several fields, one of which we know is an XML dump from a table. The thing is, we don't know how to extract...
05-23-2008 11:43 PM
Mike C# Go to last post
32 287
I have two fact tables, ContractFact and FundFact. In my DSV, I created a relationship to join them on a field that is in both, called...
Joe H
05-22-2008 02:30 AM
Marco Russo Go to last post
8 109
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...
05-16-2008 04:45 AM
Tomasz Borawski Go to last post
48 675
help,a difficult text how to sql table code ? i have a text as follow, line with |and...
05-10-2008 12:03 PM
Knowledgy Go to last post
8 201
I have a Dell machine i have installed a C#.net application on it. When i try access sqlserver on the server over the network i am unable to connect....
05-10-2008 12:02 PM
Knowledgy Go to last post
8 85
Post New Thread

Display Options
Showing threads 51 to 100 of 1147
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.