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
- 4097 Views
- I also Faced
- E-Mail Answers
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 the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
Explain what is the difference between slice and dice and cross tab report?
What is the strategies ? what is the need of the strategies?
how do we apply sql query on selected variables?
What are the data types present in bo? What happens if we implement view in the designer and report?
How will you move reports from Dev to QA in BO
Explain is there any other repository domains rather than universe, security, document?
What are universe parameters?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
0 Answers Banking, Genpact, TCS,
HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?
What is the prm file ? can anybody explain me ?
difference between xir2 and 6.5 version
Teradata 
