how to find data analysis tool in excel 2007

In the 'Choose Property Fields for Dimension' dialog box, for level Month Name you should see 1 property fields called Month Number. What Excel means by Property Fields here is SSAS Related Attribute that I explained above. Click on the Options menu, OLAP Options, Property Fields. On the Pivot Table, click on the Month Name column. Now, in Excel, pull Month Name into rows. We set the OrderBy property to AttributeKey and the OrderByAttribute to Month Number.ĭeploy and process (full) all dimensions and process the cube. Still in BIDS, after we relate the Month Number to the Month Name, we open the properties pane of Month Name attribute and find the OrderBy property. Then on the Attribute panel we drag the Month Number attribute to the of Month Name.

On the Data SOurce View panel (the right panel) of Dimension Structure tab of the Dimension Design screen, we right click on this column and click on New Attribute from Column.

We have a column on the relational dimension table called 'Month Number'. Īttribute relationship is commonly used for 2 purposes:Īs an example for implementing Related Attribute for sorting, say we want to change the sorting order of month name from ' April, August, February, June. On Dimension Structure tab, under Attribute pane, click on a + to the left of a dimension. On BIDS, open a dimension by double clicking it on Solution Explorer. What I meant with SSAS Related Attribute is this: I think the 'Choose Property Fields for Dimension' dialog box is for displaying/not displaying 'related attributes', not for sorting/ordering the members in Excel 2007 pivot table.

How to find data analysis tool in excel 2007