Excel New Slice Contents

[kwakkers]

Good morning all

TM1 Client 9.4.1

Apologies if this has been answered before, but I can't seem to get the right answer from searching the forums.

We have a view (monthly) that we slice to Excel (zero suppression), that returns the required data set for the month. This is an entirely manual process.

However in subsequent months simply recalulating the slice will not return any rows that:

• were previously 0
  new

Is there a way to get the slice to recalculate and return the most upto date information automatically (including any rows that were prviously suppressed (0)), or do we have to open the view, recalculate and the slice it back out manually?

I hope I am making sense - and thanks for any help you may be able to provide.

[asutcliffe]

Have a look at active forms. Essentially they allow you to create a report with a dynamic list of rows.

http://publib.boulder.ibm.com/infocente ... 80007.html

[kwakkers]

Howzit

Thanks for the speedy reply - much appreciated. I've had a quick look and it looks like it could be just what I am after.

I guess I know what I'll be doing this weekend...