Picklist don't retrieve value

[d.donofrio]

Hi all,
I have a problem with an element of dimension that has attribute picklist.
I created a cube for calulate Depreciation. the cube depreciation has 2 dimensions: depreciations and Months.
I created a text attribute called 'Picklist' for the dimension depreciation. It is a "dimension picklist" written against a dimension that has three elements: Straight, Sum, Balance. The element to which this picklist is assigned has been designated a "string" element and called Method.
My problem is in the calculation of Depreciation that return always 0.
the following code in TM1 9.5 in rule of depreciation's cube.


#Straight Line
['Straight']=N:['Cost','Jan']\['Life','Jan']*(['Periodic']\365);
#sum of Year
['Sum']=N:(['Cost','Jan']*['Life','Jan'])/int((['Life','Jan']*['Life','Jan']\2+ (['Life','Jan']\2)));
#depreciation balance
['Balance']=N: ['Cost','Jan']*['Life','Jan']/100 *['Periodic']\365;
['Depreciation']=N: if (ATTRS('Depreciation', 'Method', 'picklist')@= 'Straight',
['Straight'],
if (ATTRS('Depreciation', 'Method', 'picklist')@= 'Sum',
['Sum'],
if (ATTRS('Depreciation', 'Method', 'picklist')@= 'Balance',
['Balance'],0)));
#region feeders;
FEEDERS;
['Life']=> ['Depreciation'],['Straight'],['Sum'],['Balance'];
#end region;

Please help me
tm1 9.5 I don't retrieve element of picklist
Sent: Mon May 31, 2010 9:48 am
by d.donofrio

Hi Martin,
I have a problem with an element of dimension that has attribute picklist.
I created a cube for calulate Depreciation. the cube depreciation has 2 dimensions: depreciations and Months.
I created a text attribute called 'Picklist' for the dimension depreciation. It is a "dimension picklist" written against a dimension that has three elements; Straight, Sum, Balance. The element to which this picklist is assigned has been designated a "string" element Method.
My problem is in the calculation of Depreciation that return always 0.
the following code in TM1 9.5 in rule of depreciation's cube.


#Straight Line
['Straight']=N:['Cost','Jan']\['Life','Jan']*(['Periodic']\365);
#sum of Year
['Sum']=N:(['Cost','Jan']*['Life','Jan'])/int((['Life','Jan']*['Life','Jan']\2+ (['Life','Jan']\2)));
#depreciation balance
['Balance']=N: ['Cost','Jan']*['Life','Jan']/100 *['Periodic']\365;
['Depreciation']=N: if (ATTRS('Depreciation', 'Method', 'picklist')@= 'Straight',
['Straight'],
if (ATTRS('Depreciation', 'Method', 'picklist')@= 'Sum',
['Sum'],
if (ATTRS('Depreciation', 'Method', 'picklist')@= 'Balance',
['Balance'],0)));
#region feeders;
FEEDERS;
['Life']=> ['Depreciation'],['Straight'],['Sum'],['Balance'];
#end region;

Please help me

[d.donofrio]

Hi all,
I have a problem with an element of dimension that has attribute picklist.
I created a cube for calulate Depreciation. the cube depreciation has 2 dimensions: depreciations and Months.
I created a text attribute called 'Picklist' for the dimension depreciation. It is a "dimension picklist" written against a dimension that has three elements; Straight, Sum, Balance. The element to which this picklist is assigned has been designated a "string" element Method.
My problem is in the calculation of Depreciation that return always 0.
the following code in TM1 9.5 in rule of depreciation's cube.


#Straight Line
['Straight']=N:['Cost','Jan']\['Life','Jan']*(['Periodic']\365);
#sum of Year
['Sum']=N:(['Cost','Jan']*['Life','Jan'])/int((['Life','Jan']*['Life','Jan']\2+ (['Life','Jan']\2)));
#depreciation balance
['Balance']=N: ['Cost','Jan']*['Life','Jan']/100 *['Periodic']\365;
['Depreciation']=N: if (ATTRS('Depreciation', 'Method', 'picklist')@= 'Straight',
['Straight'],
if (ATTRS('Depreciation', 'Method', 'picklist')@= 'Sum',
['Sum'],
if (ATTRS('Depreciation', 'Method', 'picklist')@= 'Balance',
['Balance'],0)));
#region feeders;
FEEDERS;
['Life']=> ['Depreciation'],['Straight'],['Sum'],['Balance'];
#end region;

Please help me