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 |
Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance
-------------What is Coditional Prompting?
can we put more measure on cross tab? If so how many? How this affect the aggregation?
What are different events in Report studio?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What DB View and Bus View?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What is cognos connection?
What is called Cognos powerplay?
how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..
How do add dynamic titles in PP?
what is stitched query???