I am using cognos 11.1.3 and I am using a repeater within a list. The "repeated" column is using a master-detail relationship. However, I could export the report to Excel with the repeater created. Unfortunately, the repeater will be disappeared when export to "Excel Data". It is a repeater and NOT repeater table (expected 1 very long text column).
Please suggest whether the master-detail relationship is not possible for "Excel Data".
Quick answer, no
Detailed Answer From IBM Documentation:
Excel 2007 Data provides data for use in Microsoft Excel version 2007. These reports only contain minimal formatting. Default data formatting is applied to the data based on data type and assumes that each column has a single data type.
The output is similar to other Excel formats, with the following exceptions:
The generated output includes only the first list query in the report.
If a report contains multiple queries and the first query is a multi-dimensional query for a crosstab or for a chart, an error message is displayed when the report runs.
Nested frames and master-detail links are not supported.
Cells in the Microsoft Excel file have a default width and height. You must adjust the column width and height if the data is larger than the default size.
Style specifications are not rendered, including color, background color, and fonts. Borders are not rendered.
User-specified data formatting in the report specification are not applied, including exception highlighting and color rules for negative numbers.
Here is a link explaining in more detail