Force webi to separate @Prompts with multiple queries

building reports webintelligence
1

I created a derived table (DT) in the universe (source: Generate timespans that can used in place of UNIONs when working with dates. · GitHub) that dynamically creates rows based on the values of 4 @Prompt() variables. This table is not linked to others.

Next, I created a class (named ‘Timespan’) that exposed three of the DT’s fields: Timespan (a String), Period Start (a Date), Period End (a Date).

Next, I created two Webi queries, both of which make use of the three Timespan fields in the Results Objects, in addition to the query-specific fields.

Lastly, I set each query’s Query Filters:

Query 1 filter:

Query 2 filter:

Date Field 2 Between Period Start and Period End

Both of the queries produce the expected results.

What I need to do, however, is use different values for each query’s @Prompt() variables. At the moment, I’m only prompted once for the set, which are applied to both queries.

Is there a way to tell webi not to do this?

craibuc :us: (BOB member since 2009-10-19)

2

If the prompt syntax is the same, the prompt will be reused. Change the question by adding a space or keyword.

e.g. “Sales period from” and "Sales period from " should prompt twice.

Derf :canada: (BOB member since 2011-05-16)

3

So, I would need to multiple derived tables for this approach, correct?

craibuc :us: (BOB member since 2009-10-19)

4

For what i understand, you have two date objects: Date field 1 and date field 2.

Both uses the same prompt two question: Period Start and Period end.

That’s why you see only two questions in the webi prompt and both uses the same dates.

Now if you want to have four questions, you’ll need four prompt questions:

Datefield1 Period Start
Datefield1 Period end

Datefield2 Period Start
Datefield2 Period end

Derf :canada: (BOB member since 2011-05-16)