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 |
What is a loop? How can we overcome?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
Can any one tell me for business objects what we need to study means some body tole me that we need DW,ETL,SQL.... is this is necessary..?
How to Avoid the overlaping the blocks in WEBI.
What is a bo repository?
1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?
Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?
Explain in detail about type 2(scd),
what are the day to day activities of BO administrator ?
whats the diff between break and section
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?