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
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 about alerts in bos, under what situation we need to use alerts?
What is the difference between user and versatile user?
Explain what task is 98% of the required work of a business analyst?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What Is The Difference Between Oltp And Olap?
Explain how we drill up week to month?
what is the difference b/w the refresh and buffered data?
Can we configure two instances of CMS pointing to two different CMS system databases?
What is a fantrap in business objects?
What task is 98% of the required work of a business analyst?
Explain the difference between union and group?
What three things do you consider to be the most important factors for a manager?
Give some information on report bursting?
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...
What are the steps to be taken to schedule the report?