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 |
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What is the difference between the Webintelligence and desktopintelligence?
how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?
how to find the size of the report
how can we overcome by loops?and also is it possible ,one user can different universe
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
What is Complex Reports?
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
What are the steps to be taken to schedule the report?
12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?