two Variable created over fical period

[Former Member]

Hi one requirement,

source is Bex query,

Scenario: 1.customer no

2.Cal year

3. Amount

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

[Former Member · Accepted solution]

Hi Kannan,

You are following the right approach i.e. creating the RKF's in the BEx Query to get the required result set. This will allow you to

get the better performance from other approaches.

However, from the message you have written it seems to be a issue of Text that you are using to define the two variables. Because in BO the Prompts are identified by the Texts. So, just check the generated definitions of the Prompts in the universe specifically the Text part.

In the right case the text of the two prompts should be different.

Regards,

Rohit

[Former Member · Accepted solution]

Hi Rohit ,

When running the report showing error like" in query Only text is different from both but remaining things are same like equal to ,multiple selection etc.....

[Former Member · Accepted solution]

Hi Kannan,

Can you post the definitions of the two prompts from the universe?

Regards,

Rohit

[Former Member]

"If am creating universe over this BI Query and executing it was throwing error like only text is varying in prompt like that "

Can you explain clearly the error you are getting. The way you tried to explain above is not clear.