Interested to Buy Any Domain ? << Click Here >> for more details...
What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....
- 4 Answers
- 22198 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / palzkumar
Auto aggregation function will be set to sum which is incorrect... & also Join will not be proper.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / jetuvisweswer rao
It identifies the intended use for the data represented by each query item.
1.Identifier:A query item with the type key. Exmple:Emp_id,Ship_date
2.Attributes:A dataitem with datatype string. Example:Product_name
3.Facts:Numerical values Exampe:Revenue
| Is This Answer Correct ? | 5 Yes | 2 No |
Usage property is nothing but to set the data item values
either as an ATTRIBUTE,IDENTIFIER,FACT.
IDENTIFIER and FACT represent numeric values but the
difference is whenever database contains key values then we
have to set as an identifier otherwise FACT in Framework
manager.
EMPID contains primary key value at database side then in
framework manager we have to set as FACT for that.it will
gives the results as a sum in reprtstudio.
example:
EMPID(primary key at database side)
1
2
3
4
EMPID(FACT in FM)
10
EMPID (IDENTIFIEr in FM)
1
2
3
4
| Is This Answer Correct ? | 4 Yes | 1 No |
What are the different kinds of panes included in cognos?
----------------What is Surrogate Key?
What is drill down and slicing and dicing whats the difference between them?
advantages of cascade prompt ???
what are the components having in the report studio using interface eg:insertable objects pan,properties pan
What is meant by report studio short cut?
what is the difference between a data item and a query item?
Hi,please suggest me how to creat username while creating a report.
can we insert all types of charts in a list report? what r the realtime prompts?
What is Bitmap Index?
How the Bursting happens in same report and how to Print the bursting Report?
I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.
Teradata 
