Hi All,
I have a workbook which has two sheets. In sheet1 , i have a query Q1 on cube C1 which has y_family infoobject while in sheet2, i have query Q2 on Cube C2 which has z_family( reference of y_family).
In Q1, i have a user entry variable on y_family (for user entry pop-up).
My requirement is to fill z_family with the same value which has been entered for y_family so that the user dosent have to enter same value twice.
Please help.
Thanks