I'm amending an active form to add row dimension (DimC) via TM1RPTROW. There are already two existing TM1RPTROW in the report.
Things I have performed:
1. Remove TM1RPTTITLE for DimC out from TM1RPTVIEW
2. Adding TM1RPTROW before the two existing ones
3. Manually delete all the rows under TM1RPTROW
After rebuilding the worksheet the dimensions in first row underneath TM1RPTROW is correct but dimensions from second row onwards are somehow ordered wrongly.
https://imgur.com/a/QLMC4w7
Funny thing is, I have also rebuild the view in cube viewer and generate via button 'Active form'. The elements ordering in the generated reports are also wrongly displayed (as per url image)
Is there something that I have missed out?
Appreciate for any advice!
Dimension elements wrongly displayed for multiple TM1RPTROW in Active form
-
- MVP
- Posts: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Dimension elements wrongly displayed for multiple TM1RPTROW in Active form
Welcome to the forum.
Is the version mentioned in your profile correct ? Then please upgrade. IIRC there has been such a bug.
Is the version mentioned in your profile correct ? Then please upgrade. IIRC there has been such a bug.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 12
- Joined: Thu Nov 25, 2021 1:09 am
- OLAP Product: TM1
- Version: 10.2.0
- Excel Version: 2013
Re: Dimension elements wrongly displayed for multiple TM1RPTROW in Active form
That's the version for my personal use only.
This specific client having issue is using the stable version 2.0.9 with Excel 2013 - however, could not find any related fix on 2.0.9.5
Thanks,
This specific client having issue is using the stable version 2.0.9 with Excel 2013 - however, could not find any related fix on 2.0.9.5
Thanks,
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: Dimension elements wrongly displayed for multiple TM1RPTROW in Active form
Hi,
Two questions:
Is the incorrect order being shown in the image the order of the dimensions in the cube?
When you open the active form in TM1Web is the order correct?
If the answer to the above 2 questions is Yes this is the bug I think Wim was referring to.
My understanding is that this had been fixed a while ago!
regards,
Mark
Two questions:
Is the incorrect order being shown in the image the order of the dimensions in the cube?
When you open the active form in TM1Web is the order correct?
If the answer to the above 2 questions is Yes this is the bug I think Wim was referring to.
My understanding is that this had been fixed a while ago!
regards,
Mark
-
- Posts: 12
- Joined: Thu Nov 25, 2021 1:09 am
- OLAP Product: TM1
- Version: 10.2.0
- Excel Version: 2013
Re: Dimension elements wrongly displayed for multiple TM1RPTROW in Active form
Thank you both. Will check with support and see if they patch this in any later version