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
- 5197 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 |
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
Can you define query studio?
what is boxtype
in u r data u having duplicates how to fetch the latest data in our report?
what is model and say about process how to create model and how to test model?
how to create cubes in transformer ?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?
where exactly determinants are used in cognos framework manager?
Teradata 
