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?
Publishing an Excel Spreasheet on TM1Web
-
- Site Admin
- Posts: 1453
- Joined: Wed May 28, 2008 9:09 am
Re: Publishing an Excel Spreasheet on TM1Web
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.
- 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
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
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
- 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
Create a Subset via MDX which filters Measure <>0, then use this Subset in a view to snapshot your Excelsheet
-
- Posts: 51
- Joined: Thu Jul 24, 2008 6:14 am
Re: Publishing an Excel Spreasheet on TM1Web
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
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
-
- 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
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.
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.