This website is not affiliated with, sponsored by, or approved by SAP AG.

Difficult problem- Formula values to change with drill down

Business Warehouse

Moderators: Snowy, thx4allthefish

Difficult problem- Formula values to change with drill down

Postby 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
BWGUY
 
Posts: 6
Joined: Mon Oct 21, 2002 8:45 am

Postby 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
Guest
 

Dynamic Formula variables values

Postby 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
BWGUY
 
Posts: 6
Joined: Mon Oct 21, 2002 8:45 am

How about using virtual characteristics

Postby 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
GERMAN_BWER
 
Posts: 10
Joined: Mon Oct 28, 2002 3:47 am
Location: Germany


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 11 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.