Home Analytics Designing reports
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

BIRT CROSSTAB Auto-Merged Group Dimension - Repeat Group Dimension Value for each Record

prince_iamprince_iam BIRT & Oracle Developer
edited April 3, 2019 in Designing reports

Dear Fellows,

I am facing the problem, I want to repeat value of group dimension for each row as my client wants to export data into excel and apply some filters. Since, crosstab automatically merge the group dimension and displays summarized data that is not intuitively required by my client. Could you guys help me to resolve this issue at earliest. Thank you in anticipation.

I have attached the screenshot of generated crosstab report in result of created group dimensions.


  • edited April 4, 2019

    I tried using a grid, but the Excel export was not formatted correctly.

    The attached report groups by country and again by state. To repeat the country value in each row, I added the state column twice in the data cube. The cross tab row then had the groups: [country] [state1] [state]. I deleted state1 and moved country to the state1 cell so that it would repeat for each state. i couldn't find a way to remove the blank column on the left without messing up the cube, so I just made it smaller.

    I hope this is helpful.

    Jeff F.
    Sr. Technical Support Specialist
  • prince_iamprince_iam BIRT & Oracle Developer
    edited April 5, 2019

    Dear Jeff,

    Thank you for comment, I tried your suggestion but this didn't work in my case. I am still facing the same problem though I have added the required repeated column twice.

  • edited April 5, 2019

    Can you get my report to work? Do you see the countries repeated for each row as shown in column B:

    If my report does not work for you, please let me know your Designer's build id.
    If my example works, what is happening in your report?
    You should be copying the lowest level row group in the cube; the one that has a value for every row.

    Jeff F.
    Sr. Technical Support Specialist
Sign In or Register to comment.