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
- 2 Answers
- 4100 Views
- I also Faced
- E-Mail Answers
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
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Can you please send me the migration related issues .
Can more than 1 metric be applied on an analytic in business objects?
Explain when we use aggregate awareness function in designer?
When we use aggregate awareness function in designer?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
how get the grand total in master-detail report?
What is difference between webi and infoview?
How to create Index to the table in the universe designer and how it improves the Query performence
Differences between business objects and web intelligence reports?
How to generate the report from excel sheet?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
what is the difference b/w the refresh and buffered data?
Explain is data mart?
