IBM Cognos TM1 10.1 Developer Sample Question

Post Reply
mukeshrajdass
Posts: 36
Joined: Tue Sep 07, 2010 11:34 am
OLAP Product: Cognos TM1
Version: 10-2-2
Excel Version: 2014

IBM Cognos TM1 10.1 Developer Sample Question

Post by mukeshrajdass »

Exam COG-702
IBM Cognos TM1 10.1 Developer


Just looking at the sample question on IBM website...one of the question looks odd...According to the website the correct answer is 1A...I thought is should have been 1C ? Have i missed something
because the child elements (Frog & Salamander) should be a numeric element parented to a consolidated element ? Did i miss an elephant standing next to me ?

Thx

1. You are developing a TM1 model for a city aquarium and need to add a new sub-category of
animals to the Animal dimension. The new elements are: Amphibians, Frog, and Salamander.
Assume that Amphibians is the parent of Frog and Salamander and you want the children to
automatically roll up to the parent. Which weighting and element type will you assign to
each element?
A. Amphibians Element Type = Consolidated (C), Weight 1 <--IBM site
B. Amphibians Element Type = Numeric (N), Weight 1<--should be this ?
C. Amphibians Element Type = String (S), Weight 1
D. Amphibians Element Type = Aggregate (A), Weight 1
Last edited by mukeshrajdass on Sun Aug 18, 2013 10:55 pm, edited 2 times in total.
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: IBM Cognos TM1 10.1 Developer Sample Question

Post by Alan Kirk »

mukeshrajdass wrote:Exam COG-702
IBM Cognos TM1 10.1 Developer


Just looking at the sample question on IBM website...one of the question looks odd...According to the website the correct answer is 1A...I thought is should have been 1C ? Have i missed something
because the child elements (Frog & Salamander) should be a string element parented to a consolidated element ? Did i miss an elephant standing next to me ?

Thx

1. You are developing a TM1 model for a city aquarium and need to add a new sub-category of
animals to the Animal dimension. The new elements are: Amphibians, Frog, and Salamander.
Assume that Amphibians is the parent of Frog and Salamander and you want the children to
automatically roll up to the parent. Which weighting and element type will you assign to
each element?
A. Amphibians Element Type = Consolidated (C), Weight 1 <--IBM site
B. Amphibians Element Type = Numeric (N), Weight 1
C. Amphibians Element Type = String (S), Weight 1 <--should be this ?
D. Amphibians Element Type = Aggregate (A), Weight 1
---------------------
Edit: Before anyone thinks that Declan and I have lost our minds, it may be noted from a comparison between the quoted block above and the current question that the OP has edited the latter to make it read quite differently from the originally posted one. It is in circumstances such as these that I'm quite glad that we both quoted the original question in line.
---------------------

Not wishing to be nasty, but why on earth would you assume it to be a string element? The element type depends on the data that is stores/calculates. So the name Amphibians may be a string, but it's dollars to donuts that Frog and Salamander will contain numeric data and that Amphibians will be consolidating that data. (Remember that the question says that you want the children to "roll up" to the parent; that's a slightly ambiguous expression since string children can still "roll up" to a parent (in the Subset Editor sense) though what I think is meant here is "aggregate"... and strings don't aggregate (by consolidation, anyway), only numbers do.) So yes, I would expect it to be a C type element.

In true Iboglix style, however, the answer is sloppy since a consolidation (indeed any element) does not have any intrinsic weight; its weight only exists relative to its parent, and a single element can have different weights for different parents.

The children of Amphibians need to have a weighting of 1. Amphibians itself probably has a weighting of 1 relative to at least one of its parents, if it has any. But the consolidation itself, like all elements, has no intrinsic weighting that means anything.

(Also the question asks for the "weighting and element type (for) each element", then goes on to ask about only one. :roll: That's unless there were subsequent questions based on the scenario, but there's still the issue of the weighting response for Amphibians being meaningless.)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: IBM Cognos TM1 10.1 Developer Sample Question

Post by declanr »

mukeshrajdass wrote:Exam COG-702
IBM Cognos TM1 10.1 Developer


Just looking at the sample question on IBM website...one of the question looks odd...According to the website the correct answer is 1A...I thought is should have been 1C ? Have i missed something
because the child elements (Frog & Salamander) should be a string element parented to a consolidated element ? Did i miss an elephant standing next to me ?

Thx

1. You are developing a TM1 model for a city aquarium and need to add a new sub-category of
animals to the Animal dimension. The new elements are: Amphibians, Frog, and Salamander.
Assume that Amphibians is the parent of Frog and Salamander and you want the children to
automatically roll up to the parent. Which weighting and element type will you assign to
each element?
A. Amphibians Element Type = Consolidated (C), Weight 1 <--IBM site
B. Amphibians Element Type = Numeric (N), Weight 1
C. Amphibians Element Type = String (S), Weight 1 <--should be this ?
D. Amphibians Element Type = Aggregate (A), Weight 1

Why do you think they should be string elements?

Keep in mind that string elements are only relevant when part of the last dimension in the cube (usually a measures dimension.) And irrespective of that, I can't see any part of the question that refers to storing of string information.
Declan Rodger
mukeshrajdass
Posts: 36
Joined: Tue Sep 07, 2010 11:34 am
OLAP Product: Cognos TM1
Version: 10-2-2
Excel Version: 2014

Re: IBM Cognos TM1 10.1 Developer Sample Question

Post by mukeshrajdass »

Appreciate the feedback...i wasn't questioning abt the 'Amphibian' parent type but the children itself....sorry i meant numeric..corrected by initial blog...

Thx
Post Reply