The scope of analysis for a query is extra data that you can retrieve from the
database to give more details on the data returned by each of the objects in a
query. This extra data does not appear in the initial result document, but it
remains available in the data cube, so you can pull this data in to the report to
allow you to access more detail at any time. This process of refining the data
to lower levels of detail is called drilling down on an object
In the universe, the scope of analysis corresponds to the hierachical levels
below the object selected for a query.
You can set this level when you build a query.
You can also create a custom scope of analysis by selecting specific
dimensions to the Scope of Analysis pane.
For example, a scope of analysis of one
level down for the object Year, would include the object Quarter, which
appears immediately under Year.
Subscribe To
Posts
Comments
Subscribe to:
Post Comments (Atom)
Popular Posts
-
n Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement. The syntax for the decode function is: ...
-
Designer lets you save universes in either enterprise or workgroup mode. Enterprise mode means that you are working in an environment with a...
-
Define what a Loop is Detect and recognize loops in Universe Using Aliases and Contexts to resolve the loops Identify when in the design ...
I am a report designer and create a report with Year and Revenue and I set the “Scope of Analysis” to 1 level.
As such when I run this report , I can drill from Year-->Quarter
but again Quater goes to month and again drill from month to week why its happen when i applied only level 1 for scope of analysis.