Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [solved] variable names used by time tree?
Go
New
Search
Notify
Tools
Reply
  
[solved] variable names used by time tree?
 Login/Join
 
Guru
posted
Hi team,

Here's an easy question:

If you click on the Time Tree control on one of the built-in reports, it reloads the report as if the clicked value was the current point in time.

I see that it does this by setting a series of variables, but the names are truncated when I do a -? &. Here's the part I can see:

&D00_DIMENSIO>= T
&D01_LEVEL01_>= 2009
&D02_LEVEL02_>= 3
&D03_LEVEL03_>= 07

That's what shows if I click on level three value 07, which represents month 7, quarter 3 for year 2009.

What are the full variable names?

Cheers,

Joey
pmf 5.1.3

This message has been edited. Last edited by: Moogle,
 
Posts: 319 | Location: Los Angeles, CA | Registered: November 15, 2005Reply With QuoteReport This Post
Master
posted Hide Post
The tree is weird; it's a general IBI facility and not really under our direct control. We use a special flag in reports to be able to translate the weird flag we get from the tree to the actual parms the reports use.

All dimension parms are classically:

[dimension_name]_levelnn_value

where nn is the level number and dimension_name is the uppercased name of the dimension, with spaces turned to underscores.

And those values are truncated by the tracing facility in WebFOCUS Client.

so
&D00_DIMENSIO>= T
&D01_LEVEL01_>= 2009
&D02_LEVEL02_>= 3
&D03_LEVEL03_>= 07

translates to:

&D00_DIMENSION_NAME>= T
(e.g. the first dimension name is: T)
&D01_LEVEL01_>= 2009
(e.g., TIME_LEVEL01_VALUE is: 2009)
&D02_LEVEL02_>= 3
(e.g., TIME_LEVEL02_VALUE is: 3 - third quarter)
&D03_LEVEL03_>= 07
(e.g., TIME_LEVEL03_VALUE is: 07 - seventh month)

Hope this makes sense.


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, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
Hi Bob,

Thanks for the quick reply. Your message does make sense, but I think I may have been looking in the wrong direction and need your advice.

I am trying to over-ride the current period values set on the Manage tab. I have a report where I want to give the user a control to set current period and have the report display based on that. There are many different time ranges in use, which is why I didn't build a gadget for this.

I though that setting some time variables would do that, but I'm not having any luck. I've tried sets on all these variables so far, but it keeps showing the current period that is set on the managed tab's custom fex (pmf_set_date.fex):

-SET &D00_DIMENSION_NAME= 'T';
-SET &D01_LEVEL01_VALUE= 2009;
-SET &D02_LEVEL02_VALUE= 3;
-SET &D03_LEVEL03_VALUE= 09;
-*
-SET &D00_DIMENSION_NAME>= 'T';
-SET &TIME_LEVEL01_VALUE=2009;
-SET &TIME_LEVEL02_VALUE=2;
-SET &TIME_LEVEL03_VALUE=06;
-*
-SET &TLVL01_CUR=2009;
-SET &TLVL02_CUR=4;
-SET &TLVL03_CUR=11;

Perhaps if you told me the variable names that get set if a gadget is controlling the time?

It might even be something simple like:

-SET &TIME=2009~3~07;

I'll try that while I wait for your reply.

Cheers,

Joey
 
Posts: 319 | Location: Los Angeles, CA | Registered: November 15, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Hi Again,

My co-worker put my on the trail of the where statement that the time tree uses to over-ride the default current period:

 
-SET &rptYEAR=2009;
-SET &rptQTR=3;
-SET &rptMONTH=8;
-SET &PMF_BOOKLET_DATA_WH02 =
-      'WHERE (TIME_LEVEL01_VALUE EQ '    | '''' | &rptYEAR | '''' |
-        ' AND TIME_LEVEL02_VALUE EQ '    | '''' | &rptQTR | '''' |
-        ' AND TIME_LEVEL03_VALUE EQ '    | '''' | &rptMONTH | '''' | ');' ; 


It didn't work, but I think I'm getting closer.

Just to re-state my question, how do I provide PMF with a time dimension value and have my date ranges work off of that value instead of the current period that is set on the Manage tab?

Cheers,

Joey
 
Posts: 319 | Location: Los Angeles, CA | Registered: November 15, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hey Joey,

The variables are &TLVLnn_CUR, so it's not clear to my why you previous example was not working. Here's what I tried against the sample pmf_manufacturing DB:


-SET &OWNER_ID = 'pmfadmin' ;
-INCLUDE A_DEFAULTS
-INCLUDE A_SCORECARD

-SET &TLVL01_CUR=2004;
-SET &TLVL02_CUR=2;
-SET &TLVL03_CUR=05;

-SET &TIME_RANGE                 = 'CURR' ;
-SET &SORTBY1  = 'TIME' ;
-INCLUDE PMF_BOOKLET_DATA

?FF PASS1
-RUN


TABLE FILE PASS1
    BY TIME_LEVEL0102_VALUE
END
-RUN

  


And I get back 2004Q2

EricH
 
Posts: 164 | Registered: March 26, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
Something else you could possibly try would be:

-SET &USE_CUR_DT = 'N';
-SET &TIME = '2009~3~07';

Cheers,
Mike
 
Posts: 57 | Registered: December 03, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
quote:
Originally posted by EricH:

-SET &OWNER_ID = 'pmfadmin' ;
-INCLUDE A_DEFAULTS
-INCLUDE A_SCORECARD

-SET &TLVL01_CUR=2004;
-SET &TLVL02_CUR=2;
-SET &TLVL03_CUR=05;

-SET &TIME_RANGE                 = 'CURR' ;
-SET &SORTBY1  = 'TIME' ;
-INCLUDE PMF_BOOKLET_DATA

?FF PASS1
-RUN


TABLE FILE PASS1
    BY TIME_LEVEL0102_VALUE
END
-RUN

  


And I get back 2004Q2

EricH


Hi Eric,

Yes, this worked well. I suspect the problem is that I didn't have TIME as my &SORTBY1 variable. I was actually trying to use it as an across. Easy to change. Thanks so much, you are an excellent help.

Cheers,

Joey
 
Posts: 319 | Location: Los Angeles, CA | Registered: November 15, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [solved] variable names used by time tree?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.