Interested to Buy Any Domain ? << Click Here >> for more details...
What is the importance of Dimension in the cognos.
- 3 Answers
- 10939 Views
- Hexaware, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shree uday
Dimension is a major subject area through which we can
analysis our business.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / fmq
with out Dimension and Fact cannot make a relations between
tables it could not be use for joins and retrive the data
as a form of reports in cognos
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / palzkumar
Depends, how you design your model in FMW, incase, thru
RDBMS, then there is no question of Dimension.
Incase, thru dimensional modeling, then its shud join to
Fact Table with 1:n realationship.
rgds,
palz
| Is This Answer Correct ? | 0 Yes | 3 No |
------------ Diff b/w MemberCaption and MemberDescription?
What is model filter?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
What are the themes in a data warehouse?
What are Governer Settings?
What is the difference between static and dynamic conditions?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
what are the components having in the report studio using interface eg:insertable objects pan,properties pan
How to create Events?
What is value prompt limitations while creating report? What is select and search prompt?
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)?
Teradata 
