Interested to Buy Any Domain ? << Click Here >> for more details...
In an existiing Framework model, how will you add a new
column to the existing table?
- 6 Answers
- 23872 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 slowely changing dimensions?why we are used SCD?
Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com
what is report view?
Which studio is used to create reports?
How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
what is your project workflow and your role in the project?
how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.
------Diff B/W DrillThrough and master and Detailed Report?
How do we drill through from a powerplay cube to reportnet?\
Teradata 
