cancel
Showing results for 
Search instead for 
Did you mean: 

Calculated Key figure and formula variable issue - Urgent

Former Member
0 Kudos

Hi,

I have created a formula variable on dates. When I run this locally it returns results. Now I have created a calculated key figure on this formula variable. It is not returning any results. Any idea on why this is happening.

Thanks,

Kal

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Kal,

Can you paste your Formula & Calculated Keyfigure calculation.

If possible give information on ur formula variable ( processing by , charactesristic , replace variable with ( if it is replacement path ) , Dimension id )

Regards,

SRIKANTH

Former Member
0 Kudos

Kal,

I guess the formula variable is a replacement path type variable. Did you bring the referred date infoObject in the query also? so that the formula variable can get the replacement path value. Try having the date also in the query, you can hide the date if it need not be shown.

-Saket

Former Member
0 Kudos

I have the infoobject in the query. The query is based on a multiprovider. So I have created the query at the cube level and trying to run it. Even then the formula locally returns results but the calculated keyfigure is empty.

Former Member
0 Kudos

Hi Kal.

I seem to have the same problem.

Will se if you get any good answers

Ingrid

Former Member
0 Kudos

can you provide more details