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
- 4542 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a Query Subject?
What are the different types of reports present in cognos?
How can I test reports in cagonos?
Write types of folders present in cognos?
Can you define a query subject?
Explain what is the difference between native sql and cognos sql?
How to select multiple values from type-in prompt?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
Can you define snapshot?
how can you get the errors in job? when loops are araised we get error?
Write some methods to apply securities in framework manager model?
----------------Diff b/w Dimensional modeling and Relational modeling?
difference between impromptu and cognos8
What is a dimension?
What do you mean by drill across?
