Interested to Buy Any Domain ? << Click Here >> for more details...
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....
- 2 Answers
- 5118 Views
- I also Faced
- E-Mail Answers
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 |
-----------What is member Description?
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?
Can you define materialized view?
What are all the types of gateway used in Cognos?
Diff b/w Crossproduct and Outerjoin?
How can we find out cardinality between two tables?
can we insert list report in corsstab report?
How applying "Level Span" in Cognos 8.3?
what is stitch query in reportnet?
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
What is set to be cardinality?
Teradata 
