GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Cognos
Go To First  |  Previous Question  |  Next Question 
 Cognos  |  Question 127 of 172    Print  
Framework Manager
What is usage property? Where do we set usage property? What is usage property for fact and dimension tables. What are the properties of usage property?


  
Total Answers and Comments: 2 Last Update: January 27, 2008     Asked by: Ayodhya.g 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
December 20, 2007 07:35:17   #1  
balachandrudu Member Since: December 2007   Contribution: 3    
RE: Framework Manager

Frameworkmanager allows u to create project.project provides metadata developoment environment.


 
Is this answer useful? Yes | No
January 27, 2008 16:53:34   #2  
cgns.cgns Member Since: January 2008   Contribution: 3    
RE: Framework Manager
1.The Usage Property Identifies the intended usefor the data represented by query item.
It determines the aggregation rules of query items and calculations.
The different usage property settings are
Identifier
Fact
Attribute
Unknown

2. To set the usage property
click the query item u want to set the usage property for
Then click the properties icon on the tool bar or you can see the properties pane on the right side of the browser.
go to "USAGE " tab and click "CLICK TO EDIT"  option.
and select the appropriate.

3. Usage property for dimension table and fact table should be determined by looking at the query item and how you want to represent it in your report.
 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : Impromptu Query Definition - Database metadata - Select the query subject items in FM that we want to export in the form of an IQD and select the right option from the contextual menu. ...
Latest Answer : Yes. You can do this by following the steps below:1. Configure Access Manager runtime on your desktop using "Access Manager - Configuration Wizard".2. Update Catalog properties in Impromptu to use Access Manager by specifying the namespace.3. ...
Read Answers (1) | Asked by : Vinoj
Latest Answer : Hi,Try this methodIn FM right click on the Namesapace in which you want the stored procedure to be imported...Select Create->QuerySubject....New Query subject window appears... Select the third option "Stored Procedure" -->Click Ok...New Querysubject ...
Read Answers (1) | Asked by : babu
Latest Answer : Ok, let's start with the definitions...hierarchyA description of the order of levels in a dimension. In Framework Manager, you define hierarchies in the query subject. levelA group of query items that must contain a key query item, so that each member ...
View Question | Asked by : naveen
Latest Answer : A model is a logical view of the enterprise, where in a package is a subset of the model. This helps in reducing redudnant copies of the database objects in several places. For example, you can create one single model for the entire warehouse and choose ...
Read Answers (1) | Asked by : naveen
Latest Answer : Object level security ...
Read Answers (7) | Asked by : Harish
How do you handle this DB Schema changes in our Framework manager to update automatically our meta data
I have created meta data model using Cognos FM and later source data base column were changed but DBA was not informed the changes. How to handle this DB Schema changes in our Framework manager to update 
Read Answers (1) | Asked by : Siva
Latest Answer : By using Framework Manager we can create IQD files ,By using IQD files we can creat cubes in powerplay ...
What is usage property? Where do we set usage property? What is usage property for fact and dimension tables. What are the properties of usage property? 
Latest Answer : 1.The Usage Property Identifies the intended usefor the data represented by query item.It determines the aggregation rules of query items and calculations.The different usage property settings areIdentifierFactAttributeUnknown2. To set the usage property ...

 Sponsored Links

 
Related Articles

Breaking up XML into Relational Data

Breaking up XML into Relational Data While the preceding example shows how to construct an XML representation over relational data the example in this section illustrates how you can shred XML data back into relational data This reverse operation can be useful if your application works with relation
 

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat
 

Retrieving XML Data

Retrieving XML DataTo retrieve XML data from an XMLType table you can use a SELECT SQL statement just as you would if you had to query a relational table For example to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section you might issue the
 

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

ODP.NET - Techniques to Improve Performance while Retrieving Data

ODP NET Techniques to Improve Performance while Retrieving Data Performance tuning is a great subject in Oracle Volumes of books would not be enough to cover every aspect of performance tuning in Oracle However in this section we will only discuss the fundamental performance techniques while working
 

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

ODP.NET - Retrieving Typed Data

ODP NET Retrieving Typed Data While retrieving values from OracleDataReader we can extract information available in individual columns of a particular row either by using column ordinal position values or column names mosgoogle Retrieving Typed Data Using Ordinals ODP NET provides data specific enum
 

ODP.NET - Retrieving Data Using OracleDataReader

ODP NET Retrieving Data Using OracleDataReader OracleDataReader is simply a read only and forward only result set It works only if the database connection is open and it makes sure that the connection is open while you are retrieving data As the data that it retrieves is read only it is a bit faster
 

ODP.NET - Fundamental ODP.NET Classes to Retrieve Data

ODP NET Fundamental ODP NET Classes to Retrieve Data To retrieve data from an Oracle database using ODP NET we need to work with a few of the ODP NET classes At this point we will discuss the most fundamental classes available in ODP NET for retrieving data mosgoogle The following is the list of fun
 

Sponsored Links

 



About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape