TM1Web Websheet Charts / Graphs not rendering
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
TM1Web Websheet Charts / Graphs not rendering
Posting to save others time should they encounter a similar issue.
Had an issue where I had created a basic websheet with a line chart plotting Actual vs Budget. All very basic DBRWs, to get data. Cleaned up formatting and published. Opened on TM1Web and chart showed up as a placeholder indicating a missing link to resource.
After much cursing, it turned out to be hiding rows below the chart that broke it. Seems like a reasonable thing to do but no matter where I hid rows from, same results, broken graph. Left as unhidden, all works. HTH
Had an issue where I had created a basic websheet with a line chart plotting Actual vs Budget. All very basic DBRWs, to get data. Cleaned up formatting and published. Opened on TM1Web and chart showed up as a placeholder indicating a missing link to resource.
After much cursing, it turned out to be hiding rows below the chart that broke it. Seems like a reasonable thing to do but no matter where I hid rows from, same results, broken graph. Left as unhidden, all works. HTH
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1Web Websheet Charts / Graphs not rendering
To add to this I have seen a similar thing but in my experience you can get away with some hiding but you need a good but varying number of visible rows.
So I have had it work where there is a chart (or charts) a number of hidden rows of data (that the chart is based on) then say 20 visible but empty rows. Then hide all the rows below that like I normally do with Web sheets, just in case... saying that the hiding extra rows isn't really a problem any more but in old versions the web did sometimes decide to try and render them when left visible; haven't seen it in 10.2.2 or later doing that though.
So I have had it work where there is a chart (or charts) a number of hidden rows of data (that the chart is based on) then say 20 visible but empty rows. Then hide all the rows below that like I normally do with Web sheets, just in case... saying that the hiding extra rows isn't really a problem any more but in old versions the web did sometimes decide to try and render them when left visible; haven't seen it in 10.2.2 or later doing that though.
Declan Rodger
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: TM1Web Websheet Charts / Graphs not rendering
I am seeing this behaviour on 10.2.2 FP4 and PA 2.0.1.
In terms of leaving some visible but blank rows - I experiment with 5, 10, 20, 100 - seems to behave the same.
@Declan - would appreciate if you have 5 mins to create a basic chart like the one below-basically typed in some random numbers, highlighted, click on line chart, saved and uploaded then opened in TM1Web: Took the same workbook and hid from row 105 onwards, graph not rendered-only difference between 10.2.2 FP4 and PA is that PA does not show the placeholder when "broken": Thanks in advance
p.s. Book1 was with no rows hidden, chart.xlsx has hidden rows-apologies for poor naming.
In terms of leaving some visible but blank rows - I experiment with 5, 10, 20, 100 - seems to behave the same.
@Declan - would appreciate if you have 5 mins to create a basic chart like the one below-basically typed in some random numbers, highlighted, click on line chart, saved and uploaded then opened in TM1Web: Took the same workbook and hid from row 105 onwards, graph not rendered-only difference between 10.2.2 FP4 and PA is that PA does not show the placeholder when "broken": Thanks in advance
p.s. Book1 was with no rows hidden, chart.xlsx has hidden rows-apologies for poor naming.
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1Web Websheet Charts / Graphs not rendering
Haven't had a chance to do a proper test but had a look at a sheet I created for one of the models I am working with at the moment, when Infirst created it they were on an early FP of 10.2.2 (1 or 2) now they are on FP7 and it still works ok.
The part I had incorrectly remembered was that you do need to have the data cells that are the source for your chart visible... but when I say visible I just mean in the computers mind; on this one I made it a white font on a white background, no grid lines and whacked the row height down to super tiny. Essentially it looked like 1 standard rows height and was the buffer before my page border I had put on but it actually contained 15 or so rows of data.
I have done a similar thing with columns previously where the data for charts was off to the right of the page.
In addition to that I have some unhidden rows under the chart because although they have nothing in, the chart seems to need a bit of extra space to render correctly; despite it appearing the correct size and in the right place in the web.
The part I had incorrectly remembered was that you do need to have the data cells that are the source for your chart visible... but when I say visible I just mean in the computers mind; on this one I made it a white font on a white background, no grid lines and whacked the row height down to super tiny. Essentially it looked like 1 standard rows height and was the buffer before my page border I had put on but it actually contained 15 or so rows of data.
I have done a similar thing with columns previously where the data for charts was off to the right of the page.
In addition to that I have some unhidden rows under the chart because although they have nothing in, the chart seems to need a bit of extra space to render correctly; despite it appearing the correct size and in the right place in the web.
Declan Rodger
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: TM1Web Websheet Charts / Graphs not rendering
Thanks Declan, I generally do the same with the white font rather than change the chart options to allow data in hidden ranges.
Just not getting the expected results on my side.
Just not getting the expected results on my side.
- rafaewolie
- Posts: 22
- Joined: Wed May 11, 2016 2:16 pm
- OLAP Product: IBM Cognos TM1
- Version: TM1 PA 2.0
- Excel Version: Excel 2013
- Location: Anywhere, BR
- Contact:
Re: TM1Web Websheet Charts / Graphs not rendering
Did You check If the Hidden options are selected on Select Data option on the chart setup?
like the atachment
like the atachment
- Attachments
-
- erro-graf.png (4.56 KiB) Viewed 23050 times
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: TM1Web Websheet Charts / Graphs not rendering
Hi Rafaewolie, thanks for the suggestion but unfortunately this is one of the things I tried without success. For now I am making sure that I delete "unused" rows and columns then hide the columns only. Seems fine for web purposes as web seems to only work with the used range in the sheet.rafaewolie wrote: ↑Wed Sep 06, 2017 6:23 pm Did You check If the Hidden options are selected on Select Data option on the chart setup?like the atachment
- rafaewolie
- Posts: 22
- Joined: Wed May 11, 2016 2:16 pm
- OLAP Product: IBM Cognos TM1
- Version: TM1 PA 2.0
- Excel Version: Excel 2013
- Location: Anywhere, BR
- Contact:
Re: TM1Web Websheet Charts / Graphs not rendering
Another thing that I noticed is that, When the last row of some perspectives are hidden, the TM1Web counts 3 or 4 (I'm not sure of the number) rows and then cuts the rest of the hidden lines. I think in that case, the suggestion that Declanr gave You about the white font in white BG Will function, at least to make TM1Web consider the hidden lines. Put a character in a row below the hidden rows.
Another possible solution would be to reduce the row height to 2px. It does not show the content on the screen , but the computer considers this row as unhidden.
Does It make sense?
Another possible solution would be to reduce the row height to 2px. It does not show the content on the screen , but the computer considers this row as unhidden.
Does It make sense?
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: TM1Web Websheet Charts / Graphs not rendering
Thanks for testing this out-Will try it again but did not seem to work whether I left 5, 50, 100 or more rows before hiding.
- rafaewolie
- Posts: 22
- Joined: Wed May 11, 2016 2:16 pm
- OLAP Product: IBM Cognos TM1
- Version: TM1 PA 2.0
- Excel Version: Excel 2013
- Location: Anywhere, BR
- Contact:
Re: TM1Web Websheet Charts / Graphs not rendering
Not before, but After.
Put some character like the picture that I Attached.
![Image](%5Battachment=0%5Derro-graf2.png%5B/attachment%5D)
The Hidden part is in red, so After that You put some character to paint with White color just to not show It to user.
And Then, TM1Web consider the row that contains "Character that Will garantee that the TM1Web Will read until here" as the last row
got It?
Put some character like the picture that I Attached.
![Image](%5Battachment=0%5Derro-graf2.png%5B/attachment%5D)
The Hidden part is in red, so After that You put some character to paint with White color just to not show It to user.
And Then, TM1Web consider the row that contains "Character that Will garantee that the TM1Web Will read until here" as the last row
got It?
- Attachments
-
- erro-graf2.png (9 KiB) Viewed 22991 times