Focal Point Banner


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 community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    How to pass dimension values to an operational report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to pass dimension values to an operational report
 Login/Join
 
Gold member
posted
I have an operational report that I would like to execute from the Measures - Compare to Previous report. Drilling down on an amount column reveals a measures detail report that displays the dimension values. Drilling down on the measures column reveals the operational report, but I am unable to pick up the dimension values as parameter values. Walking through the process I see where the &TIME value is set to space. Where am I able to pick up the dimension values used in the Measures - Compare to Previous report to pass on as parameter values to an operational report? Note: I have three dimensions. In the operational report &TIME is always blank and only the last selected of the remaining two dimensions contains a value. Thanks in advance.


WebFOCUS 8.1.05/PMF 8.1.4,Tomcat,IIS,Windows/iseries,sql server 2008,Excel/ PDF/HTML
 
Posts: 65 | Registered: July 11, 2006Report This Post
Master
posted Hide Post
When you drill on "operational report" you're actually clicking on the Measure name, and therefore not on a particular Time point.

So the outer sorts and filters are what is passed to that operational report.

If particular point in TIME is in the outer sorts and/or filters applied to the report as a whole (unlikely but possible) then Time will be there. Otherwise you probably want Time to be the current point of time and to get the Time Range applied to the report, rather than seeking &TIME to contain a particular point in Time, no?.

So what you want is the Time Range which is in the &TIME_RANGE variable and to use the INCLUDE time_ranges_get to get the start and end dates of that Time Range.

hope this helps
thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Guru
posted Hide Post
Hi Bob,

I'm attempting to turn a time range into a date range, for use in an operational report.

I have my time abbreviation stored in &TIME_RANGE, and I did an INCLUDE on TIME_RANGES_GET, and then printed the amper variables before and after the include to see what happened. They are not any different, so I don't think it worked for me.

I saw that &RPT_TIME_RANGES_ABBR was a DEFAULTH in the TIME_RANGES_GET fex, so I did a -SET &RPT_TIME_RANGE_ABBR = &TIME_RANGE; but it didn't help.

So, what am I missing? How DO I turn a time range into two discrete start and end points?

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
Guru
posted Hide Post
I spent a fair bit of time today trying to turn a time range into a start and end date. I've come to the conclusion that this is slightly futile, or at the very least, not a best practice.

Using the TIME_RANGES_GET procedure will populate a series of variables with all the fields from the TIME_RANGES table, if you feed it an ID or an abbreviation. The most potentially useful fields are the START_TIME_LEVEL and START_RANGE. The first will tell you if your time range is yearly, quarterly or weekly and the second will tell you how many points in time back you need to go.

I figured I'd be able to reverse-engineer a time range with a combination of the current date range and the aforementioned two fields. The problem I ran into is when you get into negative numbers, such as if the current month is 02, and you need to subtract 3. You are really not dealing with a date value, so there are no helpful functions to do the math for you.

This made me take a step back and assess why I was trying to do what I was trying to do. There are certain instances in PMF where you can drill down without clicking on a date value, and get to the a_meas_detail01.fex report with only a time range for a variable. This will likely only happen on custom gadgets without a date axis visible, such as a summary-type report (IE. show me the total for a particular date range).

I have a series of operational reports that expect to receive a point in time, and fail with a '&TIME is not found' error if they only find a time range. I decided to provide a default point in time for this sort of circumstance, which is to give the user the current time period at the level of the time range they are using. So if it is January, Quarter 1, of 2009, and they have Last 4 Quarters as a time range, I will set &TIME to Quarter 1, 2009. If they have a monthly time range, I'll set &TIME to January, 2009. A yearly time range will result in 2009. This is a fair compromise to handling a rare situation.

This is the code, which checks for a valid &TIME value and if it doesn't find one, does what I just described:
-IF &TIME.EXIST EQ 1 THEN GOTO SKP_TR;
-SET &RPT_TIME_RANGE_ABBR = '5WW';
-*
-INCLUDE TIME_RANGES_GET
-SET &TIME = IF &START_TIME_LEVEL EQ 1 THEN &TLVL01_CUR ELSE IF &START_TIME_LEVEL EQ 2 THEN &TLVL01_CUR||'~'||&TLVL02_CUR ELSE IF &START_TIME_LEVEL EQ 3 THEN &TLVL01_CUR||'~'||&TLVL02_CUR||'~'||&TLVL03_CUR ELSE &TLVL01_CUR||'~'||&TLVL02_CUR||'~'||&TLVL03_CUR||'~'||&TLVL04_CUR;
-SKP_TR;
-SET &DIM_NAME = 'TIME';
-SET &DIM_VALUE = &TIME;
-INCLUDE gadg_dim_parms


It might be a useful function to provide in a future release of PMF to populate a set of variables that can be used for a start and end date in external op reports, based on a provided time abbreviation. There are already a set of variables called &TLVL0x_CURR, which contain the current point in time. You could take the current point in time, give it a 'Last 6 Weeks' time range, and get a point in time that is six weeks back, with all the years, quarters, and months nicely sorted out for you.

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    How to pass dimension values to an operational report

Copyright © 1996-2020 Information Builders