As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
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
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,
Newbie. WebFOCUS 126.96.36.199. Client 188.8.131.52.
Posts: 46 | Location: UK | Registered: August 30, 2018
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.