As I am aware , when I drag and drop the crosstab to a worksheet , you could directly update those cell without formula like it did in pespective .
Understand CAFE
-
hyunjia
- Posts: 64
- Joined: Fri Jul 27, 2012 4:13 pm
- OLAP Product: TM1
- Version: 2010
- Excel Version: Excel 2010
Understand CAFE
Hi , this may be a silly question , but I am new to the CAFE . Just wondering how I could distinguish the cell which is driven by CAFE and which is not ?
As I am aware , when I drag and drop the crosstab to a worksheet , you could directly update those cell without formula like it did in pespective .
As I am aware , when I drag and drop the crosstab to a worksheet , you could directly update those cell without formula like it did in pespective .
-
RJ!
- Community Contributor
- Posts: 219
- Joined: Mon Jul 23, 2012 8:31 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Understand CAFE
Once you drag a cell away from the cross tab it's going to be nigh impossible unless you change part of the filters etc.
I'd recomend colour coding any cells that are driven by CAFE for ease of review/audit. That way when you move them, it's easier to know what is linked.
I'd recomend colour coding any cells that are driven by CAFE for ease of review/audit. That way when you move them, it's easier to know what is linked.