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 the use of layout component reference
What is conditional Formatting?
Which studio is used to create reports?
at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???
1 Answers Covansys, IBM, Wipro,
What is the use of powerplay web viewer in cognos?
Cleared COG-112 with 100% score today. What next certification should i go for?
Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)
what are the filters in framework manager and report studio?
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.
Hi i want know mean and difference b/w render variable,conditional block and style variable please reply about them please be kind towards me
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.