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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gowthami
U have the below objects
Continent, Country, State and amount
Make sure the objects are in above hierarchy in universe under the class
Result objects: Continent and amount
Set scope of analysis as level 3
Create a tabular report with continent and amount.
You will be able to do drill operations
| Is This Answer Correct ? | 0 Yes | 0 No |
I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in
What is thumbnail?
Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?
What is the user Object ? What is the need of it?
when and where we use @varialble function
while migrate bo 5.1 report into boxir2 ,what are the problems faced
i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?
How do scheduling the report in BO XIR2? can you say what are they steps?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
what is projection function in SAP BO