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,

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.

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

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

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

Something else you could possibly try would be:

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

Cheers,
Mike

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