tag:blogger.com,1999:blog-2744439768720161806.post4038025757730519568..comments2014-01-23T12:10:56.859-08:00Comments on jQuery with Cognos: Dynamic custom exception in Cognos using jQueryRan Avnonhttp://www.blogger.com/profile/08094602893536617346noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-2744439768720161806.post-73067524301887225442013-09-08T00:13:03.230-07:002013-09-08T00:13:03.230-07:00it's a great tutorial...
but can somebody tell...it's a great tutorial...<br />but can somebody tell me how the logic, when i change the value of the slider, the minimum Quantity(who in a red box) can add 10 or 15 ???<br /><br />i haved try it and i still not found the way...<br />please help...Fariz Ressehttps://www.blogger.com/profile/12615988952330067427noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-33504904218558091502013-05-19T12:38:43.188-07:002013-05-19T12:38:43.188-07:00This comment has been removed by a blog administrator.sanjayhttps://www.blogger.com/profile/04012017541757653268noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-60196088762939280112013-05-02T01:50:45.147-07:002013-05-02T01:50:45.147-07:00I have just had my eyes opened to these impressive...I have just had my eyes opened to these impressive possibilities, and thanks to you Ran for assisting in this!!!<br /><br />I do have a question though...if I wanted to adjust the code so instead of highlighting the records that fall within the range of the slider choice, I actually filtered the list column?? So for each measure identified as a column in the list I would build a slider to allow the user to filter each column. <br /><br />I was thinking of utilizing parameter filters within the code, but have hit a wall with manipulating that within the code you presented...any ideas? I am working within Cognos 10.1.<br /><br />Thanks in advance!!Tore Contihttps://www.blogger.com/profile/06109291737344583324noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-64603344265151697052013-02-15T09:16:46.900-08:002013-02-15T09:16:46.900-08:00I am using Cognos 10.1 FP1I am using Cognos 10.1 FP1DAWellshttps://www.blogger.com/profile/14362453323953375575noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-4341010679186780442013-02-15T09:15:57.063-08:002013-02-15T09:15:57.063-08:00I am attempting to follow you tutorial exactly, bu...I am attempting to follow you tutorial exactly, but use a custom 1.9.2 JQuery UI and the 1.8.2 JQuery release and the code is not working. Please help.DAWellshttps://www.blogger.com/profile/14362453323953375575noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-55351902321845201462013-01-20T18:28:21.482-08:002013-01-20T18:28:21.482-08:00I am using Jquery in my reports in report studio 1...I am using Jquery in my reports in report studio 10.1<br />Problem is whenever I refresh page prompts disappear.<br />Please help.....Sheetalhttps://www.blogger.com/profile/00893850971043437726noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-76513149021155993742012-09-18T13:00:13.593-07:002012-09-18T13:00:13.593-07:00I everyone, I have updated the post, so you can us...I everyone, I have updated the post, so you can use it Cognos 10. As written, just add RS to LID=lstJQuery (So, it should be LID=lstJQueryRS) and it should work with Cognos 10.X.<br />Thanks for Nimrod for his constructive comments. I have modified the JavaScript code according to his suggestions.Ran Avnonhttps://www.blogger.com/profile/08094602893536617346noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-55412444962540063502012-07-17T14:07:35.512-07:002012-07-17T14:07:35.512-07:00Hello All,
I have same issue as Zvi and Gicy. Any...Hello All, <br />I have same issue as Zvi and Gicy. Any luck with Cognos 10?UKhttps://www.blogger.com/profile/02464737539373958601noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-998808130340733532012-04-19T09:51:07.372-07:002012-04-19T09:51:07.372-07:00anybody tried this code sucessfully in Cognos 10. ...anybody tried this code sucessfully in Cognos 10. I have the same problem as Zvi mentioned. The slider doesn't slide.Gicyhttps://www.blogger.com/profile/18358716948276142906noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-83610399829186354912011-11-17T06:05:30.370-08:002011-11-17T06:05:30.370-08:00Hi,
This is GREAT tutorial!!
I am trying to make i...Hi,<br />This is GREAT tutorial!!<br />I am trying to make it on Cognos 10 BI, and everything seems to be OK except that it is NOT running. The slider occasionally moves, and the highlights are NOT shown at allZvihttps://www.blogger.com/profile/11684005090956389341noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-71921007081567294172011-08-12T10:23:16.433-07:002011-08-12T10:23:16.433-07:00Great post. The advantages of using JQuery in Cogn...Great post. The advantages of using JQuery in Cognos are many (Including compatibility between upgrades, for example), and this is really well-written, throughly explained and the code is very understandable and straight-fowrard. <br />I would like to share some inputs that may upgrade this method for some; mainly these 4 remarks:<br />1. The reason this code doesn't work for values over 1 million (Actually, over 999,999) is because the replace function here:<br />jQuery(this).text().replace(",",""))<br />will only replace the first occurence of the comma. Numbers over 999,999 have 2 commas, so the function attempts to numerify 1000,000 - and fails. <br />To overcome this, the replace command should use RE, like this:<br />jQuery(this).text().replace(/\,/g,"")<br />This should be implemented for all three replace commands. <br />2. This code will only work for non-aggregated lists, as also mentioned in the post. for lists where query is set to aggregate to the lowest level (Auto group&summarize), this code:<br /> jQuery('table[LID=lstJQuery] td:nth-child(' + column + ')').each(function(index)<br />Should be replaced with this:<br />jQuery('table[LID=lstJQuery] td:nth-child('+column+'n)').each(function(index) <br />Of course, if the list is grouped further, another technique would be required. <br />3. The code begins with the minimum value of 0. Some lists begin with a number higher than 0, making some leaps at the beginning of the slider redundant. I recommend changing 0 to a variable, say minVal, and after this part:<br /> jQuery('table[LID=lstJQuery] td:nth-child(' + column + ')').each(function(index) { <br /> if (Number(jQuery(this).text().replace(",",""))>= maxVal) {<br /> maxVal=Number(jQuery(this).text().replace(",",""));}<br /> });<br /><br />which sets the max value, add this:<br />var minVal=maxVal;<br />jQuery('table[LID=lstJQuery] td:nth-child('+column+'n)').each(function(index) { <br />if (Number(jQuery(this).text().replace(/\,/g,""))<= minVal) {<br /> minVal=Number(jQuery(this).text().replace(/\,/g,""));}<br />});<br />minVal=minVal-1<br /><br />4. Also, hard-coded leaps of 50 may not be suitable for the data. <br />For instance, if there are too many leaps, the silder might not be long enough. <br />Here, there are a few approaches, but probably the most comfortable one for the programmer would be to set the number of leaps we want to have (say, 10) hard-coded (Thus making controling the length of the slider that much easier) and then to find the step value by dividing maxVal-minVal by 10 (Or any other number), like this:<br />var step=Math.round((maxVal-minVal)/10)<br />and setting step to equal the step variable. <br />Note that you will have n+1 leaps, as the zero leap (This one from minimal value to the first step) is unaccounted for. <br /><br />Again, thank you for posting this - this is very very useful.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-7433890350754820852011-03-09T09:50:08.201-08:002011-03-09T09:50:08.201-08:00zschutz,
This is not a limitation of slider.
This ...zschutz,<br />This is not a limitation of slider.<br />This is the way i wrote the script.<br />You can override it by putting hard-coded value.<br /><br />original:<br />Query("#slider").slider({<br /> value: 0,<br /> min: 0,<br /> max: maxVal,<br /> step: 50,<br /><br />Modified:<br />Query("#slider").slider({<br /> value: 0,<br /> min: 0,<br /> max: 1000000,<br /> step: 50,Ran Avnonhttps://www.blogger.com/profile/08094602893536617346noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-73491754772370884892011-03-05T19:32:28.386-08:002011-03-05T19:32:28.386-08:00This is a great tutorial, thanks for posting this....This is a great tutorial, thanks for posting this.<br /><br />One quick question: I am attempting to use this on some of my own data, and everything is working fine except that I have some values that are greater than 1 million, and the slider doesn't seem to recognize these values. It sets the maxVal to whatever the highest value is in my list that is also less than 1 million. Is this just a limitation on the slider, or do I need to set some other option for it to handle these larger values?Unknownhttps://www.blogger.com/profile/07889808146306257308noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-39384727767302232692010-11-14T11:13:10.626-08:002010-11-14T11:13:10.626-08:00Thanks for the tutorial and thanks for the tip abo...Thanks for the tutorial and thanks for the tip about not using $.<br /><br />one question: have you gotten jquery work in a report using a tree-prompt on a prompt-page. The problem comes for me when the user re-runs the report - then the tree-prompt disappears for me.Davidhttps://www.blogger.com/profile/10869028939129447500noreply@blogger.comtag:blogger.com,1999:blog-2744439768720161806.post-71836860506726376312010-10-07T06:44:58.696-07:002010-10-07T06:44:58.696-07:00Great tutorial !.
Really great to see people pushi...Great tutorial !.<br />Really great to see people pushing the boundaries of Cognos 8 report development with jquery components.Nick Watershttps://www.blogger.com/profile/04235381410237672200noreply@blogger.com