In an existiing Framework model, how will you add a new
column to the existing table?
Answer Posted / akhilesh pyasi
You can add any combination of objects to a query subject,
such as query items, other query
subjects, or dimensions. You can add stand-alone
calculations and filters, and you can also embed
calculations and filters in the query subject.
Steps
1. Select the query subject that you want to add items to.
2. From the Actions menu, click Edit Definition.
3. To add items to a data source query subject, click the
SQL tab, and from the Available
database objects box, drag objects to the SQL box.
You can also insert a data source reference, insert a
macro, embed a calculation, and embed a
filter.
4. To view the system tables from the data source, select
the Show System Objects check box.
5. To add items to a model query subject, click the Query
Subject Definition tab, and from the
Available Model Objects box, drag objects to the Query
Items and Calculations box.
You can also embed a filter.
You can change the order of items and calculations for a
model query subject. However, if the
query subject contains a query item folder, you can change
the order only in the Project
Viewer.
6. If you want to test the query subject, click the Test
tab.
7. If you want to view the SQL, click the Query Information
tab.
8. Click OK.
If any modifications invalidated relationships, other query
subjects, calculations, or filters, a
warning appears.
Usage and aggregation property values are regenerated to
reflect the changes that you made.
9. Ensure that the Usage and Regular Aggregate properties
are set how you want them.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is cognos reporting tool?
What are query items?
What is the difference between ‘macro’ and ‘prompt?
What is Bitmap Index?
What is the difference between a cascading report and drill through report?
Write types of folders present in cognos?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
How to create model and how to test model?
Why need staging area database for dwh?
What is the model filter?
What is looping and how to avoid it in framework manager?
What is the use of powerplay web viewer in cognos?
How do you Parametermap variables in Quiries?
What are all the types of gateway used in Cognos?
What are various types of gateways in cognos?