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
- 5101 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 are shortcuts? Where it can be used? What are the advantages?
What is the difference between a data mart and a data warehouse?
What are the components used in web tier?
Can you define confirmed dimension?
What is Additive function?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
How create measures and dimensions?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What are initial page components of Cognos connection?
how can I test reports in cagnos?
What is the function of cognos dispatcher?
Can you explain dynamic query mode?
What do you understand by the term 'aggregate cache'?
What is metric store database?
