Interested to Buy Any Domain ? << Click Here >> for more details...
In an existiing Framework model, how will you add a new
column to the existing table?
- 6 Answers
- 24378 Views
- CTS, I also Faced
- E-Mail Answers
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
Why need staging area database for dwh?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What are the types of hierarchies?
How to Reset Pagenumbers in one report.
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.
what are the errors faced while bursting the reports and how to solve those errors?
what are the filters in framework manager and report studio?
how to perform single sign in cognos by using url?
what is the difference between list report and crosstab report?
What are types of batch available in cognos?
What do you understand by user class in cognos?
Write some methods to apply securities in framework manager model?
What is called cognos reporting tool?
Can you define metrics designer?
What is main difference mapplets and mapping?
