Too long visualization time

Post Reply
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Too long visualization time

Post by ioscat »

When I ask my TM1 to build 3D view it takes two steps. First - it shows picture in "fogged' mode; and Second - it takes a long time before showing it again (in normal, contrast mode).
Is it bug or our developing mistake somewhere?
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Too long visualization time

Post by Martin Ryan »

Sounds like you might have a rule that hasn't been fed properly, or at all. Can you post the rule for this cube?

Also a screenshot of the cube structure, showing which dimensions make up the cube, would be handy.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: Too long visualization time

Post by ioscat »

1) there no feeders at all
2) I'm not sure it is possible to paste here client data.
Here is combination of screens I see when making 3D chart:
3d_tm1.png
3d_tm1.png (171.71 KiB) Viewed 5702 times
While making this chart my browser asks me for several times to stop script. I ckick decline to get result picture, but it compiles (as it seems to me) too long.
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Too long visualization time

Post by lotsaram »

I suggest you (or more likely whoever is specifying report and chart types on your project) to go read up on Tufte, Hichert and Few (a new version of Show Me the Numbers is out ...) and make an effort to present data in a more clear and meaningful way. BUT the god awful choice of junk chart isn't likely to be your problem but rather a poorly written calculation. If you are serious about getting help then you need to post the rule and not the chart.
Gregor Koch
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: Too long visualization time

Post by Gregor Koch »

Really don't mean to crush the chart and I agree with lotsa that it most likely is not the issue. But I can't help myself, this looks like a flight game from the 80s or a mixture between Super Saxxon and Root Beer Tapper.
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Too long visualization time

Post by Martin Ryan »

ioscat wrote: 2) I'm not sure it is possible to paste here client data.
If you can't paste the data then we're unlikely to be able to assist.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: Too long visualization time

Post by Olivier »

this looks like a flight game from the 80s or a mixture between Super Saxxon and Root Beer Tapper
These games were great :)
HTH
Olivier
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Too long visualization time

Post by David Usherwood »

@ioscat, we don't need the data, just the rules.
But I'll stick my neck out and surmise that you aren't using skipcheck (and feeders) so you aren't taking advantage of TM1's sparsity handling. This will not work.
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: Too long visualization time

Post by ioscat »

Hello to all. Thanks for your comments, spent a lot of time to translate all your "But I'll stick my neck out and surmise" and "But I can't help myself" and other. =)
Just asked my Boss, he didn't approved publication. But I can answer for question
David Usherwood wrote:But I'll stick my neck out and surmise that you aren't using skipcheck (and feeders) so you aren't taking advantage of TM1's sparsity handling
SkipCheck is used.
In addition I can say that calculations and recalculations goes fast enough (17 MB memory used). Maybe it is not properly fed, but is it possible to estimate feed rightness? An example by comparing two cell statictics numbers.
Maybe if I repeat this problem on sample model I'll post here rules. So on today topic should be temporaly stopped to not be trashed.
Post Reply