In an existiing Framework model, how will you add a new
column to the existing table?
- 6 Answers
- 19054 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 |
what is logs in cognos
1 Answers Target, Thomson Reuters,
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
What is Bitmap Index?
Can any one give the example for slicing and dicing of data ?(with simple query)
What are the Ways to Import Data into Catalong?
What is Metrics designer?
What are the ways to import data into catalog?
what was the actual purpose of portfolio in cognos ?
How can you create prompts in framework manager?
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.
actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........
Teradata 
