Drill-through???

[Stevennn]

Hello,
Seems to me so easy but it's not working the way Im doing it!
Im using an account tree in the report.
1st cube has 4 levels, 1-4. 2nd cube has 2 levels, 4-5.

1st level starts with All_Accts
I created a crosstab. Pulled couple of nodes from 2nd level and couple from 3rd level. drill-down enabled.
I created a drill through on the fact cells.
So i wanted the user to drill-down on account level and when he gets to the lowest level to drill-though on the amount (fact cell) but my accout is not passing any values.

I set a drill-though to pass the data-item value. I choose Acct_Level_4, because it is the lowest level in the account tree.

What else should i do in order the lowest account level to be passed?

THANK-YOU!

 

[Stevennn]

If anyone has any idea, can you please let me know!
Thank-you

 

[toddl]

What version of Cognos are you using?

Todd

 

[Stevennn]

Cognos 8.3!

 

[toddl]

What studios are you using? Are you going from analysis to report? Can you check the passed source value to see what is going through?

Todd

 

[Stevennn]

I’m using Report studio to Report studio. Both are cube reports.

When you set the drill-through I have to define what I will be passing from the report. I have two options parameter value which I don’t have for this report so I have to pass data item value.
But I have different tree levels in my report on the same page which data item value i have to pass. I tried to set up every level but it doesn’t work.

Thank-you for trying to help me!
Steven