Answer Posted / arkchowdary

A view is, in essence, a virtual table. It does not
physically exist. Rather, it is created by a query joining
one or more tables.

Creating a VIEW
The syntax for creating a VIEW is:

CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;

Give the advantages of cognos?

983

---

How to test a cube?

2129

---

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2143

---

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2032

---

How Metrics Studio is better than Report Studio?

2510

---

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

1953

---

Can you define confirmed dimension?

1024

---

Can you define drill across?

928

---

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1988

---

can you tell me what are the dimension tables are used in project

2250

---

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2470

---

What are types of batch available in cognos?

919

---

---------------Tell me about DWH Concepts?

2078

---

Define dimensions?

975

---

What are the considerations regarding performance kept in mind while setting up cognos?

919

---