In an existiing Framework model, how will you add a new
column to the existing table?
- 6 Answers
- 22019 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / x
First the new column shud reflect at the database
side.after that if we just say Update query subject then
the new column is automatically reflected in the physical
layer.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / 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 |
Answer / jack
select the query subject,in which we willdevelope the new
column,and right click, select edit definition and then in
the existing query,add the new column and test it.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rizwan
hi buddies which gen u are now ? There are couple of good
techniques to update a query subject with the new database
changes... one like using logs
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / palzkumar
Akilesh was right, wecan create any new column, as well as,
calculated column like gsv (qty *rate = value)
rgds
palz
| Is This Answer Correct ? | 0 Yes | 0 No |
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
How is possible this scenario using in type-in prompt.?
Give me any example of semi and non additive measures?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
how u provide security to reports??how u provide security to packages ?
wt is scope relationship?
How to upgrade drivers in Cognos 8?
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
how you create security to reports?
Can i apply drill through on master detail relationship report?
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
------------ Diff b/w MemberCaption and MemberDescription?
Teradata 
