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 dimensional values to operational Report (one more time)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to pass dimensional values to operational Report (one more time)
 Login/Join
 
Silver Member
posted
In several of the dimensional drill down reports we would like to be able to drill to an operational report -- however that option to "Drill to an operational report" is missing from the drill down dropdown menu. For example this occurs when navigating through dimensions from an analysis designer report. It looks like the analysis designer report calls a_meas_detail01.fex to do the dimensional slicing and dicing so this is the actual fex I am referring.. Basically in the dropdown menu all that is available are dimensions -- we would like to see operational report on this list as well. That way we can pass as parameter the current dimensional cross sections and levels to an operational report.

As it stands now, the user has to go back to the top level Analysis designer report and then drill to an operational report -- which would not pass the identified dimensional cross section and levels.

Any assistance on how to add an “operational report” to the dropdown list on a_meas_detail01.fex would be appreciated. It looks like the dimensional cross section information is in the breadcrumbs at the bottom of the a_meas_detail01 report. Adding operational report to the options button list did not meet the user requirements, but adding a third button (back, options, operational report) may be an acceptable alternate solution if it is not possible to add “operational report” to the dimensional drilldown list.

Thanks in advance.

-Seth


WF 7.65. Solaris. PMF 5.11 on Oracle 10g
 
Posts: 48 | Location: New York | Registered: March 25, 2009Report This Post
Master
posted Hide Post
Hi Seth--
You'll see the operational dropdown on the measure name column.

On dimension values in these reports, you see only cross-drills to dimensions. There's a reason for this. You couldn't drill on those to display an operational report because the measure isn't known for dimensional drills (they are to the left and outside the measure name, and there's only one drill for multiple measures). Operational reports are linked to the measures themselves, so the measure ID has to be known inside the drill.

Of course there is a solution but it involves a customization. If you wanted dimensional drills to contain the operational report drill would be a customization. You coudl alter the core dimension drill code to add operational report. Your reports would have to repeat the dimension value for every row, so that each row linked to a different measure would contain the measure ID. You'd also need to alter the reports to pass the measure ID on the dimension value columns. Both of those pieces in place would give you what you want.

Hope this makes sense; let us know if this doesn't answer your question.

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
Gold member
posted Hide Post
Hi Seth,

If you'd like this done just for the measures detail report you could customize it by doing the following.

Try the below code snippet to do what you'd like.

In a_meas_detail01.fex:

-* Current code
-SET &THIS_DRILL_COL = 'B1' ;
-INCLUDE A_GET_DRILL_DOWN
$

-* Change this code to
-SET &THIS_DRILL_COL = 'B1' ;
-INCLUDE A_GET_DRILL_DOWN
-* Add this new section below
DRILLMENUITEM=&MD_OPRPT.QUOTEDSTRING, FOCEXEC=run_launch_page( \

-* Depending on the column that was drilled on, define that we passed SORTBY1, SORTBY2, SORTACROSS or DATA
-SET &DRILLFIELD = IF (&THIS_DRILL_COL EQ 'B1') THEN &SORTBY1
- ELSE IF (&THIS_DRILL_COL EQ 'B2') THEN &SORTBY2
- ELSE IF (&THIS_DRILL_COL EQ 'A1') THEN &SORTACROSS
- ELSE IF (&THIS_DRILL_COL EQ 'DATA') THEN 'DATA'
- ELSE ' ' ;

DRILL_NAME = &DRILLFIELD.QUOTEDSTRING \
DRILL_COL = &THIS_DRILL_COL.QUOTEDSTRING \

-INCLUDE A_GET_DRILL_DOWN_PARMS

-IF (&STYLESHEET_ID_B1 EQ ' ') THEN GOTO :A_GDDM_SK0A ;
DRILL_VAL1 = &STYLESHEET_ID_B1 \
-:A_GDDM_SK0A

-IF (&STYLESHEET_ID_B2 EQ ' ') THEN GOTO :A_GDDM_SK0B ;
DRILL_VAL2 = &STYLESHEET_ID_B2 \
-:A_GDDM_SK0B

-IF (&STYLESHEET_ID_A1 EQ ' ') THEN GOTO :A_GDDM_SK0C ;
DRILL_VAL3 = &STYLESHEET_ID_A1 \
-:A_GDDM_SK0C

MEASURE_SERIES = &MEASURE_SERIES), TARGET=&PMF_DRLL_TGT,

$

Cheers,
Mike
 
Posts: 57 | Registered: December 03, 2007Report This Post
Silver Member
posted Hide Post
THANK YOU MICHAEL!!! I just tried out your proposed code change, and it looks like this works beautifully.

I really appreciate the assistance.


Note: It looks like it is taking the parameters from the dimensional cross section and levels from the breadcrumbs at the bottom of the page -- not the dimensional cross section and level that you drill on. This is still by far a lot better than having to go back to the originating report to drill out to an operational report.

-Seth

This message has been edited. Last edited by: SethW,


WF 7.65. Solaris. PMF 5.11 on Oracle 10g
 
Posts: 48 | Location: New York | Registered: March 25, 2009Report 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 dimensional values to operational Report (one more time)

Copyright © 1996-2020 Information Builders