In an existiing Framework model, how will you add a new
column to the existing table?
- 6 Answers
- 22989 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
How to test a cube?
What is difference between data mart and data warehouse?
what is catalog and types of catalogs in cagnos and which is better?
What is model?
What is the use of report studio?
how to perform single sign in cognos by using url?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
what is the role of cognos comsultant?what actually it means?pls reply
7. What is performance tuning?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What is meant by Reportstudio shortcut?
What is the difference between group and associare?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
Explain difference between powerplay transformer and power play reports?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
