HI,
I am creating an Active form Report, it has morethan 1000 Columns.but Active form not copying DBRW Formula from 1st row for 1000+ columns.
I changed TM1RPTFMTRNG upto BZZ column.i am doubting is there any restriction columns in Active form?.
Please advice.Thanks in Advance.
Regards,
Nataraja
Maximum No.Columns in Active form
-
- Posts: 13
- Joined: Fri Nov 06, 2009 6:48 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2007
-
- MVP
- Posts: 3128
- 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: Maximum No.Columns in Active form
Hellonataraja.pl@tcs.com wrote:HI,
I am creating an Active form Report, it has morethan 1000 Columns.but Active form not copying DBRW Formula from 1st row for 1000+ columns.
I changed TM1RPTFMTRNG upto BZZ column.i am doubting is there any restriction columns in Active form?.
Please advice.Thanks in Advance.
Regards,
Nataraja
Did you really mean 1000+ columns? Who would want to use such a report?
Also, column BZZ is column 2054. Why would you want to go that far?
Please note that extending the formatting range (TM1RPTFMTRNG) is not going to help.
All other formulas are correct (like TM1RptView and so on)?
It helps if you insert columns to the left of the last column, rather than adding columns to the right.
But 1000+ columns is simply not done. I doubt the architecture of the report / cube could not be improved.
Wim
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
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Maximum No.Columns in Active form
I can't see performance being so great in such a large (if possible) sheet either. Keep in mind how performance start to de-grade in large Excel sheets, not to mention stability.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: Maximum No.Columns in Active form
Report? More like a data dump that best would be done with TI rather than an active form.