How to show selected Level and Next two levels in the Report

[Kiran Kandavalli]

Team,

I have a requirement as below.

1) In Crosstab Rows I am showing Level Names.

2) In Crosstab Measures I am showing ratings like 'High', 'Low' , "Medium'.

3) If user selects Level 3 in Cognos tree Prompt,

4) The Report will show Level 3 and Level 4 with Ratings as mentioned above.

5) If the both the levels have rating then we will display Level 3 and Level 4 in the report

6) If the both the levels does have rating then we will not display Level 3 and Level 4 in the report.

7) If Level 3 does not rated and level 4 has rated then we will level 3 will blank row and level 4 with Ratings.

8) If Level 3 is  rated and level 4 has not rated then we will show level 3 with ratings and blank row with level 4. then we will go one step down to level 5 and display if they are ratings otherwise we will stop here at this level.

Please suggest me how to achieve this.

Thanks!
Kiran

[BigChris]

You probably need to combine filter and children expressions...

[Kiran Kandavalli]

Chris, could you please provide me the expression please.

Also, let you know the tree prompt is multi select.

[MFGF]

Hi,

This appears to be an exact duplicate of your previous thread:

http://www.cognoise.com/index.php/topic,30856.html

Please do not double-post like this. Please read the Forum Etiquette post, paying close attention to point 4:

http://www.cognoise.com/index.php/topic,24030.0.html

MF.

[Kiran Kandavalli]

Hi, that is another requirement. Here only two children will be shown for selected level. Also based on condition we will show.

[Lynn]

It certainly sounds very similar to the other post. What expressions are you using there? If you post that it could be easier for people to guide you with an adapted approach.

It would also be useful if you provided an example of your hierarchy that illustrates the levels and the members within. I found it confusing in your last post.

Lastly, please clarify this point:

2) In Crosstab Measures I am showing ratings like 'High', 'Low' , "Medium'.

Measures are numeric values, not words like 'High', 'Low' , "Medium'. Generally the intersection of a crosstab can only contain numbers, not words, although there are techniques that make use of conditional styling to achieve this. What is it that you have on columns and what is it that you have on the intersection?

[Kiran Kandavalli]

Hi Lynn,

My Report Template is as below.

1) I am using ABC Hierarchy in Crosstab Rows.

2) In Columns I am just showing two Texts as Columns lets says 'Rating Column 1', 'Rating Column 2'

3) In Crosstab measures.

     a) yes, generally measures will be shown in Crosstab Measures, but I set the property 'Define contents' to 'Yes' for these two columns and I am dragging those respective Rating Columns in Measure cells. So we can see ratings in Crosstab measures.

    b) Each Rating columns will have 'High', 'Low', 'Medium' Values

4) Now we need to show 'ABC Hierarchy' Based on my first post.

Please suggest me.

   
Thanks!
Kiran