Advanced reporting

Advanced reporting - Term Definition Metadata database...

Info icon This preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Term: Metadata database stores what objects. Definition: Application objects, configuration objects and schema objects. Term: A report is... Definition: The focus of business intelligence investigations. Term: What objects comprise a report? Definition: Template, filter, view Term: Three tier reporting architecture... Definition: Data warehouse, metadata, iserver, and desktop Term: Four-tiered bi architecture... Definition: Data warehouse, metadata, iserver,desktop, and Microstrategy web
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Term: Report execution query flow Definition: 1 request is made from a client interface., request passed to the kernel, kernel checks cache, obtains report definitions from metadata, request sent to SQL engine, results sent to query engine, query engine hits data warehouse, results to analytical engine where final calculations are performed then formats results and returns to kernel. Term: To have a report retained in cache, you must... Definition: Save and close a report,then execute it. It is not sufficient to run the report from desktop only. Term: Iserver checks the following keys to see if a report is in cache.. Definition: Report Id, template ID and version, filter ID and version, security filter ID, prompt answers. Term: You can associate the following keys with a report... Definition: User key, DB connections ID, database login ID.
Image of page 2
Term: To run a report, the request can be made from what applications? Definition: Desktop, mstr office, web Term: T/F re-executing a report hits the cache first, then runs the report again, only if necessary? Definition: False. Re-executing means the report is ran against the DW to ensure the cache is updated with the latest data. Term: T/F re-execution works very similar to re-prompt? Definition: False. Re-execute does NOT re-prompt the prompts questions. Term: Defining the level for a metric involves considering what 3 settings? Definition: Target, grouping, filtering Term: Re: level metrics, the target is the ________ level at which the metric calculates. Definition: Attribute. Any attribute or hierarchy can be the target.
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Term: Grouping determines ..... Definition: How the metric aggregates. Term: Grouping options are .... Definition: Standard and none. Term: Metric filtering option governs the relationship between .... Definition: ...the report filter and the calculation of the metric. Term: Filtering options include .... Definition: Standard, absolute, ignore, and none. Term: Re: SQL, when Filtering is set to standard it means...
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern