The following steps can be followed to browse data in the Cube Viewer:
Intellipaat provides industry-leading online Cognos TM1 training for BI professionals.
To access data using this tool the following steps should be followed:
Modifying your view of data
To do this, Cube Viewer allows a user to perform the following:
Stacking a title dimension as a row dimension
To stack a title dimension as a row dimension in Cube Viewer, you can click on the element name in the title dimension and drag that element name to the right or left of a row dimension name.
Stacking a title dimension as a column dimension
To stack a title dimension as a column dimension in Cube Viewer, you can click on the element name in the title dimension and drag that element name to the right or left of a column dimension name.
Drilling down through consolidations
In Cube Viewer, a plus sign (+), next to an element name, identifies the element as a consolidation. To view the underlying detail, click on +, and to hide the underlying detail, click on the minus sign (–).
Changing title elements in Cube Viewer
To change title elements displayed in Cube Viewer, click on the element name arrow, select an element, and press F9.
Drilling through to detailed data
To access detailed level data for a selected cell of data in Cube Viewer, a drill TI process and drill association rule must be implemented.
Saving the view
To save a view from Cube Viewer, you can click on File and then select Save. TM1 will prompt you with the TM1 Save View dialog. This dialog allows you to:
Formatting view cells
The most common features provided by TM1 to format data displayed in a cube view are:
You can turn off rows and/or columns that are zero.
For row suppression, click on Options | Suppress Zeroes On Rows:
For column suppression, click on Options | Suppress Zeroes On Columns:
To customize the display of data within a cube view cell, the Format attribute can be used. The Format attribute is a special type of element attribute that determines how data is displayed. The value of the format attribute can be applied to column elements, row elements, or title elements
You may change it from right to left by clicking on the menu option Layout Right to Left (or Layout Left to Right, depending upon the current view).
From TM1 Cube Viewer, data can be sliced into Microsoft Excel for analysis and further presentation.
Slicing a view
To slice a view from Cube Viewer to an Excel worksheet, you can click on File and then select Slice. TM1 will copy the current view into a new MS Excel workbook. Sliced views are still connected to TM1, because TM1 adds the appropriate TM1 functions to the worksheet to retrieve the data from the cube.
From TM1 Cube Viewer, data can be copied into Microsoft Excel for analysis and further presentation. In contrast to the slice, the snapshot is a copy of the data at that moment in time. To create a snapshot from Cube Viewer, you can click on File and then select Snapshot.
Active Forms let you view (and update) cube data directly in Excel whenever you are connected to the server on which the cube data resides.
There are a special groups of TM1 worksheet functions that are used for the support of Active Forms. These groups include:
Refreshing and recalculating
Once you have saved an Active Form, you can refresh the data displayed in it by pressing F9. Additionally, you also have the option to rebuild the current worksheet or current workbook by clicking on Active Form and then selecting Rebuild Current Sheet
Deleting an Active Form
To remove an Active Form from a worksheet, you must click in the data area of an Active Form and then click on Active Form | Delete.
Active Forms and special formatting
Formatting Active Forms
Active Form formatting is defined via a format range which is hidden within the Active Form worksheet. This hidden range is revealed by clicking on Active Form and then selecting Show Format Area.
Active Form default formatting
Active Forms must have the default formatting defined in rows 1 to 8 where row 1 will always have the Begin Format Range label and row 8 will always have the End Format Range label:
Modifying default formatting
Even though the formatting range for an Active Form is initially defined in rows 2 through 7, you can create multiple additional format definitions and insert them between the Begin Format Range and End Format Range labels of the Active Form:
Active Form limitations
There are some limitations with using Active Forms:
TM1 reports must be created from a TM1 slice (described earlier in this chapter). From there, TM1 reports utilize a Report Generation Wizard to:
TM1 Print Report Wizard
To use the reporting wizard, from the menu bar, click on TM1, then select the Print Report option. From the Print Report Wizard dialog, you can select the desired options and click on Next to step through and set up all of the report options and then click on Finish.
Selecting the sheets
You can use TM1 Print Report Wizard to select any (or all) of the worksheets from the current Excel workbook to include in your report. In the wizard, you can select the checkbox of the worksheet that you want to include in the report or you can click on Select All to include all of the worksheets in the current workbook in the report.
Selecting the title dimensions
You can select the title dimensions to be included in the report by selecting and moving them from the Available Title Dimensions list to the Selected Title Dimensions list.
Selecting workbook print options
For these options you can provide the following:
TM1 Web allows access to the cube data, provides the ability to view and edit via Excel reports, drill, pivot, select, and filter the TM1 data, cube data sourced charts, and even some TM1 Server Administrator tasks.
It should be understood that the websheet version of the Excel sheet will have various visual differences but it does support the following Excel features:
In this websheet a user can:
TM1 Web Cube Viewer
To utilize Cube Viewer within TM1 Web you can:
Creating a new TM1 Web cube view
To create a new TM1 Web cube view, you can use the TM1 Web View Builder Wizard.
To view cube data in TM1 Web in chart format, you can click on View Chart, View Chart and Grid, or View Grid from the toolbar.
From the TM1 Web chart display, you can click on Chart Properties to change the chart type, colors, legend, and 3D view elements.
Custom display formats
We reviewed element attributes and the Format attribute. Again, to revisit, this attribute allows the definition of a number of formats for numbers, dates, times, and strings If you right-click on a dimension, click on Edit Element Attributes, and then click on the cell at the intersection of the Format column and the element for which you want to define a display format, TM1 will allow you to select a standard format for that element or define your own. These formats will be applied to all cells in the defined data intersection.Previous
Download Interview Questions asked by top MNCs in 2019?