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 |
Can you explain new content durability?
please tell me architecture of the cognos8?
write a query to display to 10 max record from the employee table?
How to create a Left Outer Join in FM? Please explain.
What are the types of folder present in cognos?
pls any body give the cognos 8 versions release year.
what are diff b/w cognos and business objects
how to handle multifact?
What are all the advantages of Cognos?
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
---------------Tell me about DWH Concepts?
what is bobble chart?