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 |
what is a prompt value in report studio and variables ?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
How to create a cube in Transformer? What is the process? Please mention process thank u
How can we Maintain the Cube Security by Category level and Dimension level ?
which difficult you faced in your project?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
Create 12 columns for months by writing single case statement?
How to create a Ratio in Cognos Report studio Reports?
what is report burn and where it occurs
What is namespace and what it holds?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com