COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: Clint_EastCog on 26 Sep 2016 03:25:38 AM

Title: Report Studio Active Report / elementary data / slicer
Post by: Clint_EastCog on 26 Sep 2016 03:25:38 AM
Hello everyone,

I want to convert a Report Studio for use Active Report new capabilities.

In my report, I use a prompt to select a year. I use the result of a prompt in an elementary data and I calculate the year – 1 in another elementary data.
I use these two elementary data in another elementary data to select single value with "tuple" function (for example : ResultYear = tuple (dimension, thisyear, value)

In Active Report, I want to replace the year promt by using a data button bar to show the years available. I what to use the year selected by user in my elementary data ou in slicer
But I cannot use an active report variable in an elementary data.

Any idea ?
Thanks