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!

  • Congratulations SkipVought 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. Draoued

    COGNOS 8.2 Analysis URI Gateway error

    If you have IIS server , have you set the permission for IIS to execute the ISAPI or dll ?
  2. Draoued

    Report Filter for User which is logged in

    if using reportnet or C8 , you can use ParameterMap in your package to filter the query based on the user signon.
  3. Draoued

    Cognos8 BI release 8.2

    Cognos 8 BI version 8.3 will be in beta shortly ..... http://seekingalpha.com/article/39103 But as mfgf said , it doesn't tell when it will be released.
  4. Draoued

    How do I create a NEW Cognos Catalog file *.cat ?

    cat files are created using Impromptu Administrator.
  5. Draoued

    Cognos Recommendations/Books for Beginners in Framework Manager

    if you are supported customer you can check this pdf file: Framework Manager best practice
  6. Draoued

    IWR Posting

    I think Macro are not executed within Impromptu Web server. What I would do. Having IMR2 and IMR3 as Snapshot files, and using them in FINAL.IMR. You can in Upfront define dependancies between reports, so that when you run FINAL.imr , it first runs IMR2 and IMR3 to refresh the snapshot content...
  7. Draoued

    Cognos Transformer Number

    don't forget the Input Scale in data Source as well.
  8. Draoued

    Displaying Only Selected Columns

    As I said , you have to read between the lines of this supportlink article to extend it to your own purpose. To have it in a simple way. Defined how many maximum columns they can have . Create as many list prompt as you need. For each prompt you have create as many query items. like Query ItemX...
  9. Draoued

    Displaying Only Selected Columns

    If you are using CRN or C8 this is very possible. I did it . Check SupportLink http://support.cognos.com/supported/supportlink/multimedia/mm_0703_02.html You have to read between the lines but everything is there. Query Item1 = Case ?Parameter1? When 'prodline' Then [Product Line] When...
  10. Draoued

    Prompts and Filters behaviour

    have you tried the opposite : ( 'Employment Specialist' in (?prmReqType?)) because your ?prmReqType? can be a list of items.
  11. Draoued

    Subsets in PowerPlay change after Cube rebuild

    It could happen if your Category Code is not always the same in your cube model. The description is not changing ( Label) but the internal code of the category has changed. Change in your model the category code to be the same as your category source.
  12. Draoued

    Upfront Unable to Connect to Database Error

    open Impromptu Web report administration Select your catalogue and play around with the settings userid/password saved in Impromptu Catalogue or in Access manager. Very often the problem comes from this selection.
  13. Draoued

    Upfront Unable to Connect to Database Error

    Open a remote connection to your IWR server. Stop the IWR service. Start in file explorer /cer4/bin/impserver.exe hit on your keyboard CTRL+o it will ask you which report you want to open. Select your report , and you might get more descriptive error message. If the report opens properly , it...
  14. Draoued

    cognos startup error

    I think this line is the critical one : CAM-AAA-0145 There is no namespace that is properly configured for authentication. I hope you have not deleted the Cognos namespace. Have you added your own Ldap, Active directory or Access Manager settings in Security settings section in cognos...
  15. Draoued

    Creating Multiple Page Reports

    which application are you using ?
  16. Draoued

    Best Way to use a list of values as a filter

    can't the Search and Find object help you on this area ?
  17. Draoued

    Tabular SQL If else logic

    so in order to correct my previous post. (select /*+ FIRST ROWS */ "Request"."REQUESTID" "Request_ID" from "ECASH"."REQUEST" "Request" where "Request"."VOID"= decode(#prompt('choice')#), '0' , 0 , 1 ) This should work , note the quotes around the first 0 in decode.
  18. Draoued

    Tabular SQL If else logic

    one additional comment: I think that by default (#prompt('choice')#) is returning a STRING and not a number , so try it with #prompt('choice')# = '0' or use #prompt('choice','integer')#
  19. Draoued

    Tabular SQL If else logic

    try your sql as individual query, to check if your sql is correct. First this one only. (select /*+ FIRST ROWS */ "Request"."REQUESTID" "Request_ID" from "ECASH"."REQUEST" "Request" where "Request"."VOID"=0) and the second after. Or try the following (select /*+ FIRST ROWS */...
  20. Draoued

    Impromptu 7.3 on XP

    thread401-1212179

Part and Inventory Search

Back
Top