If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Hey Issue on drill up's and drill down's in Cognos 8 BI Report studio?

Started by ranne_78, 11 Sep 2006 06:34:51 PM

Previous topic - Next topic

ranne_78

Hey Guys

we r using Cubes as a data suource forÃ,  creating reports having promptsÃ,  in Report Studio.
I created a report withÃ,  prompt (tree prompt) on one dimension having 5 levels is working well with drill behavior(drill up's and down's )in the result. But dimension having 14 levels is not working with drill behavior(drill up's and down's). Is that more levels have any impact on Drill behavior. Help me to solve this issue.

LookingÃ,  forward to get a clue on this issue.

Thanks,

Ã,  Ã, 

dimi

Hi
Do you mean you're having problems drilling up/down in the tree prompt or in the crosstab?

ranne_78

Hey Dimi,

When I created report with out prompt it was working fine with drill behavior but I  created  a report with prompt it was displaying in the cognos viewer Only prompted item details with out name of the  object . But I want to get it with name as well as drill behavior.
I am getting result as follows

Project Cost (Rounded) Oct Nov Dec Jan Feb Mar Apr May 2005
More 0 0 0 0 0 0 0 0 0
All Projects 16,346,184 41,771,890 37,688,005 40,605,007 41,949,671 46,007,540 39,952,050 46,081,240 310,401,586
but I want   as follow with particular prjid which Iam selecting in prompt and with drill behavior for that project by drilling up which will go to the immediate parent.

Project Cost (Rounded) Oct Nov Dec Jan Feb Mar Apr May 2005
0 0 0 0 0 0 0 0 0
4422108 pri 6e 346,184 41,771,890 37,688,005 40,605,007 41,949,671 46,007,540 39,952,050 46,081,240 310,401,586

Thanks,