Interested to Buy Any Domain ? << Click Here >> for more details...
what are determinants?
- 4 Answers
- 12397 Views
- Dominion, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / satyanand86.m
To prevent double counting on multi fact/multi grain queries we need determinants on query subjects that have multiple level of granularity used to aggregate facts.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / srinivas naidu
Determinents are new concept introduced in cognos 8 this is
used to avoiding double counting in framework
manager.......suppose if the data existing more time in
tables at that time we go for determinents(avoiding
duplicates)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sreenivas
Determients is the set of database columns that can be
used to uniquely identify set of data.
Determinants are imported based on key and index
information in the data source
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopal
By using determinants we avoid the double counting values....
| Is This Answer Correct ? | 0 Yes | 0 No |
16. How can we create top 10 and bottom 10 records in the same list?
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?
i have one file i saved in csv how can i take these file into framework manager
Can you define fan trap?
How can we do the unit testing?
What junk dimension contains?
Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What is the difference between regular dimension and derminant?
What are initial page components of Cognos connection?
write a query to display to 10 max record from the employee table?
Teradata 
