we're considering implementing a datawarehouse with 100GB data and really need some general help
(1) has anyone heard of a well-known AS datawarehouse having a similar/bigger quantity of info (we need to allay management fears)
(2) what are any recommendations for hardware ...

What is the best approach in data modeling FACTS with
different granularity?
For instance, I have Volume measures (item count, item
amount) at daily intervals, but Cost measures (Processing

I used the sample data (FoodMart) to create cubes.  I was successful creating the cubes but when I tried to browse the data, I get this error message 'Unspecified errors'.  What should I do?  Thank you
Jenna

Please see below a section in the BI Accelerator 1.2
documentation. This is not present in the v1.1
documentation. We would like to know why this restriction
(we are forced to go to lowest level when 2 hierarchies

Could you tell me where can I found some information about "Query
optymalization in data warehouse"?
I really need this info very urgent :(
Or could you send me some info ?

What are the factors to consider on whether to use
surrogate foreign/primary keys in fact/dim tables?  Is it
a requirement to use surrogate keys in a data warehouse
environment?  It does complicate things more in the ETL

What are some good ways to get development cubes into
production?
I currently use a developer's edition of SQL Server 2000
with Analysis Services. In the past couple of years I

My user sent me this error when trying to create a new
dimension:
"Failed to load control 'POMDimensionBrowser' from .  Your
version of  may be outdated.   Make sure you are using the

please tell me where is the UI of the MS SQL Server
Explaining the problem
I am new to MS-SQL Server. I installed it from my MS-Office CD. Now I can see 'SQL Server Service Manager' icon, on my System tray, but it doesn't have a place to input commands. When I try to use sql data ...

hi doesn anyone know what the maz size is for an SQL
database (either standlone or installed on 2000 server)

Is there any managed website which maintains the list of
cities across the globe and their time zones in it.
Thanks,

I was wondering what kind of performance increase can I expect if i change
to a 64 bit system running sql server? What kind of problems can i run into
changing to sql 64 bit or only advantages... Are there benchmark tables
available on the internet?

Can someone help me with what steps are necessary to build a periodicity
dimension? What source do I use and how does this concept actually work?

hello, ppl.
i have problem when i use russian language to build AS database.
(all cubes, dimensions, members are named in russian).
the previous db in english was working fine.

I have a requirement to publish dashboards for SQL Server like gauges,
sliders, graphs, etc to a digital dashboard.
Please advise which is the best way to publish dashboards on SQL
Server. Also please point me to some resources on some sample