Search results for query: *

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

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

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

You will have to use macros for that.

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

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

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

thread401-214141 help too

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

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

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

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

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

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.

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

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

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

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

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

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 :-(