What are the problems you have faced recently while
developing reports in report studio? And how did you solve
those problems?
This question is asking in many interviews,,,,so pls help
me,,,,,
Answer Posted / beckham
1.Make sure all the necessay items are available in the
model
2.Validate expressions and drill deep into the issue and
fix it one by one.
3.Check the synatax of the functions used and make sure it
is available in the database( teradata,db2,oracle) you use.
4.In case of data issues make use of the SQL generated.
5.While using conditoal variables amke sure that particular
item is available in the layout....
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is dtm?
What is the function of model design accelerator?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
Explain informatica architecture?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
How to do Performence Tunning in Cognos Reports?
how can I test reports in cagnos?
how to explain health care project and which reports we can create in health care doain?
How can you link a query to a data container manually in Report Studio?
Which lifecycle we will use for reporting?
Define query studio?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?