Search results for query: *

I would like to know whether following requirement can be met by Cognos Products : A user is viewing the Visualization and the powercube on which the visualization is based got refreshed on the background. Can the visualization be refreshed automatically on happening of this event ? If not...

Can you check the system clock of the machine which is giving a problem ? Does it show any different system date than the ones which are running fine ? Are you filtering your data based on the system date ?

seyidanmole Please go through the following documents appearing on cognos knowledge base. Document#: 109583 Document#: 94670 Document#: 85779 Provide your feedback on which solution worked for you Vivek

W860098 I think you will get what you are looking for in 'Show Reference' and not in 'Show Scope'. There appears to be no printing option in 'show scope' but 'show reference' definitely has print facility Vivek

Prapagar Thanks for you feedback vivek

Hi Kejal, You can try putting an 'ALL' value in the prompt. There is enough material available on this technique either on this discussion forum or cognos knowledgebase. .... Vivek

Hi Sam, Did you try 'is missing' option in the expression builder for NULL values ? .... Vivek

Back again prapagar, I had faced a similar problem in Ver 6 of Impromptu while I was connecting to MS SQL Server 2000 in native mode. I found one knowledgebase document which stated that UDF will not work in native mode. When I changed my connection to ODBC, I started getting that function. I...

Hi Prapagar, Did you try a syntax checking utility provided by Cognos. It has been documented in the PDF file for UDFs ... vivek

Sorry Sri, I noticed afterwards that you have read the earlier posts. There I had specifically mentioned that picklist limit is 65000. I got confused because you have posted "I hope Picklist list maximum limit is 50,000 or 60,000." To me also, Dave's suggestion seems to be the only...

Hi Sri, Have you read replies to your thread401-662505 ?

I had posted a thread in this forum earlier for converting a number to word in Impromptu (thread401-240219) I have been successfully using this fuction in Impromptu since I got the answer. Now I have noticed that this function does not work for summary values e.g. Total. I can convert the...

...get all the values in the picklist. Cognos Knowledgebase gives following recommendation : The default SORTMEM setting is 512. This should not be set higher than one quarter of the available RAM on the system. For 256mb of RAM the SORTMEM should not exceed 65536. (256 * 1024 = 262144 / 4 =...

Hi shelldataguy, Correct me if I am confused, but your requirement appears quite simple to me. since I dont have data similar to you, I tried it on Great Outdoor catalog. The requirement can be reframed as follows : calculate the number of products for each product line under each product...

Hi, Try creating another calculated column which will look like 'Count(Ticket#) for Status Hope this helps

Try creating a report with a form frame. This will allow you to create the free format report. The fixed kind of a text will have to be inserted using a text frame option e.g. the text 'To:' and 'Date:' If this report is to be run for one employee at a time, provide a prompt for getting the...

Hi Dona, You can copy a particular job stream (out of many that you have) to another catalog. Try create package option from the file menu and select a particular job stream that you want to copy. However Decision stream will create a package of all the related catalog components. e.g. If the...

Hi, Anybody is aware of an automated way of Documenting the PowerPlay Transformer Model files ? Thanks in advance Vivek

I have developed a very complex model in Architect and now want to document it. Surprisingly, I could not find any way within the Architect to develope the documentation. The only ways I could find are : a) Print the entity diagrams (But unfotunately the diagrams show the linked tables but not...

Roger, This is quite easy in reporter mode. I suggest you develope the columns using following steps 1) First Create top level columns i.e. Jan, Feb and Cumulative 2) Then drop the measure Actual. But be careful this time to use short drop zone (and not the long drop). e.g. Drop Actual in such...