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....
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
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
Why are meta service important then other services?
whats the difference between previous version of cognos and cognos 8 BI?
What is a Transformer?
How do we convert from Numeric to be Words?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
Why cognos decision stream is used?
What is the use of powerplay web viewer in cognos?
What is the use of Cognos scenario?
What is the information present in the cognos configuration file?
Please explain the different stages in creating a report in cognos report net?
what are the errors faced while bursting the reports and how to solve those errors?
how u will design the report if the objects are available
What is catalog and types of catalogs in cagonos and which is better?
What are the types of security?