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
- 4099 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
How to generate the report from excel sheet?
Explain what are the measure objects?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Differences between business objects and web intelligence reports?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
what is the difference b/w the refresh and buffered data?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
What is a fantrap in business objects?
Explain what are the steps to be taken to schedule the report?
Explain about a tricky situation for which you found a very simple solution?
What would you consider as your biggest achievement and why?
When we use aggregate awareness function in designer?
