What is Regular Dimension and Measure Dimensions and Diff
b/w them ?
- 2 Answers
- 19489 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bhaskar.nagi
A regular dimension contains descriptive and business key
information and organizes the information in a hierarchy,
from the highest level of granularity to the lowest. It
usually has multiple levels and each level requires a key
and a caption. If you do not have a single key for your
level, it is recommended that you create one in a
calculation. A measure dimension is a collection of facts.
You can create a measure dimension for one or more query
subjects that have a valid relationship between them.
| Is This Answer Correct ? | 19 Yes | 2 No |
Answer / abd hfz
Regular Dimensions
Regular dimensions represent descriptive data that provides
context for data modeled in measure dimensions. A regular
dimension is broken into groups of information called levels
which is organized into hierarchies. In turn, the various
levels can be. E.g. hierarchies of a product can be Prdt no,
Prdt name, Prdt line, Prdt description. Used in analysis
studio & in drill up & down methods.
Measure Dimensions
Measure dimensions represent the quantitative data described
by regular dimensions. Measure dimension is the object that
contains the fact data & Measure dimensions differ from fact
table because they do not include the foreign keys.
| Is This Answer Correct ? | 6 Yes | 2 No |
what is log in cognos?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
While running the reports how can we hide totals if the users doesnot requie it?
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
What are all the types of report?
Define query items?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What is drill down and slicing and dicing whats the difference between them?
If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,
how to do page breaks in cognos 8 Report studio pls give the navigation
What is Normalization?
What are different events in Report studio?
Teradata 
