There are some situations when you definitely need some way of recognizing new input from user. These are rather rare occasions, but when it's nice to have such a tool is sack.
One of the applications was discussed in this communities topic. By the way, I'm spending much time on communities these days (it's a very slow site, so no surprise) and I recommend it as a valuable resource for finding cognos-related answers. A steady pace of 10 topics a day gives a rather solid knowledge base now, after 4 months of uptime. If only it was faster, sigh...
So how to catch the fact that user changed this specific cell?
Simple, you just have to remember about virtual dimensions and calculation rules to build a "trigger".
1 You add a simple dlist {value, old_value, new_value_flag}, with new_value_flag = (value?=old_value). new_value_flag is a dlist-formatted element with (yes\no) elements.
2 After user inputs new data into cell, this flag will change to yes (by IF formula) and you can use this data by writing an accumulation dlink using only new data (select yes value from new_value_flag virtual dimension).
3 When you've finished processing freshly inputed data, you just run another link that copies value to old_value, and that sets the flag back.
Ps: It's too bad we didn't follow that topic on communities to a logical end.
Powered by FireStats
I haven’t read your reply to my post from March 5th. So I’ll send you the everything at the beginning of next week.
Special Thanks for your helpful contributions.
Hi Robert.
Sure, send libraries along.
Hi,
they are on their way to russia.
regards.
Dear Yuri,
I am a professor in Taiwan and working an EP project for a Manufactory. We have talked before and your advices helped me a lot.
There is a new problem regarding to Publishing Macro to Connection in Contributor Administrator Console.
It was very OK previously.
However, today I got an error message “You do not have rights to publish the Macro to IBM Cognos Connection.”,when creating a Macro.
How can I have the rights for publishing Macro to Connection back again?
Thanks in Advance!
Best Regards,
James Yang
Dear Yuri,
My problem is solved.
I guess it is because that I used “&” as part of Macro’s name. Just change its name and it works fine as usual. It’s odd!
Still want to say “Thanks you”.
Best Regards,
James Yang
Thanks for stopping by, James )
Hope that all is well