Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly determinants are used in cognos framework
manager?
- 4 Answers
- 27035 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kavitha
A query subject that behaves as a dimension has multiple
levels of granularity and will be joined on different sets
of keys to fact data
| Is This Answer Correct ? | 21 Yes | 5 No |
Answer / lakshmi reddy
in framework manager if u are working with more than one
fact table then u have to check the granularity if fact
tables having different granularities i mean supose in one
table u r maintaining high cardinality in one table u r
maintaining low cardinality finally we may get over counting
to overcome that we use determinants in framework manager
where we have to group the repeated query items
| Is This Answer Correct ? | 3 Yes | 5 No |
Answer / janni
determinants is nothing but relation ship between query tables.
| Is This Answer Correct ? | 4 Yes | 34 No |
What is Clipboard? How to import XML file into Clipboard?
What is Parametermap?
What is a Folder?
What do you understand by ‘ibm predictive maintenance and quality’?
Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!
What will happen if scheduling a report with a prompt page?
What is the difference b/w macros and prompt?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
what is the difference between querystudio in reportnet and cognos8
---------------What is meant by Scheduling?
Teradata 
