Prompts ordering issue while in different queries

building reports webintelligence
1

Hi,
Please find the attached snashot of the issue, As per the requirement I am using 2 different data provider to filter the data in the report.

Period1 - is the 1st Data Provide with Following Prompts :

  1. Please Enter a CBOH code
  2. Please Select Period 1
  3. Please Select a Global Function

I need Global Function Filter to filter the record as Global Function filter & this is the one creating a problem…see below

Period2 -is the 2nd Data Provide with Following Prompts :

  1. Please Enter a CBOH code
  2. Please Select Period 2
  3. Please Select a Global Function

Now I want to have the Prompt sequence :

  1. Please Enter a CBOH code
  2. Please Select Period 1
  3. Please Select Period 2
  4. Please Select a Global Function

But as I am using Global Function in the Period1 qry it is coming as a prompt & the order is coming like this :

  1. Please Enter a CBOH code
  2. Please Select Period 1
  3. Please Select a Global Function
  4. Please Select Period 2

I have tried universe level prompt syntax with User:0,User:1,User:2,User:3 as well as Report level numeric formatting,Query properties…as desired prompt order but not working…any idea…help

Regards
Amit
Prompt Ordering.zip (65.0 KB)

sapboguru (BOB member since 2006-07-13)

2

Hi Amit,

Does it have anything to do with the fact that with prompt #3
you have a space missing ?
3.Please Select Period 2

3.(space missing here)Please select Period 2
From your screen shot you seem to have a space for all the prompts except this one.

Regards,

Naresh Ganatra :us: (BOB member since 2004-04-09)

3

Hi Naresh,
I don’t think that would be anything to do with the Prompt Text.
Its just what you write in there to be able to view right.

GNK_BO (BOB member since 2007-07-17)

4

yes, looks like the prompts from query 2 come after the prompt from query1, irrespective of the prompt text.

Naresh Ganatra :us: (BOB member since 2004-04-09)

5

Yes,

The prompt order will be based on the query. First the prompt will be ordered in alphanumberically in query first. Then it will do the samething in query 2. So try change the numbers in prompt text to show in proper order.

rj_srnth (BOB member since 2006-12-09)

6

Thanks for your input, I got the solution…It was nothing with Prompt(space) or alphanumeric order in query,I tried all the options pertaining to prompt in the universe & report.
Solution I did to create an extra DP & just have all the prompt I need in my report with one obj so it will 1st ask the value from me the way I would like in report & once pass the value it doesn’t care for other DP prompt sequence.

Thanks for your help friends.

Regards
amit

sapboguru (BOB member since 2006-07-13)

7

Hi Amit ,

Good to hear you solved it.
Can you explain in detail how you achieved it.

GNK_BO (BOB member since 2007-07-17)

8

Good one Amit !! :slight_smile:

Naresh Ganatra :us: (BOB member since 2004-04-09)