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 |
How many universe dfi you create if you have 2 years of experience in BO
Explain about alerts in bos, under what situation we need to use alerts?
HOW TO PUBLISH A REPORT IN BO?
Difference between Decode and Case?
8 Answers Polaris, TCS, Wipro,
can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?
What is maximum number of promts we can give in a BO report?
What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?
How to make alternative rows red and green in WebI Report?
What is the test methodology for testing BO Universes?