i am having a table having name cust_employee.i use this
table in my model after i published that to cognos
connection .i generate some reports.
after that in my data base cust_employee table is changed
to cust_emp.how can i get this table into my report.i again
import and published means its time consuming,in simple how
can get the changed table in to my model pls pls ans me....
Answers were Sorted based on User's Feedback
Answer / lakshmi
How about creating a synonym at the database level?
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shreyas
Without Importing the table into Model just change the sql
of the Table.
For Example: Initial in model the database layer Query
Subject contains as Select * From [Datasource Name].
OLDTableName
Replace with
Select * From [Datasource Name]. NeWTableName
and publish.
This is one of the method.
Second Method:
In report studio Create a sql Query and point the report to
samequery. (this is simple without importing and publishing
the pakage)
Is This Answer Correct ? | 0 Yes | 0 No |
How can I test reports in cagonos?
what is mean by cognos powerhouse?
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
What is the difference between cognos 8.2 and cognos 8.3?
3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?
1 Answers IBM, Thomson Reuters,
How do you call a store procedure within a transformation?
What is the difference between the content store and content manager?
diff b/w dimension and regular dimension
What are differences between Reporter report and Explorer report?
what is the use of layout calculation?
What is the use of powerhouse?
What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?