In an existiing Framework model, how will you add a new
column to the existing table?
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 |
where we use page break and page set. with example?
In how many ways we can apply the security to a cube in Transformer? Explain?
What is looping and how to avoid it in framework manager?
how many types of keys are there i.e primary key and foreign key etc..?
what type of charts we create mostly in realtime? plz help
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?
Can you define pivot?
What is limited local? and the uses?
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?