Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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



More Cognos Interview Questions

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?

7 Answers   Cognizant, Cognos,


What is Bitmap Index?

0 Answers  


Can any one give the example for slicing and dicing of data ?(with simple query)

3 Answers   Cognos,


What are the Ways to Import Data into Catalong?

1 Answers   Cognos, IBM,






What is Metrics designer?

0 Answers  


What are the ways to import data into catalog?

0 Answers  


what was the actual purpose of portfolio in cognos ?

1 Answers  


How can you create prompts in framework manager?

4 Answers   Tech Mahindra,


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?

7 Answers   Cap Gemini, iFlex,


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.

5 Answers   HSBC,


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..........

1 Answers  






Categories