What does this rule mean?

Post Reply
kiss351523
Posts: 51
Joined: Thu May 05, 2011 2:05 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007 and 2003
Location: Asia

What does this rule mean?

Post by kiss351523 »

Deal All:

In TM1 Samples,SData server,SalesPriorCube'rule:

Code: Select all

 ['Dec'] = n:1. + ['jan'] + ['feb'];
what does this mean?
TKS!
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: What does this rule mean?

Post by Duncan P »

The best thing you can do is to read the TM1 Rules Guide - all of it - trying it all out in TM1 as you go along.
You will find it here - http://publib.boulder.ibm.com/infocente ... 1_rul.html.

The page that addresses exactly this kind of rule is here - http://publib.boulder.ibm.com/infocente ... D0096.html.
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: What does this rule mean?

Post by ioscat »

Безымянный4.png
Безымянный4.png (10.71 KiB) Viewed 2869 times
kiss351523
Posts: 51
Joined: Thu May 05, 2011 2:05 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007 and 2003
Location: Asia

Re: What does this rule mean?

Post by kiss351523 »

ioscat wrote:
Безымянный4.png
TKS!
Whats the different with add "." behind the "1" or not?
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: What does this rule mean?

Post by qml »

kiss351523 wrote:Whats the different with add "." behind the "1" or not?
No difference.

1. = 1 = 1.0 = 1.00 = 1.000
Kamil Arendt
Post Reply