Drill down to the lowest level then drill-through

[sashafay]

Hi - I have couple of questions here, hope one of them at least can be resolved:

1. Can I disable drill-through from the parent level and only do it from the lowest level instead? Basically I have a cube based report and users drilling down on Date dimension Year>Quarter>Month>Day, very common structure. I want user to drill-down when they click on the date and not drilling-through as happening by default when user click on desire date field now after I added it. I want users to drill-through only on Day level, lowest level in my Date dimension.
2. Can I control drilling default behavior when user click on the dimension? As soon as I enabled drill-through, drill-down/up only available on right-click, but I want to keep drilling down as my primary behavior and drilling through to another report only on the right click. Is this possible?

I am using Cognos 10.2 and Transformer Cube as my report source.

Hope I explain this clear, but please let me know if something isn't very clear what I am trying to do here.

Thank you in advance for your input!

[sashafay]

No one ever encounter this problem before? I just can't believe it I am the only one who's trying this resolve this... Thanks!

[MFGF]

No one ever encounter this problem before? I just can't believe it I am the only one who's trying this resolve this... Thanks!

Hi,

To answer these two questions in order:

1. Yes.
2. You're not.

I posted a step-by-step solution, including a sample report XML spec to show how it's done, on these self same Cognoise forum pages a while ago. A quick search would have led you straight to the post, and right now you'd probably be off working on other stuff having implemented the solution you're still seeking.

Here's the post. You should try the Search option on the forum next time, though - it's really rather good.

http://www.cognoise.com/community/index.php/topic,19458

Cheers!

MF.

[sashafay]

Thank you MF! I wish I would always know which keyword I should use to find those answers. Title for your old post/reply wasn't very clear and straight forward, at least for me... anyway, thanks again for pointing on this! I will try your solution first thing in a morning.