Fairly new to this, I'm having a problem creating a hierarchial dimensionn
from a table with the following structure:
STATE    |    ZONE   |    BRANCH    |    CONTACT TYPE    |    CONTACT
-----------|------------|---------------|-------------------------|------------

sorry this question that for you may be a stupid question...I am novice in
Analysis Services...
I need to create a Sales Report for my agents and publish on my WebSite, so
the agent login on private area and check it's sales by product, by

I have a fact table that has one measure. I need to get a several subset of
data from my fact table, based on this measure and summarize this information
in a cube.
Thanks

I need to implement drillthrough options in a cube using MSAS 2000.
But required a given order of columns for showing these columns and I
don't know how can I set an order of columns.
It looks like I can only select and deselect column outputting but

       Just got done with the requirements gathering and discovered
that my users want to measure about 200 items with the warehouse.  So
I envision a Fact table with about 200 columns.  This seems quite
large to me - but maybe other developers feel differently.

I am experiencing a weird problem with SSIS development in BIDS...
When I click "View --> Other Windows --> Variables", the window doesn't show
up.
Has anyone else had this issue?  If so did you solve it, and how?

I have recently moved over to Windows Vista Business Edition and have issues
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch.  All I get is a
Windows message stating that it has stopped working.