You can create a flex view from an exploration or by dragging explorations, views, or other flex views from the source tree to a worksheet.
After you create a flex view, you can change or add members, format the cells, and create charts from the data. For example, you can change members and data using options such as typing the name of different member in a cell.
You can combine multiple flex views on the same worksheet. Each flex view can be based on a different data source. You can provide unique perspectives by creating calculations that reference multiple flex views. Another useful option for multiple flex views on the same worksheet is to use cell references to apply the same filter to more than one flex view. For example, you create three flex views on a worksheet to show different views of financial performance by region. The region name appears in cell B4 in the context region on the first flex view. In the second and third flex views, you change the region name cell to a cell reference cell B4. After you create the cell references, you update the first worksheet to show data for a different region, either by dragging a different region to cell B4 or by typing a region name in cell B4. When you refresh the data, all flex views show data for the new region.
Subsets are a useful tool for building explorations and flex views with Cognos® TM1® data. For more information about creating subsets, including dynamic subsets that can automatically reflect changes in a dimension, see Subsets.
Each flex view includes four regions: rows, columns, context, and data. Each region is a named range in Microsoft Excel. For example, the defined name for the rows region of the first flex view you add to a worksheet is tm1\\_0_R. You can use the names when you use Microsoft Excel features such as creating formulas.
To highlight a region on the worksheet, from the IBM Cognos Analysis pane, right-click a flex view in the Current flex views folder and select a region from Show Regions list.