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 ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?
I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?
5.what is LOV? where it is store?
How many built-in objects are created in Business Objects repository?
What is the prm file ? can anybody explain me ?
Explain is there any default username & pwd for bo designer & supervisor?
When we go for OLAP , and When we go for OLTP for generating the reports ?
CAN A REPOSITORY CONTAINS REPORTS?
what is canned universe and canned reports in bo?
what is crystal reports?how to migrate them?
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?