Skip to Content
0
Former Member
Oct 18, 2005 at 10:12 AM

Composite key figure for query on cube 0IMFA_1

72 Views

Hi,

I'm trying to build a query that combines two delimited indexes (0IMFA_1_RK009 and 0IMFA_1_RK003) into one index which corresponds to actual if 0FISCPER is before current period and to budget if period is in the future.

I'm trying to build a formula for this but I don't seem able to check against 0FISCPER in it.

Please give me some advice.

Thanks in advance