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 to hide the prompts
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
What is called Cognos powerplay?
Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
How do you call a store procedure within a transformation?
what is the difference between Cognos EP7 series and Congos8?
what is loop in frameworkmanager ?
In how many ways we can apply the security to a cube in Transformer? Explain?
What is the importance of Dimension in the cognos.
Explain the difference between native sql and cognos sql?
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.