all groups > sql server data warehouse > december 2003 > threads for december 15 - 21, 2003
Filter by week: 1 2 3 4 5
Any advice on testing Data Warehouse solution?
Posted by Doug Needham at 12/20/2003 10:23:16 PM
We are looking at deploying a data warehouse solution soon that has been
being developed for a few months. The development team has been working on
developing this for the company. Soon they will be turning this over to the
DBA group to do some level of integration testing with the rest of our
p... more >>
Experiences in using SQL Server reporting services
Posted by simonlenn NO[at]SPAM yahoo.com at 12/19/2003 3:59:59 PM
Can any of you who have started or evaluated usage of SQL Server
reporting services please share your experiences.
How come there is still no thread on microsoft.public.sqlserver.* on
Reporting services will it be implemented at some stage.
Regards
Simon... more >>
Good books on SQL Server Reporting Services
Posted by simonlenn NO[at]SPAM yahoo.com at 12/19/2003 3:58:16 PM
Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
Simon... more >>
The Members Count property of level 'LevelName' must be > 0
Posted by Mike at 12/19/2003 2:54:29 PM
I'm trying to build a cube. I am using a view for my
account dimension. Here is the definition:
ALTER VIEW DemandAccounts AS
SELECT *
FROM dbo.Account
WHERE AccountKey IN
(SELECT DISTINCT AccountKey FROM Demand)
I only want accounts in my dimension that have made
demands. I have verif... more >>
What is the future for BI Accelerator in Yukon
Posted by Claudio Lucio at 12/19/2003 9:21:03 AM
Hi dear all,
Anyone have news about the future of BI Accelerator in Yukon SQL
version? What do you think about SQL BI Workbench announced by Microsoft?
... more >>
How to format Field ?
Posted by Daniel at 12/18/2003 9:36:05 PM
HOw to set the field (Password) in sqlServer database to '*'
For example
I key in VB : 12
In SqlServer database should appear : **
Yoir help will be appreaciated
daniel.... more >>
What does this error mean?
Posted by Mike at 12/18/2003 10:27:57 AM
All,
When I process a new cube, I receive this error:
Analysis Server Error: More than the maximum of 64,000
dimension member children for a single parent
(dimension 'Retention SC Account'S', level 'Account
Number', member '1234567890').; Time:12/18/03 9:58:28 AM
The underlying fact t... more >>
Problem processing new cube
Posted by Mike at 12/18/2003 9:29:44 AM
All,
When I try to "Design Storage" for a new cube, I get
a "Fact table size can not be 0" message. (I am in the
Cube Editor...) If I focus on the fact table and
select "Browse Data", the data is displayed as it should
be. So, the fact table size clearly is not "0".
From Query Analyzer... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Shrinking Transaction Log
Posted by LIN at 12/17/2003 4:33:44 PM
Hi,
We have created a System which does over 1000 transaction every fives
minutes with the database. Mostly they are insert and udpdate commands. We
have noticed that the transaction log keeps increasing in size (in GBs). We
have used the Shrink command at various stages but at some point of t... more >>
Unable to count the members of .....
Posted by Mike at 12/17/2003 4:03:44 PM
All,
When I try to process my new cube, I receive the following
messages:
Unable to count the members of 'LineOfBusinessLevel4'
level.
Unable to open the record set.
Error: Timeout expired.
I went into the ODBC administrator and increased the
connection pooling timeout to 360 an... more >>
|