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 stitched Query?
what is the procedure for scheduling conditional rendering?
How do we convert from Numeric to be Words?
can anybody tell me..how to enter with fake exp..wt r all the documents to carry while attending the interview..how to answer that i am working in..
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)
what are the dimensions that you have in your current project?list them?
what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
what are the applications of the tabular model ????
What is the difference between List and Cross tab? Could some on explain with an example..
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
What is difference between primary key and unique key constraints?
--------------Diff b/w ODS and OLAP?