tag:blogger.com,1999:blog-21606293.post116616036413117773..comments2023-11-05T05:48:11.748-06:00Comments on Learn Discoverer Blog: Creating indexed itemsUnknownnoreply@blogger.comBlogger13125tag:blogger.com,1999:blog-21606293.post-5194977084523937742009-01-10T11:17:00.000-06:002009-01-10T11:17:00.000-06:00Hi AshrafI will be covering this in my upcoming we...Hi Ashraf<BR/>I will be covering this in my upcoming webinar on 14th January. If you would like to sign up follow this link:<BR/><BR/>http://ascbi.com/question.htmMichaelhttps://www.blogger.com/profile/15681943886306975181noreply@blogger.comtag:blogger.com,1999:blog-21606293.post-60044053365334595232008-12-28T23:17:00.000-06:002008-12-28T23:17:00.000-06:00Hi,Would you please show me the way of creating a ...Hi,<BR/>Would you please show me the way of creating a LOV with hard coded values. <BR/>the LOV i need should display same values all the time. so instead of creating a LOV that reads from a table (Query) i need a LOV in which values are alredy stored (Hard coded).<BR/>Thanks in advanecUnknownhttps://www.blogger.com/profile/13506119141739955982noreply@blogger.comtag:blogger.com,1999:blog-21606293.post-52593959533213683042008-10-15T07:45:00.000-05:002008-10-15T07:45:00.000-05:00Hi,Above is a beautiful explanation of Indexed Ite...Hi,<BR/>Above is a beautiful explanation of Indexed Item. <BR/>what I want is that whatever the user selects i.e. Index or value, the numeric value should ONLY be pass to the database <BR/>because If description or value is changded in the database for example '10:John Michael' to 'John-Michael' in the database then in no data comes in the reports. as the user for example has viewed report based on this selection and saved the report,next time when he/she will open the report nothing will come because the Name is changed in the database.<BR/>Please suggest the solution<BR/>Thanks in AdvanceKamranhttps://www.blogger.com/profile/15616729382951882733noreply@blogger.comtag:blogger.com,1999:blog-21606293.post-42278383350195158782008-06-05T13:24:00.000-05:002008-06-05T13:24:00.000-05:00Hi SoumyaYou cannot created cascading parameters i...Hi Soumya<BR/>You cannot created cascading parameters in Desktop. This feature is restricted to Discoverer Plus versions 10.1.2.0.2 and higher.<BR/><BR/>You can execute cascading parameters in Desktop 10.1.2.0.2 and higher but you cannot create or maintain them in there.<BR/><BR/>MichaelMichaelhttps://www.blogger.com/profile/15681943886306975181noreply@blogger.comtag:blogger.com,1999:blog-21606293.post-52075752246616773172008-06-05T11:13:00.000-05:002008-06-05T11:13:00.000-05:00Hi!I want to restrict the no of values to be shown...Hi!<BR/><BR/>I want to restrict the no of values to be shown yo the user to some values corresponding to him.<BR/><BR/>eg. Suppose their are 100 department. <BR/>In first case, User A is a simple employee, then he should be shown the department corresponding to him say Dept 30 in the LOV to select.<BR/><BR/>In second, User B is a Zonal Director and has access to the department under the Zone say 10 Departments, Then User B should be able to see all the department under his responsibility in the LOV and not others.<BR/><BR/>In third case a Country Director should be able to see all the department.<BR/><BR/>I tried to create the custom folder like <BR/><BR/>Select deptno from dept where deptno in (select deptno from <B>user_dept_mapping</B> where lower(ename) = lower(user))<BR/><BR/>user_dept_mapping --> is the table where each user has been mapped to the department they can see.<BR/><BR/>I get the values as per the query in discoverer sheet, but while in LOV it shows every value.<BR/><BR/>I am helpless ...kindly help.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21606293.post-34521371035984017342008-06-03T18:15:00.000-05:002008-06-03T18:15:00.000-05:00Could you please elaborate on how to use cascading...Could you please elaborate on how to use cascading parameters and how to define them in Discoverer Desktop 10g?Unknownhttps://www.blogger.com/profile/08015314143562508245noreply@blogger.comtag:blogger.com,1999:blog-21606293.post-53344024866486669642007-06-21T16:32:00.000-05:002007-06-21T16:32:00.000-05:00HiI want to do the LOV but in a customize folder, ...Hi<BR/>I want to do the LOV but in a customize folder, how can i do that?<BR/>thanks...<BR/><BR/>Manuel BermejoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21606293.post-16644795475449145592007-03-01T16:41:00.000-06:002007-03-01T16:41:00.000-06:00Hi GregWhich patchset did Oracle suggest you upgra...Hi Greg<BR/>Which patchset did Oracle suggest you upgrade to?<BR/><BR/>With regards to passing an indexed item across a hyper link I think you're going to be unlucky. I'm pretty sure this won't work for the very reason you hinted at in your example. The parameter in the second workbook is looking for an actual value to filter on.<BR/><BR/>Best wishes<BR/>MichaelMichaelhttps://www.blogger.com/profile/15681943886306975181noreply@blogger.comtag:blogger.com,1999:blog-21606293.post-15527754344681511072007-03-01T16:38:00.000-06:002007-03-01T16:38:00.000-06:00Hi Michael ChaikowskiDid you try creating a cascad...Hi Michael Chaikowski<BR/>Did you try creating a cascading parameter using one of the items to filter the other?<BR/>I think the issue you have is that the items are in different folders and I have a strong suspicion that this is a no-no in Discoverer. From what I have seen, I believe the items need to be in the same folder.<BR/>Best wishes<BR/>MichaelMichaelhttps://www.blogger.com/profile/15681943886306975181noreply@blogger.comtag:blogger.com,1999:blog-21606293.post-6734516712341768192007-03-01T16:16:00.000-06:002007-03-01T16:16:00.000-06:00Being new to discoverer, I have the following ques...Being new to discoverer, I have the following question about indexed items. <BR/><BR/>I have a two table join inwhich an LOV is created from the 2nd table. What do I need to do in Discoverer to use the key returned in the LOV as part of the predicate when filtering records in the first table?<BR/><BR/>Let me know if more information is needed.<BR/><BR/>Thanks,<BR/><BR/>Michael Chaikowski<BR/>Nashville,TNAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21606293.post-79539040097574354542007-02-14T17:01:00.000-06:002007-02-14T17:01:00.000-06:00Hi MichaelYour example with the index item works g...Hi Michael<BR/><BR/>Your example with the index item works great.<BR/><BR/>I picked up a funny bug with the version of Discoverer I've been using. When switching on "Display Search Dialog" for a LOV with an indexed item, the placeholder that returns the text or index item actually concatenates both index and text values rendering the LOV useless. E.g. "(2) Jones, Edward".<BR/><BR/>According to Oracle Support, we need to upgrade to later patchset.<BR/><BR/>I have another problem. If I create a parameter based on LOV with indexed item, how do I pass and index value to it from another workbook e.g. from a hyperdrill link. The called workbook always reverts to the text LOV. What can I do to resolve this?<BR/><BR/>Any help will be greatly appreciated.<BR/><BR/>Thanks<BR/><BR/>Kind regards<BR/><BR/>GregUnknownhttps://www.blogger.com/profile/05759275234362657664noreply@blogger.comtag:blogger.com,1999:blog-21606293.post-46494130347094936032007-02-13T00:38:00.000-06:002007-02-13T00:38:00.000-06:00HiYou need to use what are termed Cascading Parame...Hi<BR/>You need to use what are termed Cascading Parameters.<BR/>To use these both items need to be in the same folder and both need to have lists of values. These work best when there is a hierarchy between the items.<BR/>Cascading parameters can only be created in Discoverer Plus 10.1.2.<BR/>Best wishes<BR/>MichaelMichaelhttps://www.blogger.com/profile/15681943886306975181noreply@blogger.comtag:blogger.com,1999:blog-21606293.post-1166594836382835182006-12-20T00:07:00.000-06:002006-12-20T00:07:00.000-06:00Could you please provide me solution for LOV valid...Could you please provide me solution for LOV validation in discoverer viewer. I have one operating unit LOV and warehouse LOV. Now I want to validation for above two LOV. Means if user select US operating unit than warehouse LOV should give only US warehouses.<BR/><BR/>Please help me to sorting this issue.<BR/><BR/>Thanks in advance.<BR/><BR/>DJRathodAnonymousnoreply@blogger.com