Embedding Multiple Spreadsheets in HTML for TM1web

Post Reply
alimurat
Posts: 18
Joined: Mon Sep 14, 2009 4:04 pm
OLAP Product: TM1
Version: 10 2 2 FP3
Excel Version: 2010

Embedding Multiple Spreadsheets in HTML for TM1web

Post by alimurat » Thu Mar 04, 2010 6:07 pm

I've been trying to embed multiple spreadsheets (3-4) using iframe into an HTML file and view them in a single screen in TM1web. One of and the main reason for trying to do this is the performance issues we're facing while trying to load the data into a single spreadsheet from several cubes in TM1 and also trying to write back to TM1. Current spreadsheet uses a lot of data validation, drop down values that are dynamically populated driven by user security.

Using iframe only allows us to embed files in html format and by doing that we lose functionality of the spreadsheet. Anyone here tried to embed multiple spreadsheets and were able to keep TM1web functionality? If so how?

Thanks in advance...

User avatar
LoadzaGrunt
Posts: 72
Joined: Tue May 26, 2009 2:23 am
Version: LoadzaVersions
Excel Version: LoadzaVersions

Re: Embedding Multiple Spreadsheets in HTML for TM1web

Post by LoadzaGrunt » Thu Mar 04, 2010 10:33 pm

I've been trying to embed multiple spreadsheets (3-4) using iframe into an HTML file and view them in a single screen in TM1web.
Did you publish your custom HTML page as an 'application' ? Otherwise I don't see why you would be trying to use TM1 Web.
Using iframe only allows us to embed files in html format and by doing that we lose functionality of the spreadsheet. Anyone here tried to embed multiple spreadsheets and were able to keep TM1web functionality? If so how?
If you are using the TM1 Web URL API correctly, then it is possible to have four websheets in four iframes in one custom page. What you won't get is the TM1 Web 'wrapping' without further effort.

alimurat
Posts: 18
Joined: Mon Sep 14, 2009 4:04 pm
OLAP Product: TM1
Version: 10 2 2 FP3
Excel Version: 2010

Re: Embedding Multiple Spreadsheets in HTML for TM1web

Post by alimurat » Thu Mar 04, 2010 11:36 pm

Did you publish your custom HTML page as an 'application' ? Otherwise I don't see why you would be trying to use TM1 Web.
No, actually I used it as a home page for users by changing the webconfig file.
If you are using the TM1 Web URL API correctly, then it is possible to have four websheets in four iframes in one custom page. What you won't get is the TM1 Web 'wrapping' without further effort.
Do you have any examples you can share? I tried going through TM1 developer documentation, but couldn't figure it out...

User avatar
LoadzaGrunt
Posts: 72
Joined: Tue May 26, 2009 2:23 am
Version: LoadzaVersions
Excel Version: LoadzaVersions

Re: Embedding Multiple Spreadsheets in HTML for TM1web

Post by LoadzaGrunt » Fri Mar 05, 2010 2:33 am

I actually found the reference material on the TM1 URL API helpful. This was a pleasant suprise as sometimes TM1 documentation can be a little underwhelming.

I that when developing with the TM1 Web URL API, it's best to start off slowly with a simple requirement like just getting one page with one websheet, or one cubeview, up and running.

alimurat
Posts: 18
Joined: Mon Sep 14, 2009 4:04 pm
OLAP Product: TM1
Version: 10 2 2 FP3
Excel Version: 2010

Re: Embedding Multiple Spreadsheets in HTML for TM1web

Post by alimurat » Fri Mar 05, 2010 4:11 pm

After going through the documentation(again) got it to work last night... I'm a happy camper :)

nicola531
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: Embedding Multiple Spreadsheets in HTML for TM1web

Post by nicola531 » Mon Apr 12, 2010 10:31 pm

I've got the same issue but actually i haven't found yet a solution.
I haven't understood what you're talking about? what is Iframe? could you give pls me and input in order to understand where to find a possible solution to fix this prob?


thanxs in advance,

Nicola

User avatar
LoadzaGrunt
Posts: 72
Joined: Tue May 26, 2009 2:23 am
Version: LoadzaVersions
Excel Version: LoadzaVersions

Re: Embedding Multiple Spreadsheets in HTML for TM1web

Post by LoadzaGrunt » Mon Apr 12, 2010 11:20 pm

I haven't understood what you're talking about? what is Iframe? could you give pls me and input in order to understand where to find a possible solution to fix this prob?
You could start by teaching yourself HTML:
http://www.w3schools.com/html/default.asp

nicola531
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: Embedding Multiple Spreadsheets in HTML for TM1web

Post by nicola531 » Tue Apr 13, 2010 9:15 am

Txs!!! :)

it works ....

I teached myself it !!:)

nicola531
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: Embedding Multiple Spreadsheets in HTML for TM1web

Post by nicola531 » Wed Apr 14, 2010 11:19 am

Hello,

I've got a question again if you can.
I've done this htm page with two iframes. Each iframe contains one cubeview.
Whe from archietect, under my application try to launch the htm file it works and it shows me the two file in one html file.
But when I got to Tm1Web and i try to run it open it but after a second it appers a message that says "The action was aborted".
Why I'm not able to do it?
Is it a problem of security?

Any idea?

Nicola

nicola531
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: Embedding Multiple Spreadsheets in HTML for TM1web

Post by nicola531 » Wed Apr 14, 2010 11:36 am

sorry the actual message is "the thread was being aborted"

thnaks in advance for any help

Post Reply