two Variable created over fical period
Hi one requirement,
source is Bex query,
Scenario: 1.customer no
Layout of report should be
<customer no > < Amount 1 (fiscal year variable 1 user selected =2010)> < Amount 2 (fiscal year variable 2 user selected=2007)
< 1 > < 100 > < 87>
< 2 > < 50 > < 78>
< 3 > < 79 > < 76>
So from the lay out user will be prompted with two variable ..so that he will enter two variable according to that corresponding amount to the respective year should been shown.
In bex i was able to do using selection restricted with two variable . so that when am executing in RSRT t.code this layout is done.
If am creating universe over this BI Query and executing it was throwing error like only text is varying in prompt like that so how to achive this
Edited by: Kannan Balamurugan on May 25, 2011 12:44 PM