Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly determinants are used in cognos framework
manager?
- 4 Answers
- 26736 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sajj
Let us understand the determinants in simplest terms.
Company CEO Empl
-----------------------------------------------------
Ennov Vijay Vishwas
Ennov Vijay Mritunjay
Ennov Vijay Farrukh
Company Revenue
---------------------------------------
Ennov 500000
Carrot 400000
When above 2 tables are joined on Company field and you
bring following items in the query Company,CEO, Revenue. The
the following will be the output
Company CEO Revenue
-------------------------------------------------
Ennov Vijay 500000
Ennov Vijay 500000
Ennov Vijay 500000
You got three rows because Ennova had three employees, here
cognos was not able to understand that granulirity of both
these tables was different. You have to defined it
explicitely and end product of this is called DETERMINANTS.
Here in the first table you have to define 2 determinants
CEO and Company and and check the check box of group by. Now
when you run the query in cognos you will find that
repeation is not there.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What is defined as data mining?
Why cognos decision stream is used?
What is the complex report you faced in real time?
Explain about scorecarding?
What is catalog and types of catalogs in cagonos and which is better?
Can we test the report other than manual testing?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
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!
-------------How you design DWH?
how to merge 2 crosstabs thans
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What are the types of security?
What is an olap designer?
Define catalog in cognos and write its various types?
Explain what is the difference between microstrategy and cognos reporting tool?
