How to upgrade the model means How to add new Query items in the existed model ?

basecog

 Profile Answers by basecog Questions by basecog

• Nov 22nd, 2007

Hi FriendCognos model is the metadata structure.For adding new query items we will fallow this steps1) select model you want add query item.2) Select the query subject you want add quer...

Answer Question  Select Best Answer

Element 'selectOptions' is not valid for content model: 'All(style,defaultSelections,conditionalStyles,conditionalRender,XMLAttributes)' RSV-SRV-0042 Trace back: RSReportService.cpp(629): RSException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(177): RSException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request RSASyncExecutionThread.cpp(562): RSException:...

greglvaughan

 Profile Answers by greglvaughan Questions by greglvaughan

• Aug 7th, 2008

Kind of okey, but If the problem is because you are trying to fill a value prompt with static values without setting a default (this is one way to fix this) you can create a new SQL query that is just...

Answer Question  Select Best Answer

ramesh4u

 Profile Answers by ramesh4u Questions by ramesh4u

• Feb 4th, 2008

By using Framework Manager we can create IQD files ,By using IQD files we can creat cubes in powerplay

Answer Question  Select Best Answer

How to improve report performance except limited local processing?

sivabisani

 Profile Answers by sivabisani Questions by sivabisani

• Nov 14th, 2008

To improve performance of a report we can approach these methodIn database level:1)In this level to improve performance create indexes to improve the performance.In model level :1)you can remove loop'...

Answer Question  Select Best Answer

Hello,Can any body help me how to tune performance in cognos8 or reportnet to run report or create model.

cognos.reddy

 Profile Answers by cognos.reddy Questions by cognos.reddy

• Jan 9th, 2008

In report level:1)you can reduce the calculation and condetions in the report 2) you can limit the cut copy phaste operations for user's3) you can limit access no of report's at peek time you ...

Answer Question  Select Best Answer

Could u explain briefly What is Static Choice?

ittoolboxcognos

 Profile Answers by ittoolboxcognos Questions by ittoolboxcognos

• Jan 5th, 2008

Static Choice is set of choice you provide to user for selection. These choices are manually entered in the field. E.g for value prompt when you select Radio GUI then you give choices to your users by manually entering the choices by selecting Static Choice property and clicking add new.

Answer Question  Select Best Answer

If there is no calculations and the data is summerized, will you use Materialized view? Give Reason

angel987

 Profile Answers by angel987 Questions by angel987

• Sep 5th, 2008

They can be used to summarize, precompute, replicate, and distribute data.but if there are no calculations needed and the summarization is already been done then not sure if we need to use them..

Answer Question  Select Best Answer

How to generate reports without package?

shree_uday

 Profile Answers by shree_uday Questions by shree_uday

• Aug 8th, 2008

Without package we can generate a reports in Cognos by using Query Explorer. Using QE, we can drag a SQL icon from the toolbox, and go to properties, there you can see the datasource tab, then double click, it will open SQL query window, there you can?type?the customized SQL query.

Answer Question  Select Best Answer

How to create frame work How to create .cpf file

Jaycognos

 Profile Answers by Jaycognos Questions by Jaycognos

• Jun 26th, 2008

Cpf are the cognos project file.Whenever you create a new project in the frame work manager , it will be automatically created as a .cpf file along with log files , some xml files etc ..

Answer Question  Select Best Answer

How will you migrate your reports to QA environment?

Jaycognos

 Profile Answers by Jaycognos Questions by Jaycognos

• Apr 8th, 2008

Through the content Administrator tool present in the cognos connection , we can deploy to QA environment.

Answer Question  Select Best Answer

How can we run the Report without using "Run Report" option in Cognos

mmadhoun

 Profile Answers by mmadhoun Questions by mmadhoun

• Jan 2nd, 2010

You can schedule the reports to run automatically by creating an event.

Answer Question  Select Best Answer

what is the repeater tableThanks,

srilug

 Profile Answers by srilug Questions by srilug

• Apr 26th, 2008

Repeaters are tables in which you can insert items that are repeated when you run the report. For example, use repeaters to create mailing labels. To build a repeater, drop the items you want in the r...

Answer Question  Select Best Answer

How to create Cognos Report? Explain in detail with one example

Jaycognos

 Profile Answers by Jaycognos Questions by Jaycognos

• Jun 26th, 2008

do u need to know in cognos 7 or cognos 8 series ?In Cognos 8 , for eg, using report studio , create a simple list report .for this , you should have the package already created in the FM model. using...

Answer Question  Select Best Answer

How can we create a new report using Cognos Impromptu?

sidney

 Profile Answers by sidney Questions by sidney

• Jul 27th, 2010

Open Cognos Impromptu, select file>newBingoYou'll have to select the type of report you want to create list, cross tab etc

Answer Question  Select Best Answer

Can u give me small example of cognos testing?

arunkiranrega

 Profile Answers by arunkiranrega Questions by arunkiranrega

• Aug 11th, 2008

Cognos unit testing includes1) Data checking - you need to match against data exactly what you desired2) You need to check the data format - eg check number of decimal places,date format,time format 3...

Answer Question  Select Best Answer

Please explain what is the use of event studio, analysis studio and metric studio and when and where we will use these studios

angel987

 Profile Answers by angel987 Questions by angel987

• Jun 26th, 2008

Analysis Studio - an application to analyze cubes and explore business data in a multidimensional manner. Mainly used by business analysts. • Metrics Studio - used for the scorecarding. The idea ...

Answer Question  Select Best Answer

How to migrate reports from reportnet to cognos 8

sivabisani

 Profile Answers by sivabisani Questions by sivabisani

• Nov 13th, 2008

Hi,In the cognos 8bin directory, there is a tool call RSupgrade.bat, we can use this command to convert Reportnet report spec to Cognos 8.NOTE: RSUpgrade.bat / RSUpgrade.sh is a standalone u...

Answer Question  Select Best Answer

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompts prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible,,,pls tell me

Khushboo Kapadia

 Profile Answers by Khushboo Kapadia Questions by Khushboo Kapadia

• Jun 12th, 2008

From Query Explorer, open up the query for which the filters should be applied on. 2) Drag a Filter object from the Toolbox tab to the Detail Filters pane.3) In the Expression Definition, enter the fo...

Answer Question  Select Best Answer

What is the difference between count and running-count functions?

Khushboo Kapadia

 Profile Answers by Khushboo Kapadia Questions by Khushboo Kapadia

• Jun 11th, 2008

For each row, this displays the quantity and a running count of the position of current row.Name-------SmithSmithSmithSmithWongWongQty------736435Count---------444433Running-Count for name--------------------------------------123412

Answer Question  Select Best Answer

How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?

sandeep8000861

 Profile Answers by sandeep8000861 Questions by sandeep8000861

• Jun 19th, 2008

A report can be created in less than one minute to sometimes around 1-week.It depends on the business logic/rule that is to be incorporated into the report.All the filters, prompts, conditional format...

Answer Question  Select Best Answer