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....

Answer Posted / sreenivasulu pokuru

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give me any example of semi and non additive measures?

555


How to generate cubes in cognos?

567


What is meant by junk dimension?

567


What is a Framework manager?

561


How to select multiple values from type-in prompt?

643






what is the difference between list report and crosstab report?

710


what is power prompt in cognos ep7series?what is the use of this?

3201


2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

1720


i was asked what are the caluclations done by you in your report? plz give reply

1711


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1535


Can you define snapshot?

553


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1483


What is the use of powerplay web viewer in cognos?

554


What is the enterprise class platform architecture of cognos 8?

584


What is the use of powerhouse?

612