In an existiing Framework model, how will you add a new column to the existing

Categories >> Software >> Data Warehouse >> Cognos
Suggest New Category

In an existiing Framework model, how will you add a new
column to the existing table?

Question Posted / bathu

6 Answers
24189 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In an existiing Framework model, how will you add a new column to the existing table?..

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

In an existiing Framework model, how will you add a new column to the existing table?..

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

In an existiing Framework model, how will you add a new column to the existing table?..

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

In an existiing Framework model, how will you add a new column to the existing table?..

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

In an existiing Framework model, how will you add a new column to the existing table?..

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 an existiing Framework model, how will you add a new column to the existing table?..

Answer / x

If Iam wrong pls let me know...

Is This Answer Correct ?

0 Yes

3 No

Post New Answer