cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy vaiable

Former Member
0 Kudos

HI All,

I have created a hierarchy node variable (zvar) for posting period (0fiscper3).......

posting period is time char and hierarchy is FY Quaterly(quaterly 1, 2, 3, 4) for the same.....

But not able specify offset for ZVAR...right click to specify offset is greyed out......why? please help.....i want to calulate present and previous quaters....

Do i need to write any code?

Please help

Regards

Raj

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Raj,

You can set the offset value on a single variable as well. Variable range is not necessary. We have also created few queries where we have set the offset value on single variable.

There might be a possibility that the query is not in the change mode. Please go to change mode of the query to set the variable offset value...

Hope this helps...

Former Member
0 Kudos

Hi Raj,

Try this.....

when your going to assign offset value ..

try to take these options in your screen.

selection as value range. i think you might have taken single value.

Hope this will help you.

Thanks,

Vijay.

Former Member
0 Kudos

You cannot have the offset value for single value range....you must select value range.

Former Member
0 Kudos

Hi Both,

You both are right. Actually, I missed to see that Raj has asked for Hierarchy. We cant define offset vaue on a hierarchy.

Former Member
0 Kudos

while creating hierarchy node variable there are only two options

1....singlae value

2. Multiple single values.

value range is not possible

with either of these two............specifying variable offset value is greyed out?

Please help

Former Member
0 Kudos

Hi Raj,

Try this

change your variable selection from Interval or selection option to Single

hope this will help you.

Thanks,

Vijay.