To pass a value (year) from parent-Iview to pop-up Iview

[pradeep_gupta]

Hi experts,

I m facing a problem in creating a popup Ivew.

Scenario:

I have created a o/p Table-view from a BI query. From the o/p of the table-view, I have created a form-view in which a push-button is created.

On pressing this button a custom-action triggers a popup-iview. In this Ivew another query is displayed in a tabular form.

In main Ivew, Annual Sales analysis is displayed according to Sales org.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

( Sales-org Year Actual-Qty Plan-Qty)

ABC 2009 850 950

ABC 2010 650 700

ABC 2011 850 850

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

In the popup-ivew Annual Sales analysis is displayed according to Distribution channel.

Requirement:

The o/p of the 2nd query should be filtered using the YEAR from 1st query. i.e. user selects the first row(year=2009) & presses the button then, in a popup window the sales of DC will be displayed but only for that particular year i.e 2009.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Sales Org = 1000 Year = 2009

( Dist-channel Actual-Qty Plan-Qty)

DC01 850 950

DC02 650 700

DC03 850 850

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

How to pass the YEAR from parent-ivew to the popup-Ivew ?

Please help me out.

Thanks,

Pradeep

[Former Member]

Hi Pradeep,

In the popup add a start point to your BI query and add a field YEAR in the start point.

Now go back to the main iview and select the link connecting the popup and your first table, as you have already defined a trigger for the popup now map the field in the Start point to YEAR in the table view i.e. select @YEAR from table for Start point field YEAR.

with this you can pass the year from the selected row in the table as an input to the query present in the popup.

Hope this solves your problem.

Regards,

Rk.

[pradeep_gupta]

Hi RK,

Thanks a lot for your reply.

I had done exactly the same way you have suggested, but m not getting desired o/p.

My O/P: ( if the row with year :2009 is selected in main Ivew table)

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

( Dist-channel Year Actual-Qty Plan-Qty)

DC01 2008 980 1000

DC01 2009 850 700

DC01 2010 900 900

DC02 2008 850 850

DC02 2009 650 700

DC02 2010 850 850

DC03 2008 350 370

DC03 2009 850 850

DC03 2010 900 900

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Desired O/P: ( if the row with year :2009 is selected in main Ivew table)

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

( Dist-channel Year Actual-Qty Plan-Qty)

DC01 2009 850 950

DC02 2009 650 700

DC03 2009 850 850

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Thanks.

[Former Member]

Hi Pradeep,

Check your Value mappings in the links i.e. Table View to Popup iview and also the start point to Query. In both the links you should select @YEAR against your field Year.

Check this and see if it works.

Thanks and Regards,

Rk.

[pradeep_gupta]

Hi RK,

Done as said.

Problem still persists.

Thanks.