how to Explain a complex report at the time of interview ?
please post the answer very urgent?
Answers were Sorted based on User's Feedback
Answer / p.r. babu
As per my me, complex report is the report which is having
complex quarries and complex calculations example dash
boards with some prompts we can treat as complex report
| Is This Answer Correct ? | 14 Yes | 6 No |
Answer / vikram
Complex report is a general question asked normally during an interview.
So when asked in interview you can say like this -
Almost every reports are complex in nature since it happened many times that, the user require some sorts of customization and thus reports get complexes.
then next, say about your project work , i mean the the work which you have performed in the reports while developing them or while customizing them.
Say the interviewer about the webi features which you have used and made the reports complex.
For instance - when we have multiple data provider and further we are using merge functionality then reports normally get complexes.
further say them few of the formulas and variables which you have recently used in the reports as i am pretty sure you won't remember all that you have used in past.
For instance when we have YTD functions in the reports and along with that when we got calculation context like (FOR ALL, FOR EACH, IN) then the reports get complex. Say the interviewer about the scenario where you have used these calculation context and why you have used.
Apart from that, let them know how you have resolved the errors which might have came while development of reports and how you further resolved it.
If you wish to say some more then you can go with the queries that you have done modification to enhance the performance.
More to it, if you got charts and cross tabs in the reports and along with that tables are there and further linking them and filtering them makes reports complex too.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / joydeep
complex report is nothing but a multi query, multi fact
report with prompts and probably drill through.
this can be a pretty complex report.
| Is This Answer Correct ? | 8 Yes | 11 No |
What is Star schema group?
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
What is Additive function?
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....
wt is the differnce between Block & conditional block ?
Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
write a query to display to 10 max record from the employee table?
-------------Diff b/w Union and Unionall?
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?