What is drill across ? can anybody explain me in detail?
Answer / vikram
Drilling across:
When you drill down and up you move through the levels of
the same hierarchy. However, if you cannot find the answer
to a question by analyzing data in its current hierarchy,
you can move to another hierarchy to analyze other data.
Example: Move from analyzing Resort to Sales.Your report
displays data for Resort, which belongs to the Resort
hierarchy.
The report also contains Year, which belongs to the Sales
hierarchy, but the data for Year is not currently
displayed. If you drill across from Resort to Year,
you can then drill down on the next dimension in the Sales
hierarchy. You can also drill across to other hierarchies,
or back to the hierarchy you were originally working in.
Drilling across opens up new paths that you can follow
when analyzing data.
Before you can drill across, your report must contain
dimensions from more than one hierarchy. If this is not the
case, you can:
• Retrieve data for dimensions from more than one hierarchy
by expanding
your scope of analysis, or
• Create new hierarchies inside the report.
Thanks,
Vikram
Is This Answer Correct ? | 0 Yes | 0 No |
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can i use personal database connection to the Webintellegence reports?
without creating the business view is there possible to create & generate the Crystal reports?
Is there any other repository domains rather than universe, security, document?
Can we take report on Excel in Business Objects?
6 Answers Business Intelligence Analytics, Oracle,
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
how many times can use the union operator in a report?
why we are using derived tables ?how it will help?
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
Tell me the difference between cmc and cms?
What is the difference in creating filters in designer and business objects?