You can export data from the D-Cube into an ASCII file or to the clipboard. The export function gives you the ability to format how you want to export the data. You can set the delimiter, insert headers, and arrange the order of the dimensions.
You can also suppress zero values in calculated data so that the export function will not include records that have zero or null data.
To export from a D-Cube:
Observe the following:
If you have a saved selection containing the data that you want to export, then you can load that selection into the dimension selection box.
Select how you want the dimensions to be displayed as columns:
The following table illustrates a single column file with each dimension laid out as a separate column:
The following table illustrates a multiple column file. In this example, the items in the Month dimension are displayed as separate columns.
In the Format section, select the following:
This option lets you enter a title and/or footer to the export file. Enter the title or footnote by typing directly into the text box.
This option suppresses any record with zero values. This option is independent of the zero suppression in force when you are viewing the D-Cube. You can suppress zeros in rows or columns by highlighting the dimension labeled R or C respectively. You can deselect a selected dimension by pressing Ctrl and clicking on the highlighted item. To suppress zeros in pages, select Suppress Zero Pages. If you want to suppress zeros in all of the dimensions, highlight all of the dimensions and then select Suppress Zero Pages.
This option lets you choose whether you want to export only detail items or calculated items by highlighting the dimensions containing the detail or subtotal items, as appropriate. There are separate selection boxes for detail and total items.
Breakback is a powerful feature in IBM Cognos Planning. With Breakback, you can enter data into calculated cells and change the variables that make up the formula according to rules that you specify. Breakback is commonly used to propagate changes to a total across its detail items, in proportion to the value of the detail items.
Suppose you have five products, showing a total of 1500 units:
Product | Current |
Product A | 100 |
Product B | 200 |
Product C | 300 |
Product D | 400 |
Product E | 500 |
TOTAL | 1500 |
With Breakback, if you enter 3000 in the total, the detail products will change as follows:
Product | With Breakback |
Product A | 200 |
Product B | 400 |
Product C | 600 |
Product D | 800 |
Product E | 1000 |
TOTAL | 3000 |
Breakback distributes the changes in the TOTAL to Products A to E in proportion to their original share of the total. Breakback works on addition, subtraction, multiplication, and division. It can handle multiple calculations across multiple dimensions and hierarchies.
You can apply Breakback on a grand total consisting of multiple subtotals across various hierarchical levels. In a simple hierarchy where you have only one subtotal, Breakback distributes the value across its children proportionately. In a multi-level hierarchy, Breakback cascades the changes one level at a time down through the hierarchy. If you enter a value into a total, Breakback will distribute the value proportionately to the subtotals immediately below the total, then to the subtotal the next level down, and so on.
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed…
Key takeaways The transformer architecture has proved to be revolutionary in outperforming the classical RNN…
Once we learn how to deploy an Ubuntu server, how to manage users, and how…
Key-takeaways: Clean code isn’t just a nice thing to have or a luxury in software projects; it's a necessity. If we…
While developing a web application, or setting dynamic pages and meta tags we need to deal with…
Software architecture is one of the most discussed topics in the software industry today, and…