TM1 Forum

Posted: **Thu Nov 27, 2014 4:08 pm**

Hi

I'm studying IBM Cognos TM1 - official guide, and i have problem witch rule in chapter 18 (production planning).
Maybe somebody had same issue.

The rule:

Code: Select all

Skipcheck;				
['No Article','Secondary Demand']=N:DB('SL Demand 2''Total',!SL Articles,!SL Demand,!SL Periods,!SL Types);

['Secondary Demand']= N:DB('SL Demand 2',!SL Articles,!Sl Article Child,'BOM',attrs('SL Periods',!SL Periods,'Ref'),!SL Types)*
DB('SL Demand 2',!SL Articles,'NoArticle.','Demand',!SL Periods,!SL Types);

feeders;

['BOM','Value']=>['Secondary Demand'];
['SL Articles':'Total']=>DB('SL Demand 2',!Sl Article Child,'No Article',!SL Demand,!SL Periods,!SL Types);

I think prolem is in attrs('SL Periods',!SL Periods,'Ref') - i don't know what is in attribute Ref and i can't find it in book.

Posted: **Sat Nov 29, 2014 9:29 am**

Just from a read of it, it's not totally intuitive, but it reads that the 'SL Periods' dimension has an attribute 'Ref' which should contain a value that matches another element in the 'SL Periods' dimension'. It's common for time dimensions to have attributes that refer to elements within the dimension e.g. prior period, next period, 'parent' period (i.e. for a month, what is my year) - that sort of stuff. Maybe 'SL Periods' has a special 'null' element where 'default' data is stored e.g. if no-one makes an input in a month then default to the value in the 'null' month. Personally, that design approach is not my cup of tea, but it's not out of the ordinary either.

So... this leads me to the point that if you're just reading from the book, then you might have a problem - you're probably supposed to analyse the code at the same time as working with a live version of the instance. That way you can rule trace, check attributes, view cube data etc. The rule tracer should show the value for 'Ref' in context of the cell you're looking at.

Posted: **Mon Dec 01, 2014 10:42 am**

It work's

There are mistakes in book sample OMG

TM1 Forum

IBM Cognos TM1 - official guide - problem with rule

IBM Cognos TM1 - official guide - problem with rule

Re: IBM Cognos TM1 - official guide - problem with rule

Re: IBM Cognos TM1 - official guide - problem with rule