Can anybody tell me the difference b/w canned and
adhoc
reporting?.
- 5 Answers
- 60974 Views
- I also Faced
- E-Mail Answers
Answer Posted / jigar patel
Canned reports are the predefined reports, where in which you get the requirement from the Client through a requirement specification document. Canned reports are developed by BI-Developers. Canned reports are meant for END USERS or CLIENTS who are not supposed to have any technical knowledge.
Adhoc reporting is functionality/feature provided by BI tools where users can create reports on their on using the Business Schema..In Microstrategy language it is the ability of the tool where business-users can create reports on the fly using any of the attributes or metrics from the project schema.
In ad-hoc reporting, technical user(BI-Developers) set up the BI solution, connect it to the data-sources, establish security parameters and determine which objects business users can see. From that point on, the actual reports are created by BUSINESS USERS. Its like creating platform from BUSINESS USERS where they can create reports for themselves without requiring any technical knowledge. So that business users can provide live reporting to the END USERS or CLIENTS.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Did you face any problems while creating reports? Name? Solutions?
What is the difference between slice and dice and cross tab report?
Explain what are the measure objects?
explain in detail about type 3?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
any difficulitis have you phase while creating bo reports and how did u solve it
What is a bo repository?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain about a task that really tested your analytical abilities?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain when to use local filter and when to use global filter?
how many reports have u created ? explain a few.
In banking domain how many Fact tables,Dimension table are present?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
