Perspectives vs Slice: Deprecated Features and Behaviour Differences

Arc & Slice
1

Hello everyone,

Is there a document that outlines which functionalities/features worked in Perspectives but are deprecated in Slice, or behave differently in Slice?

Thanks,
Pawan

2

Hi @Pawan ,

When discussing a feature list, the answer largely depends on how detailed you want that list to be. The short answer is that Slice supports most of the features available in Perspectives. However, you may encounter a few isolated features that are not available in Slice, since Slice and Perspectives use different APIs to connect to TM1. For example, although both Perspectives and Slice support custom consolidations, they handle and display them differently.

I hope this help,

Cheers,

Vincent

1 Like
3

Hello Vincent,

Can you please send me that list.

Thanks,
Pawan

4

Hi Pawan,

Like Vincent mentioned above, Custom-roll up is a big one. Apart from that : you have to carefully check about these functions, for example - with latest editon of Slice - we have various spread methods which are not supported by PAfE:

you can chek these 2 links:

I would definitely suggest to check these - specially nested Excel fomulas such as “LEFT,” within a DBRA or DBRW database call (also avoid functions like MID or RIGHT). A nested formula is where one function (like a LEFT function) is placed inside another function (such as a DBRA or DBRW).

Example like

To:

N4 is preformatted value of N6.

Watch out for unpredictable excel functions like : OFFSET, INDIRECT and SUMIF , perspective might be forgiving in these but I have seen lot of issues with Slice and PAfE.

TM1RPTFilter : Watch out for arguments inside and maybe extea curly braces if any in case of error, we have noticed when is no FUNCTION parameter provided.

Extra suggestions: Use the VIEW Function instead of simple cube references as The View function sets up an optimized view for a cube in memory so it can be referenced quicker when referred within the DBRW or DBR formula.

Big Cubes with 12,13 or 14 dimensions - when old way in perspectives - where Perspecives was handling this by adding extra brackets, if those reports are cheked in Slice - those DBRW refence will simply not work.

Circular refence was just ignored in Perspectives but not in Slice. You would have to correct it.

Cheers,

Vivek

1 Like
5

Thank you Vivek, I will check.

6

Hi @Pawan ,
Indeed Slice and Perspectives use different APIs to connect to TM1. So further to Vivek’s comments, the following blog outlines practical techniques for improving performance by identifying common bottlenecks. These include replacing multiple DBR formulas with DBRW to reduce server calls, as well as carefully managing, or removing where possible, unnecessary SUBNM formulas.

2 Likes