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
- 20826 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 |
I want to run one page with filter and another page without filter, what is process?
What is Stich Query in Reportnet?
Mail me at: Amit_Cog@yahoo.com for a Very latest COGNOS 8 Certi Dumps like COG-112, COG-122, COG-125, COG-132, COG-142, COG-145 I scored Full Score, if anyone need it, just drop me a mail with Code
if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?
What are all the different types of prompt in cognos?
what is report view?
what is logs in cognos
1 Answers Target, Thomson Reuters,
-------------How to create a PortalTab?
How applying "Level Span" in Cognos 8.3?
how to explain a project to the interviewer on sales project and what r the basics to be prepared to attend a interview
What actually a project contains?
I need to display blue color for max Revenue and red color for min Revenue by using condition formatting how it possible........?
Teradata 
