KPI's analytical driver don't work

Hey guys, I have created sample KPI to learn about parameters, this is my query :
SELECT day as value FROM `foodmart`.`days` where week_day=$P{weekDay};

Here is my LOV query:

SELECT day,week_day FROM `foodmart`.`days`;

week_day is value and day is label.

I pass everything into analytica l driver, and everything is smooth.

So basicaly KPI should show value of a day for example when you choose Sunday it should show 1, when friday 6 etc.

But no matter what you choose it always shows value 2.

Maybe someone knows where problem is?

Hi vblazevic,

I faced a similar problem. The resolution to my problem was the use of the 'Behavior' parameter.

Each time you execute the KPI document, the behavior parameter executes in 'default' mode if no other mode is selected.
In this mode, a new value will be calculated only if the KPI does not have a previously calculated value. In case a value is there already(which was calculated at an earlier date), no new calculations are performed and the old value is chosen for display.

You may go on the following link to see the use of this parameter:-

http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/KPI+Document+Definition#HBEHAVIOURParameter

This worked for me...hope it helps you too.

Regards
Ashish

Hey man, thanks for your help, now it's working