Difficult problem- Formula values to change with drill down

Business Warehouse

Moderators: Snowy, thx4allthefish

Post Reply
BWGUY
Posts: 6
Joined: Mon Oct 21, 2002 8:45 am

Difficult problem- Formula values to change with drill down

Post by BWGUY » Thu Oct 24, 2002 11:04 am

Hi ,
The value in the formula variable value needs to vary depending upon the months displayed. For example if the columns display january, february, march and april. The formula variable should be 1, 2, 3 and 4 respectively. ( 1 for january, 2 for february and so on...).
This view of report is normally a drill down on months of a year.
The current formula variable we use allows only one value to input before execution of query.
Variables with user exits also work the same way.

Any help, suggestions ??


Thanks in advance.

BWGUY
Thanks and regards
BWGUY

Guest

Post by Guest » Fri Oct 25, 2002 3:12 pm

could you tell me what kind of formula you are attempting to do? would a restricted key figure do the trick?

cheers

BWGUY
Posts: 6
Joined: Mon Oct 21, 2002 8:45 am

Dynamic Formula variables values

Post by BWGUY » Mon Oct 28, 2002 3:30 am

Hi Guest,
Restricted key figures will not help because the formula values(number) will need to change depending on drill down for a range of months.
Thanks and regards
BWGUY

GERMAN_BWER
Posts: 10
Joined: Mon Oct 28, 2002 3:47 am
Location: Germany

How about using virtual characteristics

Post by GERMAN_BWER » Mon Oct 28, 2002 3:52 am

Hi BWGUY,

take a lock at the HOW-To Paper named

How to work around the "single key date" limitation for time dependent master data

You will have to adapt the paper to your needs, but the ways to do it stays the same...

If there should be any questions feel free to ask.

Regards,

GERMAN_BWER

Post Reply