Having different level of element display on different colum

[winsonlee]

Unit Sales
Level 3 90
-- Level 2 90
---- Level 1.1 50
------- Level 0.1 10
------- Level 0.2 20
------- Level 0.3 30
---- Level 1.2 40
------- Level 0.4 40

Unit Sales
Level 3 Level 2 Leve 1.1 Level 0.1 10
Level 3 Level 2 Leve 1.1 Level 0.2 20
Level 3 Level 2 Leve 1.1 Level 0.3 30
Level 3 Level 2 Leve 1.2 Level 0.4 40


The first example is the defaut view of a cube. Is there any tool within cognos express that will allow me to display data like how the second example is ?
User would want to have the flexibility to export the second example data out to excel and does the analysis on excel because they are able to apply filter on the column.

I have look through xcelerator and advisor and neither of it gives me the out come that i wanted. It will be good if it provides an option to either expand downwards or expend sideway.
apparently cognos 7 power play have such functionality.

[rkaif]

Winson,

You can create an Attribute/Alias for the Dimension. This attribute will hold the Element names concatenated with the Parent names. Your Alias will look like:

Level 3 Level 2 Level 1.1 Level 0.1
Level 3 Level 2 Level 1.1 Level 0.2
Level 3 Level 2 Level 1.1 Level 0.3

Then you can use this Alias in your reports and by only selecting the 0-level elements.

[rkaif]

Another thing if you want to see the Level 3, Level 2 and Level 1 on separate columns in Excel then you can create 3 different attributes and use these attributes in the Active Form (or standard excel sheet) with DBRW() in it.

[winsonlee]

Winson,

You can create an Attribute/Alias for the Dimension. This attribute will hold the Element names concatenated with the Parent names. Your Alias will look like:

Level 3 Level 2 Level 1.1 Level 0.1
Level 3 Level 2 Level 1.1 Level 0.2
Level 3 Level 2 Level 1.1 Level 0.3

Then you can use this Alias in your reports and by only selecting the 0-level elements.

I thought about this to put all the the level into one attribute but user feels that there should be a proper way around to do it. The user uses powerplay before therefore already had an expectation that the new system that is put in should have identical feature as well. I was reading through the IBM Cognos BI V10.1 handbook. The outcome seems to be something i am looking for. It mention something about "Next Level Down" feature. I followed the same procedure mention but somehow the "Next Level Down" is grayed out and it doesn't allow me to click on it. I wonder if this feature is supported using TM1 data.

For this report, Lynn decides to use the Next Level Down approach. To
implement this approach, she performs the following steps:
1. Click one of the members in the Rows area.
2. On the top toolbar, click the Explore icon.
3. Click Create  Next Level Down (Figure 7-62).

[rkaif]

I thought about this to put all the the level into one attribute but user feels that there should be a proper way around to do it. The user uses powerplay before therefore already had an expectation that the new system that is put in should have identical feature as well.

Once you have implemented the Alias logic it will be just the matter of selecting that Alias in the Views. I don't think that selecting an Alias is too hard for any end-user. All the tools in market are different and when users shift from one tool to another they need to go through a bit of learning curve.