Hi All,

I have created cube with SQL Server 2000 analysis services to analyze
sales data.

Dimensions are :
- Customers
- Salesman
- Product

Measures are :
- Gross Sales
- Discount

Now there is a requirement to compare "Gross Sales" with the "Sales
Target".
The question is :
Assume sales target is given per salesman + product, how can I include
the sales target values into the cube ?

so that when do analysis , the layout can be like this :

Salesman Product Gross_sales Sales_target
John Doe Product_A 15000 12000
............

Thank you for your help,
Krist













*** Sent via Developersdex http://www.developersdex.com ***

Create a new cube for the Sales targets which, from your description
would look something like the following.

Dimensions are :
- Salesman
- Product

Measures are :
- Sales Target

Then create a virtual cube which combines these two cubes together.
(Note: for virtual cubes to work properly, at least the common
dimensions should be defined as shared dimensions)

When the users browse the virtual cube they will be able to see all
three measures, however when they drilldown into individual customers,
the sales target measure will be blank.

HTH

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <O$RVIahMGHA.2628 (AT) TK2MSFTNGP15 (DOT) phx.gbl>, Krist (AT) me (DOT) com says...