Drill Through in Active Reports Visulaization and List

[Pratap Reddy]

Hi,

Q1.In my active tabbed report i have a requirement where i need to drill through or navigate from Tab1 to Tab 2 by clicking Visualization or List or Cross tab in tab1, it need to navigate/dril through to Tab 2 .Is it possible ?

Q2.Normally in an active report
a.In List if we apply drill though and uncheck 'Open in New Window'..child report is getting in the same window/Page
b.In Visualization if we apply Drill Through and uncheck 'open in New Window'...child report got opened in next tab of webpage..is it possible to open like list in the same window..

Thanks in Adavnce..

[MFGF]

Hi,

Q1.In my active tabbed report i have a requirement where i need to drill through or navigate from Tab1 to Tab 2 by clicking Visualization or List or Cross tab in tab1, it need to navigate/dril through to Tab 2 .Is it possible ?

Q2.Normally in an active report
a.In List if we apply drill though and uncheck 'Open in New Window'..child report is getting in the same window/Page
b.In Visualization if we apply Drill Through and uncheck 'open in New Window'...child report got opened in next tab of webpage..is it possible to open like list in the same window..

Thanks in Adavnce..

Hi,

You can have a container (list, crosstab, chart, visualization etc) set an active report variable - just use the Interactive Behaviour dialog to have the variable set to the specific value of the tab label you want to navigate to. As long as the Tab Control is listening to this variable it will react when it gets set.

Cheers!

MF.

[Pratap Reddy]

Hi MFGF,

Thank you for your Reply.

for example i have Three Tabs

In my three tabs i can navigate/drill through from Tab2 ---> Tab1 and Tab3---->Tab1.

If i create a connection from Tab4----->Tab2, it navigating to Tab1 and if i'm trying to navigate to Tab1--->Tab2 or Tab3 it not navigating to particular Tabs\

Details of Tabs:

In Tab 1
I have Created a List with Country
In Tab 2
I have created a List with Country and City
In Tab 3
I have created a Pie Visualization with Country and Revenue


Please find the attachment

Thanks in Advance

[Pratap Reddy]

Hi MFGF,

Working Concept:

Tab2 to Tab1(Working)
Tab3 to Tab1(Working)

Not Working Concept:

Tab1 to Tab2(No Action)
Tab1 to Tab3(No Action)

Wrong Working Concept:

Tab2 to Tab3 (but navigating to Tab1)
Tab4 to Tab2 (but navigating to Tab1)
tab3 to tab4 (but navigating to Tab1)

Please let me know how to resolve this

Thanks in Advance

[MFGF]

Hi MFGF,

Working Concept:

Tab2 to Tab1(Working)
Tab3 to Tab1(Working)

Not Working Concept:

Tab1 to Tab2(No Action)
Tab1 to Tab3(No Action)

Wrong Working Concept:

Tab2 to Tab3 (but navigating to Tab1)
Tab4 to Tab2 (but navigating to Tab1)
tab3 to tab4 (but navigating to Tab1)

Please let me know how to resolve this

Thanks in Advance

Hi,

You haven't told us what you did to implement any of this. Have you enabled debug mode in the rendered report to see how the variables are being set?

MF.

[Pratap Reddy]

Hi,

Details of Tabs:

In Tab 1
I have Created a List with Country
In Tab 2
I have created a List with Country and City
In Tab 3
I have created a Pie Visualization with Country and Revenue


could you please let me know where to enable the debug mode in rendered report?

Thanks in Advance

[Pratap Reddy]

Hi,

Details of Tabs:

In Tab 1
I have Created a List with Country

In Tab 2
I have created a List with Country and City

In Tab 3
I have created a Pie Visualization with Country and Revenue


In the above details of Tabs.

I have a Requirement where i need to navigate/drill through

1.if i click column(data item) of List in Tab1 it has to navigate/drill through to Tab2.

2.if i click column(data item) of List in Tab2 it has to navigate/drill through to Tab3.

3.if i click in colour in Pie it have to navigate/drill thoough to Tab1.



Thanks in Advance.

[MFGF]

Hi,

Details of Tabs:

In Tab 1
I have Created a List with Country
In Tab 2
I have created a List with Country and City
In Tab 3
I have created a Pie Visualization with Country and Revenue


could you please let me know where to enable the debug mode in rendered report?

Thanks in Advance

Hi,

When viewing the rendered output, use <ctrl><shift>D to toggle debug mode on and off. You can right-click and see the variables and how they are populated. The above is a good start, but you haven't given us an idea of what variable or variables are defined that control selection of the tab control, nor have you indicated how you are setting these variables. As I mentioned previously, you can have your lists and pies set the variable which the tab control is listening to, and therefore have them control which tab is selected. Have you done anything to implement this?

Hi,

Details of Tabs:

In Tab 1
I have Created a List with Country

In Tab 2
I have created a List with Country and City

In Tab 3
I have created a Pie Visualization with Country and Revenue


In the above details of Tabs.

I have a Requirement where i need to navigate/drill through

1.if i click column(data item) of List in Tab1 it has to navigate/drill through to Tab2.

2.if i click column(data item) of List in Tab2 it has to navigate/drill through to Tab3.

3.if i click in colour in Pie it have to navigate/drill thoough to Tab1.



Thanks in Advance.

That doesn't really give us much more than your previous post. You need to tell us about how you are setting your active report variables from these objects, and make sure the tab control is reacting to the variable you are setting.

Cheers!

MF.

[MFGF]

Hi,

I Have attached an example of what I think you require. The report spec is in 10.2.2 form, but should work fine in Cognos Analytics.

Is this what you mean?

MF.

[Pratap Reddy]

Hi MFGF,

Thanks for Reply.

This is exactly what we want..

Can you Explain in detail?

Thanks in Advance

[MFGF]

Hi MFGF,

Thanks for Reply.

This is exactly what we want..

Can you Explain in detail?

Thanks in Advance

Hi,

The example I posted shows exactly how to do this. Your tab control needs to listen to an active report variable. Use the Interactive Behavior button for the tab control to define the "Container selection" so that the tab control reacts to your variable being set. Your lists and pie need to set the same variable - again, use the Interactive Behavior button for each to define the "Set variable values" so that they set the variable to the value corresponding to the tab you want to navigate to. That's all there is to it.

Cheers!

MF.

[Pratap Reddy]

Hi,

Thanks for your reply..

1.I have Created a New Variable with Name vTabName and with Default Values as First Tab and i set the value to Second tab in 'Type in Value'
2.I have Created a Second New Variable with Name vCountry and i set the value to Country
3.I have Created a new connection for First Tab(Country in List) --->Second Tab(Label) and Active Report variable as 'vTabName'
4.I have Created a new connection for First Tab(Country in List) --->Second Tab(Country in List) and Active report variable as 'vTabName'

Up to this Step it is able to filter the Second Tab by First Tab,but cannot navigate to Second tab..



Please let me know in detail to get the result...

Please find the attachment..

Thanks in Advance

[MFGF]

Hi,

Thanks for your reply..

1.I have Created a New Variable with Name vTabName and with Default Values as First Tab and i set the value to Second tab in 'Type in Value'
2.I have Created a Second New Variable with Name vCountry and i set the value to Country
3.I have Created a new connection for First Tab(Country in List) --->Second Tab(Label) and Active Report variable as 'vTabName'
4.I have Created a new connection for First Tab(Country in List) --->Second Tab(Country in List) and Active report variable as 'vTabName'

Up to this Step it is able to filter the Second Tab by First Tab,but cannot navigate to Second tab..



Please let me know in detail to get the result...

Please find the attachment..

Thanks in Advance

Hi,

The value you set your active report variable to needs to match exactly the label of the tab you want to select. For example, if your second tab has a label of "Second Tab" and you set your variable to a value of "Second tab", then they do not match, so your tab control will not react. I think I can see in your attachment that you are setting the variables as follows:

Set vTabName to 'Second Tab' (this looks ok)
Set vCountry to Country (this looks ok)
Set vTabName to Country (this looks wrong)

There may be more entries too, but your screenshot only shows the first three. Why are you setting vTabName to the value of your Country?

Then on the right you have your reaction behaviour as Country in vTabName. That looks like a mistake in the report spec I sent. It should be Country in vCountry. I'm guessing this is the Interactive Behavior for one of your lists?

What is the Interactive Behavior for your tab control? It should just have a Container Selection set to "Label in vTabName" and nothing else.

Each of your lists and your pie should set vTabControl to the label of the tab you want to move to.

Cheers!

MF.

[Lynn]

Please let me know in detail to get the result...

Apologies if this comes across wrong, but you've been given a sample report specification that does exactly what you want and you are still struggling to implement the technique. This indicates a degree of unfamiliarity that might be remedied by a little bit of study on your part.

Chapter 8 in the user guide plus the Active Report Cookbook are excellent resources.

https://www.ibm.com/developerworks/data/library/cognos/reporting/active_report/page593.html

[Pratap Reddy]

Hi,

Thank You so much MFGF.

Its working fine.

[MFGF]

Hi,

Thank You so much MFGF.

Its working fine.

Excellent! Glad you got it working! As well as navigating between tabs, you can also use active report variables to filter lists and visualizations, so if you click on a specific country in the list on your first tab, you can put that country into a variable and use it to filter the list on the second tab. The example I sent does this also - this is what the vCountry variable is doing. In that way it behaves very much like a drill-through in a normal report :)

Cheers!

MF.

[Pratap Reddy]

MFGF,

Thank you so much...

Filtering between tabs also working fine...