In Microsoft Abalysis Manager one  can browse the cube data by right
clicking the cube  and  drag and drop columns to view data. Can the
same be achieved with reporting services.
Thanks in advance

I have de normalised tables in the source for use in a star
schema.However the grain of the facts that I may need are different
from that in the source also the source database has got denormalised
database which has data according to the three diferent companies

My data warehouse is now 4 years old and the size is about
600 GB od data.
We had only data insert no update in this duration. PKs
are all clustered indexes and in chronological order.

This is more of a design question. I am trying to create a fact table for time spans. For example an order might go through the following status of Created, In-Progress, Delivered. The time span between any 2 states could range from minutes to days to months. I want to be able to ...

hi ppl...
i'm a final year student in information systems and a new comer in the field of data mining. i'm developing the application using VB 6.0 for the front end and i'm using SQL server 2000 : Analysis services for the back end. taking customer transactions, my aim is to ...

If there is anybody out there still looking for a comparison of SAP BW
to SQL Server I would like to let you know we were one of the large
SAP BW sites and having been acutely frustrated with BW we converted
to SQL Server OLAP Services. There is a interesting Whitepaper on the

I'm planning to use MS Reporting Services in a project.
Does anyone know, if one could realize charts having two different
y-axis?

This very important online survey will give you the opportunity to provide feedback on the availability of SQL Server information and peer support in the SQL Server communities.  This will help Microsoft and its community partners to better understand customer needs and how to ...

Hi all SQL gurus, I know I am with some real expert
brains now! I am here seeking some help...
I have a log table with one of its columns holding
multiple values with a comma deilimiter. The data looks

Does anyone know of MS roadmap regarding Yukon's support for real spatial
data types (like Oracle's SDO_Geometry) and
support for spatial functions?
We need a monolithic database for both geospatial and regular,non-geo data.

Can you please let me know which is the best site to get the Currency
exchange rates from.
Can DTS automatically download currency exchange rates from any of
these sites into the data warehouse.

I have created a few calculated members under one dimension (meaning the parent dimension is not Measures, but other dimensions). It can be showed in the Analysis Manager, but cannot be displayed in MS Excel PivotTable (MS Office 2k, xp, even 2003). Is there any solution to ...

I have 10 years in my time dimension but I only want to display 5 of those
years in certain cube.  How would I limit the number of years from a
dimension?

I dont know the difference between OLAP and the datawarehouse newsgroups,
and i really dont know how many ppl frequent both the groups together - but
Im posting this topic here in hopes that it may start a discussion. I
apologies for any inconvenience. Thks. =)

If you have two fact tables that share a dimension is it better to duplicate
the dimension by adding a copy of it to the warehouse or should you share
the single dimension between the fact tables?