Open a webi report from a Dashboard components

[Former Member]

Hi All,

I have created a dashboard using Dashboards 4.0.It has a bar chart,line chart,combination chart.all these chart on X-Axis have month names as dimensions and y - axis shows different measures.

So now the requirement is the user wants to select any month from any one of the chart at one particular point of time.then the dashboard should open a Detailed Webi report( created in BI Launch pad) for the selected month and display that month data in a new window.

I know that we have to use the URL button in Dashboards for linking a webi document.

However i would like to know how to pass the selected month from the dashboard by selecting a particular month from any of the graph component as a parameter to the respective Webi report in BI Launch pad.

Hence any body how to implement this in Dashboards please let me know the step by step process.

Thanking you,

Regards,

Naga Nanda Kishore.

[former_member197751]

Hi Kishore,

            Month name should be prompt for the Detail  Webi Report, so when u clicked on bar its going to carry that Month as Well. And Syntax for adding Month will be like below.

Suppose if it is Sample Open Doc:

/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=Fq0JoFNoywYADK0AAADHRQkAABVdEABC

So u have to use this Syntax for Month

lsSMonth=+ Map the Cell where month is capturing. (Note:In  lsSMonth Month is next of Prompt for month in Detailed Report.

And final URL will be

"/BOE/OpenDocument/opendoc/openDocument.jsp?mistype=CUID&iDocID=Fq0JoFNoywYADK0AAADHRQkAABVdEABC&lsSMonth=+Selected Month"

       (Open Doc)                                                                                                                                                          (Sending         (Selected                                                                                                                                                                                       Month)                 Month)

And For trigger the URL button you have keep trigger URL when Month Value changes(Based on Selection), means you have map trigger cell to destination of Bar chart Month Destination.

Thanks and Regards

Sateesh

[Former Member]

Hi sateesh,

Thank you very much for your response.

If you can send me the screen shots it would be very help full for me.

It is a very urgent requirement for me.

Hence please send me with screenshots how to implement this.

Thanking you,

Naga nanda kishore

[Former Member]

Hi sateesh,

I am using a combination chart in 1 tab and  line chart in the 2nd tab.

So the x-axis labels are my month names for both the charts.and I am displaying last 12 months of data in each chart.

In this case how to map the selected month to the destination cell in each of the charts mentioned above.

Let me know the step by step process with screen shots if possible.

Thanking you,

Naga nanda kishore.