TM1 cognos Integration Issue

[sudhimn@yahoo.com]

Hi,
I am working on various Cognos BI tools since 4 years but TM1 is very new to me.

I have few issues in TM1 which has stopped my development activities.

It would be great if you can help to get any of these resolved..

1) Data issue:

The Cube which I have built looks good in Tm1 architect and also perspectives but the same cube doesn't show any data in cognos.

My cube has 8 dimensions and around 46 measures,when this cube is published onto cognos and I check the values for only one dimension it shows 0 values.
If I add all 7 seven dimensions as filters and filter the data based on member elements it shows data (correct data) even in cognos.
I think this issue is because of huge volume,TM1 selects some default values once the cube is built..
I have explained everything with screenshots in the attached document.

Request you to please advice me on this.
I can do net meeting and show you the issue if you have few mins.

2) Can we get drill up/down in excel reports developed using perspectives of TM1.
If you have implemented the same or if can share any document regarding the same would be great.

Thanks a lot for your valuable time.

[Marcus Scherer]

Hi,
you may set the default memeber for each dimension in the cube "}HierarchyProperties". The according dimension "}HierarchyProperties" contains an element "defaultMember". This might help you in creating reports, if many of them have some default members in common. see attachment.

Nevertheless, when building your reports you have to take all eight dimensions of your cube into account. If you have built an eight-dimensional cube you had your reasons to do so. You can't ignore some of it when analyzing cell values. In Report Studio you can't just insert three dimension elements and hope that the software reads your thoughts and completes the remaining five.

HTH,
Marcus

[sarahmilius]

on (1) I would echo Marcus' comment and add that in the }Hierarchy Properties control cube you may also have to input a name for each level of each dimension before publishing in Framework Manager for the cube you are reporting from in Cognos. I am not sure in 9.5 whether IBM Cognos has made this cube more intuitive, but in 9.4 in this control cube, Level 0 pertains to the top-most level of a dimension and is not necessarily the leaf level (it would be in a dimension that only has simple n elements).

on (2) I know that Active Forms (the newer version of dynamic slicing to Excel) enable drill up and down (aka collapse/expand) for dimension rollups on Rows. Collapse/expand is still not available for columns in the Active Form.

regards,
Sarah

[sudhimn@yahoo.com]

Thanks everyone.Your input helped me to complete the cube build process properly ..