Hi,

I am new to WebFOCUS (previously worked on a different product suite where this report is working, out of the box). This is my first technical question related to a report that I am developing using InfoAssist UI.

1. I have three measurements on a report.
2. For simplicity, I have two filters (dynamic parameters) where one of them is a date range (dynamic).
3. Out of the three measurements, two measurements need to be filtered by the date range and the second parameter.
4. The third measurement needs be filtered by the second parameter only.

But it looks like that the entire WHERE clause is applied to all the three measurements, which is fine considering I am new to the WebFOCUS product suite.

Question(s):
a. Is is possible to ignore the date range parameter in case of the third measurement in the InfoAssist UI (sorry I have not learnt yet the WebFOCUS reporting language)? Here, I am looking for an out of box way as our focus is on using the InfoAssist UI mainly.
b. Is is possible to ignore the date range parameter in case of the third measurement in the InfoAssist UI without using the HOLD files and / or JOIN options? Here, I would have looked into the alternative using a HOLD file and /or JOIN but it seems that we do not have licence to use these options (as informed to us by a third party).

Additional information if it's useful is below.

Filters:
1. Dfn_RangeStartDate >= Simple Parameter Dfn_RangeStartDate
2. Dfn_RangeEndDate <= Simple Parameter Dfn_RangeEndDate
3. Company is multiselect dynamic parameter
4. (Dfn_Meas_1 >= 1 OR Dfn_Meas_2 >= 1 OR Dfn_Meas_3 >= 1)

Calculations:
a. Dfn_Meas_1 = IF (( "Date" GE '&Dfn_RangeStartDate' and "Date" LE '&Dfn_RangeEndDate') AND ("Company" NE 'ABC')) THEN 1 ELSE 0
b. Dfn_Meas_2 = IF (( "Date" GE '&Dfn_RangeStartDate' and "Date" LE '&Dfn_RangeEndDate') AND ("Company" NE 'XYZ')) THEN 1 ELSE 0
c. Dfn_Meas_3 = IF (( "Product" EQ 'P1') AND ("Category" EQ 'Alpha')) THEN 1 ELSE 0


Kind regards,

Manoj.

WebFOCUS: 8.2.0.3, Client: BIP, InfoAssist 8.2.0.4.

PS: Just thought about adding some details related to how it's done currently using another reporting product suite.

Prompts (parameters) can be created independently, stored separately and associated to a report (or multiple reports when relevant) on dashboard page(s). Using the prompt, I stored the Range Start Date and Range End Date values to two variables and use them in formulae and filters just like Dfn_Meas_1 and Dfn_Meas_2 calculations and their associated filters. I do not filter the report based on the range dates (so filters 1 and 2 are not present inside the report).

But in InfoAssist if I ignore (or remove) the first two parameters then I do not see the Start Date and End Date parameters on page (or at Report run-time) as in WebFOCUS there does not seem to be a concept of parameters independent of reports.

This message has been edited. Last edited by: FP Mod Chuck,

Made some progress where the third measurement (Dfn_Meas_3) is ignoring the date range parameter. I have now removed the filter on the date range (filters 1 and 2).

However, I am not able to show the calendar control for the Start Date and End Date (for the first two measurements). Initially the date range parameter was based on dimension table - which I have now de-associated with as I do not want to bring in the Date dimension into the filter.

For the Calendar Control I referred to this https://webfocusinfocenter.inf...source/resp_auto.htm however no luck yet. Currently (in the new reporting environment where WebFOCUS is used), I have to type in the date range manually.

I brought the Start Date and End Date DEFINE calculations to Filter area and now the whole report seems to be working as expected.

The question may please be closed now.

Thank you.

Kind regards,

Manoj.