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 Rhinorhino 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: *

  • Users: Shek
  • Order by date
  1. Shek

    Reportnet Problem

    Is there any backward compatibility? 1. Can a report created using Cognos 6 be opened and then edited using Cognos ReportNet? 2. Does ReportNet have any component which maps to the Powerprompts. What it is called? Can these (powerprompts) also be opened and edited using ReportNet Thanks in...
  2. Shek

    Grouping cubes into logical groups and refreshing

    You can create another cube in the same model IN Powercubes window-> Insert owercube In this cube, you can change the properties as you want what if we want all levels of all dimensions ...??? Allowed also can we put cubes with totally different dimensions in a cube group ?? You can do this...
  3. Shek

    Transformer is retaining value if there is no data

    Your measure M1 looks like it is associated wiht the dimensions, hence, you get the data viewed correctly. eg select A, B, C, sum(M1) FROM..... and you view against dimensions A and B on X and Y resp in Powerplay you will see correct data for measure M1 but for M2. if your select is something...
  4. Shek

    Rpt output in Excel with format.

    You will have to use macros for that.
  5. Shek

    how to run Impromptu macro from command line?

    As it is a macro, you need to insert it in Cognso report Report--> macro--> Add the macro. It will run when the report is opened. You can run the REPORT from cmd prompt When I grow up, I want to be a child
  6. Shek

    Tips to improve Impromptu report performance?

    Click report--> Query--> Client Server-->Database Only. Yes you lose the Impromptu functions use which you can do only in flxible or limited local processing When I grow up, I want to be a child
  7. Shek

    how do you limit category generation in Transformer?

    1. You can copy the model and iqd in different folder and put filters in the sqls of the iqds Say limit te geography to only one country by condition select..... from... where country_name = 'INDIA' and so on for all iqds. This filter needs to be present in the Measures iqds which refer to...
  8. Shek

    COGNOS MACROS

    thread401-214141 help too
  9. Shek

    Impromptu / IWR Catalog Prompts

    when you are running the report as an imr, you may be putting values in the catalog-prompt yourself. WHen you are running thru Powerprompt, these prompt values are not getting updated and hence are not used in the report. Are you doing GetQuery().SetPromptValue anywhere in the Powerprompt...
  10. Shek

    Combining two reports

    Does it come from a different database. If not then it can be done. Store each report as a hotfile (ims) and then the new report will have thse 2 ims' as the source. Of course you need to refresh the ims to that the data is current( ims stores the data from the DB onto your local machine). This...
  11. Shek

    update the DW when the data in original source change ?

    I dont think refresh (Update in Cognos) the cube will help, coz refresh will just fetch NEW records from the database into the cube. You need to create the cube again in the sense, the cube is created again based on the existing model. You dont need to create the model (mdl in Cognos) again...
  12. Shek

    Automatically appending to a SQL statement...

    You are edit the sql ( change for fetch only to..) once you run a report, but after that you cannot format any columns and manipulation of the report has to be thru the sql window In Report--->Query---> Sql. HTH
  13. Shek

    date-to-string function

    I think, you can change that. The format it takes it from system settings in control panel. Right now, I am not in front of the computer. wait, I am. I forgot So go to control panel--regioanl settings--date and change the settings there. That should work.. But you need to apply it on date...
  14. Shek

    Modifying SQL in Impromptu

    First select all the fields into the report that you want to be displayed. Press Ok. Go to profile, Sql and press edit. Now you can edit the query that is generated using the pre-made joins. ALl the new filters you will have to apply in this SQL query itself.
  15. Shek

    What is PowerPrompts ???

    These are the filters that you are prompted for when you open the report. The types are 1. type in - you can type a string, date, number and so on. and the data matching what you enter at the prompt will be shown in the report. 2. FIle picklist - In a text file with the various criterion for...
  16. Shek

    Visual SourceSafe and Configuration Management

    Se each report is an independent piece of code and doesnt have dependence on anything else except the catalog and accessories like prompt files. Sometimes it has back reports too which run and are stored as hot file. What you can do is in VSS, have a work area and release area. In the work...
  17. Shek

    Starting question about DW

    A datawarehouse is always supposed to be denormalized.But what Bill suggests is right. You need a normalized "database" where all the tables are properly indexed. Analysis of data calls for a datawarehouse generally but I am not sure how you can analyze and compare the stuff if its not...
  18. Shek

    Does Cognos support Unicode Databases??

    http://support.cognos.com/support/products/series7_software_environments.html Check this out. But it seems it doesnt support Unicode databases
  19. Shek

    Divide by Zero error message when I'm not dividing by Zero.

    try if (A is not missing or A<> 0 ) then ((B-A)/A) else Null.
  20. Shek

    Conditional Formatting

    In report-->Query-->Client/Server, make flexible processing. IF this doesnt work, then try adding, deleting a few columns. Also try to use database functions as far as possible. If nothing else works, you'll have to split the report :-(

Part and Inventory Search

Back
Top