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....
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 |
set scope level in transformer
What are the differences between Cognos 8 and Cognos 7.x version?
What is the difference between Open Connection command ang Open Session Command?
Where do you set security levels for users in reports?
What are the considerations regarding performance kept in mind while setting up cognos?
What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?
How applying "Level Span" in Cognos 8.3?
I want to run one page with filter and another page without filter, what is process?
Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?
What are all types of prompt?
hi friends pls forward impropmtu interview question
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?