Answer Posted / itesh biswal

Simple man

carnality and join are 2 diff things ,u can see in ur
cognos application u will be having 1:n the first part
explains u about the join and the second part tells u the
cardinality ,if in ur 1st part its 1:1 then equi ,if 1:0
then outer if 0:1 then outer if 0:0 its full outer

and the second part tell u the cardinality remember
cardinality never change the query output ,it only identify
the fact and dimension which is very important ,u remember
if u have muti-star schema then it should write two query
depend on two fact ,so pls do it correctly ,
1:n represents fact
1.1 represents dim

Check where is ur measure, put many in that cardinality


Cheers

Can you define framework manager?

1064

---

How to Reset Pagenumbers in one report.

2708

---

What is Bitmap Index?

1099

---

in u r data u having duplicates how to fetch the latest data in our report?

5830

---

I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

2138

---

which type of project we r going to snowflake schema

2021

---

What is model filter?

1314

---

Define datastores in cognos?

997

---

How do we convert from Numeric to be Words?

3090

---

write a query to display the departments with no employee?

2017

---

How can create users and permissions in cognos?

1006

---

what is log in cognos?

1259

---

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?

2561

---

Explain what is the difference between native sql and cognos sql?

1049

---

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

4057

---