Sunday, March 11, 2012

Diagram Pane Add/Remove Tables Problem

Hi,

I am doing the AdventureworksDW Analysis Services Tutorial.

I am a the following place.

Analysis Services Tutorials > SQL Server 2005 Analysis Services Tutorial > Lesson 5: Defining Relationships Between Dimensions and Measure Groups >

I am at the following spot.

Adding Tables and Defining the Sales Quotas Measure Group

To add tables and define the Sales Quotas measure group

    Switch to Data Source View Designer for the Adventure Works DW data source view.

    Right-click anywhere in the Diagram Organizer pane, click New Diagram, and then specify Sales Quotas as the name for the new diagram. For more information, see Working with Diagrams in a Data Source View (Analysis Services).

    Drag the Employee, Sales Territory, and Time tables from the Tables pane to the Diagram pane.

    Add the FactSalesQuota table to the Diagram pane by right-clicking anywhere in the Diagram pane and selecting Add/Remove Tables.

I can do 1, 2, and 3.

When I try to do four, I bring up the dialog. On the right side of the dialog I see INCLUDED OBJECTS.

I select (highlight/make blue) FactSalesQuota and press O.K.

Nothing happens. What else do I need to do?

The link just below shows a screenshot.

AddRemoveTableProblem

Thanks,

Andre Mikulec

AIM

AIMDBA

Andre_Mikulec@.Hotmail.com

FactSalesQuota is included in your diagram already, but it has been given the friendly name "SalesQuotas". In your picture you can see it in the background in the list of tables as the fourth table up from the bottom.|||

Thanks,

I have been working 18 hours per day on an alternate project for a month.

I am finally getting some time to get back to this tutorial.

Andre Mikulec

AIM

AIMDBA

Andre_Mikulec@.Hotmail.com

No comments:

Post a Comment