Procedures
You can create Vision custom reports in Excel, filter by values and dimensions, reorder rows and columns, and more.
This is the start of your concept.
Related Topics:
- Create a Vision Custom Report in Excel 2007
Because Vision role security is not enabled for Analysis Cubes, how you create, save, and share Vision custom reports is important. - Connect to a Vision Data Cube for the First Time in Excel 2007
Before you create a Vision custom report in Excel 2007, you must first connect to a Vision data cube. - Add a Locale Identifier Code to the .ODC file
Users who connect to the English International data cubes in Excel must perform an additional task to ensure that Vision dimensions, measures, and system labels display in the English International language in the Excel PivotTable Field List. - Reconnect to a Vision Data Cube in Excel 2007
You can reconnect to a Vision data cube to which you were previously connected. - Filter a Report with Values
You can filter rows with data when creating a report. - Filter a Report with Dimensions
You can filter columns or rows that contain dimension data when you create a report. - Apply a Filter to the Entire Report
You can apply a filter to an entire report. - Remove a Filter
You can remove a filter from a report or you can remove the ability to filter a report altogether. - Sort Data in an Excel Report
You can sort Excel PivotTable reports by dimension or measure data. - Move Fields in an Excel Report
You can move fields around on an Excel PivotTable report. - Reorder Rows and Columns in an Excel Report
You can reorder rows and columns in existing Excel PivotTable reports. - View Transaction Detail on a Report
When you view an Excel PivotTable report, you can vary the level of detail and modify the amount of data. - View Vision Records from a Custom Report
For some Project data cube dimensions that you add to a custom report, you can open the dimension record in Vision directly from the report. This is a "drill-through" action. - Refresh Data in a Previously Saved Vision Custom Report
When you open a previously saved Excel Vision custom report (one that contains the report design, not just a copy of the report output), you must refresh and connect to the external Vision data cube to see the most current Vision data.
Parent Topic: Custom Reports and Analysis Cubes