Showing results for 
Search instead for 
Did you mean: 

Bex variables with offset

Former Member
0 Kudos

I've created a query with a period structure that contains 12 periods. Using a variable and a offset I'm able to key in for example 012/2006 and get the "actuals" using a restricted key figure for month 1-12 of 2006. That seemed straight forward. Were I am confused is if I wanted the users to key in 010/2006 and get months 1-10 or by using the same query key in 04/2006 and get months 1-4. I'm hoping someone can explain if possible.

Will award points as always.



Accepted Solutions (0)

Answers (1)

Answers (1)

Active Participant
0 Kudos

Use an interval which says:

Fixed value 'Period 1' to variable value 'entered by user'.

You can mix values and variables in an interval.

But you can't use a fix structure where you created a key figure for each month. You would have to use a drilldown instead for 0FISCPER.