I want to do on drill calculation?
Actually My report is like
Continent Amount(Global Currency in dollar)
ASIA 200
UK 100
On Drill ASIA
Country Amount
INDIA 5712(120*47.6)
SINGAPORE 128(80 * 1.6)
On Drill INDIA
State Amount
DELHI 3712
CHENNAI 2000



Answer Posted / itesh

Dear,

U have now 3 reports with u

1st one u have already developed

2nd one u develop country and amt where create filter
Continent =? Prompt Continent?

Then put a drill from 1st report select the second report u
can point the data item continent =prompt of second report
(? Prompt Continent?)

Then follow the same in third and point 2nd to third report.

Nothing is impossible........

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What task is 98% of the required work of a business analyst?

581


Explain what task is 98% of the required work of a business analyst?

604


What is the difference between the public object&schema object?

579


How to execute the plsql procedure from the report by clicking with mouse?

620


is it possible to export the webi reports to crystal reports?with out using businessview?

1822






(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1000


When to use local filter and when to use global filter?

603


What is aggregate table and aggregate fact table ... Any examples of both?

614


What is difference between webi and infoview?

618


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

591


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2403


Explain what is the difference between business requirement document and use case document.

579


Explain what is the difference between slice and dice and cross tab report?

608


What is the difference between user and versatile user?

585


How many universes can be created in a project?

599