Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kajarekar

    Refreshing Visualizations

    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...
  2. kajarekar

    Impromptu Report Problem

    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 ?
  3. kajarekar

    Transformer Error

    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
  4. kajarekar

    Column Reference listing - Transformer ?

    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
  5. kajarekar

    Problem in UDF

    Prapagar Thanks for you feedback vivek
  6. kajarekar

    Hi, I have one issue with pr

    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
  7. kajarekar

    Making an Impromptu sub-report invisible

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

    Problem in UDF

    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...
  9. kajarekar

    Problem in UDF

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

    Picklist Limit Problem

    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...
  11. kajarekar

    Picklist Limit Problem

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

    Impromptu - Number to Words for summary

    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...
  13. kajarekar

    What is the maximum valu of picklist??

    ...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 =...
  14. kajarekar

    Impromptu-Calculating grouped columns

    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...
  15. kajarekar

    Impromptu-Calculating grouped columns

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

    Need Help For Form Letter Type of Report

    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...
  17. kajarekar

    Decision Stream - copying a Job stream definition

    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...
  18. kajarekar

    Transformer Model Documentation

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

    Architect - Documentation

    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...
  20. kajarekar

    Powerplay - Reporter Measures

    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...

Part and Inventory Search

Back
Top