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
- 5191 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
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What is main advantage datawarehousing over oracle?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
What is meant by alternate drill down with ex?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Write some methods to apply securities in framework manager model?
What is drill down and slicing and dicing whats the difference between them?
what is online view?
What is a Cube?
Can you define report item?
what is power prompt in cognos ep7series?what is the use of this?
What are the advantages of cognos?
What is meant by junk dimension?
What is the difference between a cascading report and drill through report?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
