Publishing an Excel Spreasheet on TM1Web

Post Reply
rossi
Posts: 29
Joined: Tue Jun 10, 2008 8:50 pm
Location: London UK

Publishing an Excel Spreasheet on TM1Web

Post by rossi »

Is there a way to publish an Excel spreadsheet out through the web that has zero suppression on it. For Example

Country UK

Product1 10
Product2 0
Product3 20

When I change the country to US and there are numbers in Product 2 and 3, they appear but product 1 filters out.

Any ideas?
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: Publishing an Excel Spreasheet on TM1Web

Post by David Usherwood »

Depends on your version. For 9.1, there was dynamic slices, which did that, but wasn't amazingly stable. For 9.4, there is (now) Active Forms, which does that. It's quite new though and we don't (yet) recommend it for production use.
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: Publishing an Excel Spreasheet on TM1Web

Post by Eric »

I think Ben Hill did some pressure testing on active forums and was impressed. However, I do recall the InSpreadsheet browser performance being better (not really relevant since you asked about Web, but threw it out there anyways)
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
User avatar
Roger_Lewin
Posts: 17
Joined: Mon Nov 03, 2008 8:25 am
Version: 9.4 MR1 FP1
Excel Version: 2003
Location: Ratingen, Germany
Contact:

Re: Publishing an Excel Spreasheet on TM1Web

Post by Roger_Lewin »

Create a Subset via MDX which filters Measure <>0, then use this Subset in a view to snapshot your Excelsheet
Lukas Meyer
Posts: 51
Joined: Thu Jul 24, 2008 6:14 am

Re: Publishing an Excel Spreasheet on TM1Web

Post by Lukas Meyer »

If Rogers approach is too static (when having multiple columns and rows that should be zero-suppressed) use an action-button to run a process which creates the necessary subsets. simply name the subsets after the user calling the process (using TM1USER on TI side and TM1USER(server_as_string) on Excel side) generates some nice subsets - you can't have enough of those!
I think you need 9.1+ to have an Action Button and TM1USER (on either side :) )
afaik is TM1USER as TI-constant (well, it isn't that constant, is it?) not documented and might stop working in later versions :) (which would make me a very sad developer since I would have to add extra parameters and going crazy sooner or instantly ;) )

This leads me again to an incredibly stupid idea I have and want to do - insert the name of the created subset in a garbage-collection dimension and having a chore running deleting the referenced elements every now and then ... who needs a clear and readable message log anyways?

Lukas
ScottW
Regular Participant
Posts: 152
Joined: Fri May 23, 2008 12:08 am
OLAP Product: TM1 CX
Version: 9.5 9.4.1 9.1.4 9.0 8.4
Excel Version: 2003 2007
Location: Melbourne, Australia
Contact:

Re: Publishing an Excel Spreasheet on TM1Web

Post by ScottW »

Hmmm

I've always used the approach of having some kind of standard naming prefix, followed by user name, TI process name, datestamp, whatever, to make sure the subset name is unique for those instances where you can't create and destroy a subset in the same process, that is the returned subset needs to be used by a user say from a drill process or action button to build a subset from parameters defined on a report. This works fine combined with a TI to run periodically to clean up the subsets by searching the directory structure for .sub files matching the starting prefix and deleting them. However, Lukas's idea of a "garbage dimension" is very interesting, would certainly simplify to process of cleaning up unwanted objects. Will have to think about this and perhaps try it out.
Cheers,
Scott W
Cubewise
www.cubewise.com
Post Reply