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

ranganadh

 Profile Answers by ranganadh Questions by ranganadh

• Nov 23rd, 2007

1.Cognos SQLBy default, Framework Manager uses Cognos SQL to create and edit query subjects. Cognos SQL adheres to SQL99 rules and works with all relational and tabular data sources. Framework Manager...

Nageswara Rao Nandigam

• Nov 11th, 2007

  There are two types of sql in Cognos Reportnet .They are Cognos Sql and Native SqlNative Sql used for single datasource to import the meta dataCognos Sql used for multiple data source to i...

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

Hi,can anybody help me why outer joins are useful some times than inner joins in frame work manager while creating a model.

mail2alert

 Profile Answers by mail2alert Questions by mail2alert

• Dec 13th, 2007

Level span is used to eliminate duplictes in data, in cognos it is used repeat grouped item.using levelspan we can see the grouped data group by group.For example, when country and city are both group...

venu

• Sep 16th, 2007

Level Span is used to eliminate duplicates in a report which contains columns with one-one relationships. Usually we use grouping to eliminate duplicates when there is one to many relation. But if there is one-one relationship and still there are duplicates, then we have to level span.

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

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

Explain what Cognos DecisionStream is for extraction, transformation and loading a data into datamart?

please explain me How to import two data sources into Framework Manager?Can anyone tell me what is role of reporter writer in Cognos?

binay.bk

 Profile Answers by binay.bk Questions by binay.bk

• Jan 24th, 2008

We can import two data sources to Framework Manager  in the Run Metadata  Wizard.Go to Run Metadata  Wizard-->Select another database ( e.g. suppose SQL Server is choosed in prior attempt, then u can choose Oracle as new datasource).Then import it.

cognos.reddy

 Profile Answers by cognos.reddy Questions by cognos.reddy

• Jan 11th, 2008

yes you can import two datasources in frame work manager like thisfor example you are having databases like "oracle,sql server" ok1) first you can import any one of the database(Ex. first i ...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

binay.bk  

 Profile Answers by binay.bk Questions by binay.bk

• Member Since Jan-2008 | Jan 24th, 2008

---

Hi

Drill Through is used to link the master & detail reports.
After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that particular item (Order ID 1234).

Cascading prompt uses the value from the previous prompt to filter the value in the current prompt.

  For Cascading no need of two reports.If a report having two related columns (e.g. Country & States),then we can cascade these two columns by adding two value prompts.

If you select a country (e.g INDIA),in the next prompt all the states will be displayed those which are under INDIA.

If you want to see the details for the state Tamilnadu,then select TN from the list which will display all the details for TN.

binay.bk

 Profile Answers by binay.bk Questions by binay.bk

• Jan 24th, 2008

HiDrill Through is used to link the master & detail reports.After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that...

subbu

• Nov 4th, 2007

Cascading report contains one report and it work based on the condition.drill through contains two reports parent report(summary),child report(detail report)child report contains a parameter that must accept the values passed from parent report.

Improve Answer

How does a firewall provides security for report net?

What is notation for cardinality?

What is meant by dynamic column. How can you create dynamic column in reports?

How to migrate impromptu reports to cognos reportnet?

How can you explain about the work flow of your project.

Jaycognos

 Profile Answers by Jaycognos Questions by Jaycognos

• Jan 30th, 2008

We can use 1.incremental updates,2.use multiple data sources or 3.partition your cube using auto-patition, the size of the cube but runtime performance will increase drastically.4.check power cube status and 5.perform test cube .Refer step by step transformer guide for more details.

Answer Question  Select Best Answer

How to evaluate the cube?What are the differences between Cognos 8 and Cognos 7.x version?

What is the fact less fact table? why we use this table?give me one example

chandrarekha

 Profile Answers by chandrarekha Questions by chandrarekha

• Feb 13th, 2008

A fact table without measure is called a fact less fact table for negative analysis report we use this fact less fact table

praveenj6

 Profile Answers by praveenj6 Questions by praveenj6

• Feb 1st, 2008

If there are no facts(Measures) in a table then it is called as fact less fact table.

Answer Question  Select Best Answer

How to apply securities (in Oracle Enterprise Manager) for the Content Manager (Database) while installing Cognos?